ERROR: “RESOLUTION OF THE DEPENDENCY FAILED” OR “EXCEPTION HAS BEEN THROWN BY THE TARGET OF AN INVOCATION.” WHEN LAUNCHING ACT!

Symptom:
I am attempting to launch Act! when I receive one of the following Errors: “Resolution of the dependency failed.” Or “Exception has been thrown by the target of an invocation.”

Product:
Product Family: Act!
Product: Act! Pro, Act! Premium

Cause:
This error can occur if you have Windows User Account Control (UAC) turned on, damaged preferences, a conflict with an add-on or if you upgraded to Act v16 from a previous version and the shortcut failed to update.

ACT! USERNAME OR PASSWORD RECOVERY

You need to have your username or password recovered for your Act! database. 

If you know your Act! database password, but are unsure of your username, proceed to How to Determine the Database Username. 

If you know your Act! database username, but are unsure of your password, proceed to Username and Password Recovery.

HOW TO UPGRADE TO ACT! V16 FROM A PREVIOUS VERSION

You would like to know the process to upgrade your current version of Act! to Act! v16.
This article provides the necessary information to upgrade your software and database to Act! v16.

Important Notice:
When upgrading a database from a previous version of Act!, it is CRITICAL that you create back-ups of your e-mail and all of your contact database(s). Once you have installed and updated your database(s) you CANNOT revert back unless you have a back up.

HOW TO REBUILD THE ACT! PREFERENCES FILE

You suspect that you have a damaged preference file and would like to rebuild it.
Rebuilding the Act! Preferences can resolve a number of issues. Please be sure that you have a current backup or copy of your database before following the procedure below.

ERROR: “THE DATABASE COULD NOT BE ACCESSED. IN ORDER TO ACCESS THIS DATABASE, CHECK YOUR NETWORK CONNECTION AND VERIFY THAT YOUR DATABASE SERVER IS AVAILABLE. IT MAY BE NECESSARY TO DISABLE ANY FIREWALL SOFTWARE…”

You attempt to open your database and receive the following error message: The database … could not be accessed. In order to access this database, check your network connection and verify that your database server is available. It may be necessary to disable any firewall software on your computer or the server.

ERROR “UNHANDLED EXCEPTION HAS OCCURRED IN YOUR APPLICATION. IF YOU CLICK CONTINUE, THE APPLICATION WILL IGNORE THIS ERROR AND ATTEMPT TO CONTINUE. IF YOU CLICK QUIT…” WHEN CLICKING ON DATABASE LIST IN ACT! DIAGNOSTICS

Symptom:
Error “Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.” when clicking on Database List in ACT! Diagnostics

Products:
Product: Sage ACT!
Version: 2011, 2012

Cause:
This issue can be caused by one or more databases improperly connected to Microsoft® SQL Server®.

Solution:
There are two possible solutions for this issue:

Use ResetSQL.bat file

Close ACT! Diagnostics.

ERROR: “CANNOT INSERT DUPLICATE KEY ROW IN OBJECT ‘SYS.SYSCOMMITTAB’ WITH UNIQUE INDEX ‘SI_XDES_ID’… ERROR 2601″ WHEN ATTEMPTING TO BACKUP, COPY, REPAIR, CREATE A REMOTE, OR SYNCHRONIZE AN ACT! DATABASE

This is an error associated with Microsoft® SQL Server® 2008 R2. You can resolve this issue by applying Cumulative Update 8 for SQL Server 2008 R2 Service Pack 2, then running the batch file provided in this article to fix the issue in your database(s). Please follow the exact steps below:Step 1: If necessary, apply SQL Server 2008 R2 Service Pack 2If you are not already running Service Pack 2 you will need to apply this update on the Act! server and all remote database machines with Act! and SQL Server 2008 R2 installed.