04-26-2012 12:22 PM
I've now seen this 3 times while working with 2 different clients. Synchronization starts to take hours to complete, data isn't transferred and eventually sync will stop working. Meanwhile in the background the database begins to double in size every time a sync is attempted. By the end of a week of attempted bad syncs the database is 10-40 times larger than it should be.
This latest case caused the database ADF file to grow from less than 1GB to 35GB and the ALF to grow from 0.5GB to 7.6GB.
When reindexing the database you can litterally watch the file size go up as well. This is clearly an indication of corruption but fortunately it only breaks the master database and you can grab a remote copy and make it the master, redeploy sync databases and continue from there.
My main concern is figuring out the cause of this issue and how to avoid it moving forward. The client I'm working with now had this happen in December and again in April. The other client also had the issue in December but it hasn't reoccured for them as of this point.
This time around I've:
Completely uninstalleld SQL/ACT and reinstalled directly to 2012 Prem SP1 and then applied Hotfix 3
I've done a "Save copy as" to recreate the database structure
I've run every database rebuild that is available and finished with a reindex
Any suggestions or any other cases of people with this issue? Could it be not database specific but a problem with the software itself?
04-26-2012 01:34 PM - edited 04-26-2012 01:35 PM
This sounds similar to a reported issue from several months ago that has since been resolved. What version of ACT! are you using, including the Hot Fix #? You can go to Help > About ACT! for this information.
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
04-26-2012 01:46 PM