10-10-2011 08:20 PM
I have installed the latest hotfix (HF2) and I am still having problems with syncronizing. It gets to the end of the second bar and sits there for a very long time. Most times it just times out and throws an error. HELP
David C. Noe
10-15-2011 06:39 PM
Okay gang, I found the magic bullet for my problem. Here are the steps I used. Hopefully, they will help somebody else.
1. Download Service Pack 1 for Microsoft® SQL Server® 2008 R2
(Credit to Stephen King ofAlso Devices Pty Ltd for pointing me towards this solution)
2. Install Service Pack 1 for Microsoft® SQL Server® 2008 R2 on your host machine. Restart host machine after completion.
3. Install Service Pack 1 for Microsoft® SQL Server® 2008 R2 on all of your remote machines. Restart each remote machine after completion.
4. Run ACTDIAG on the host machine, click on "Databases" and then "Database Lists". Identify your database in the list and confirm the version reads "14.510.2". If it ends in "0", your database has not been properly updated to HF2.
If it ends in "2", right-clik on your database and select "Database Rebuild". Within this section you will find "rebuild sync object". I would suggest you run all the rebuilds except the accounting links one, which likely is not relevant. Once that is complete, return to the database list section, and again right-click on your database and select "repair database" and then "reindex" database.
5. Repeat step 4 on all remote machines
(Credit to Ken Quigley of Keystroke Quality Computing Inc for these steps)
I want to also offer big thanks to Steve Carpenter of DataSysUK for all of his ideas and his generous efforts to help! I hope that the ACT! tech support staff reads this and realizes that we seem to be doing their jobs. This has taken me since the 21st of last month to solve with an ungodly number of work and personal hours invested in calls to Gold Tech Support and working on solutions of both mine and other members of the Linked In ACT Fanatics group.
10-24-2011 05:38 PM
I have completed these steps but it doid not solve the problem for me. We have a Windows Server 2003 and 4 remote databases running on Win 7 and Win XP. All have SQL 2008 R2 installed and up to date.
We have had nothing but trouble with syncronization since upgrading to 2012. I would not recommend this upgrade to anyone else!!!
10-24-2011 05:42 PM
10-24-2011 05:56 PM
Thanks for the tip.
I did a clean install of ACT 2012 (including SQL 2008 Express) on a clean Windows Server 2003 operating system. There are no old SQL installations to uninstall.
I have 3 databases, each having 4 remote users on Win 7 and Win XP Pro machines - all have sync issues since upgrading to ACT 2012.
I recreated the remote DBs - no luck
I deleted all RDBs and created new ones - distributedto the users and the first sync went smoothly. After that the issue came up again. Each time a remote user syncs it hangs at the sending and receiving files. The file count is in the hundreds of thousands (a mil on one machine). It will complete if the machine is left for about 4 hours! That's a new machine running Win 7 Premium... The actual file size seems quite low (4-5 MB).
This is very strange....