Blog

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.

How to Manually Create the Microsoft® SQL Server® 2008 R2 (Express Edition) ACT7 Instance

You have Act! and would like to install on one of the supported Windows® Operating Systems. You would prefer to install the Microsoft SQL Server 2008 (Express Edition) instance for Act! manually. 

This document will provide detailed steps on how to create a Microsoft SQL Server 2008 R2 Express instance for Act! and the installation process for Act!:Notes:

The following information is provided as a convenience.

How to Change the Default Location for Universal Search Index Files in Sage ACT!

Since ACT! 2012 added the Universal Search feature, there have been a few instances when the ACT! Index files have grown very large on the C: drive and needed to be moved to a different drive.

As a Best Practice on servers we tend to try to limit what gets installed to the C: drive so that we can keep it clean and tidy and keep the server running as optimal efficientcy.

Banish 3 Common BI Myths

Business Intelligence (BI) has become a major aspect of business, as such, companies large and small are adopting implementing BI projects. The problem is, this can cause concern regarding job safety among other things. These “myths” can quickly spiral out of control and demoralize a whole office or company.