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.
- Download and save the ResetSQL.bat file in the File Attachments section at this bottom to your Windows® Desktop.
- Double-click the saved file from your Desktop to run it.
- Answer No to the Question “Do you want to turn off Password Policy?” and Yes to the question “Do you want to Reset SQL?“
- After running the file, open ACT! Diagnostics and attempt to access the database list.
Invalid Database Connection
This issue may also be cause by invalid connections to SQL Server by one or more databases. Please see the following Knowledgebase article for more information and suggested solutions:
Error: “Cannot Access Specified Database…” and the Database is Listed as SUSPECT or RECOVERY in the ACT! Diagnostics Utility
Answer ID: 19641