ACT 2005 for workgroups Hi, in the sync logs I often get exceptions occurred. Can someone explain what these mean. Also if there are explanations for the other items that would be great (eg security, system etc) Cheers [ Info | 30/01/2008 4:32:11 PM ]Message: Items sent: Activity - Added 124, Deleted 6, Updated 12 Company - Added 1, Deleted 52, Updated 943 Contact - Added 14, Deleted 210, Updated 40 History - Added 154, Deleted 84, Updated 3 Metadata - Added 9, Updated 9 Notes - Added 94, Deleted 114, Updated 24 Opportunity - Added 5 Other - Added 4 Security - Added 6, Deleted 3 Sync - Added 10, Deleted 4, Updated 8 System - Updated 1 Total Records Synchronized - 1934 Files Synchronized - 0 Exceptions Occurred - 6
Sync Exceptions are records which could not be resolved, even after a re-try. The most typical example of this is snoozing an Alarm for the same item on both a Main and Remote database then syncing. Other examples are less likely such as the ability to physically add a record to the SQL database due to a datatype violation/mismatch, foreign key constraint violation, etc.
The record counts represent the number of actual physical records synchronized during that session (there's a Sent section and a Received section) stratified by Adds (inserted), Updates and Deletes (your basic CRUD operations). These records are summarized by "subject area" or "domain" as there are many tables (100+) the comprise the ACT! database. So the tables containing the Contact data, for example, will be more than one.
FYI - you can also see some of these domain and corresponding Table counts in the "Sync Preview Report" of ActDiag. To launch ActDiag, from the Windows Start button type in ActDiag and press enter.
Hi, how can I find out what has caused the exceptions. Some syncs show 50+ exceptions, does that mean that a whole heap of data has not been synchronized and if so how can I find out what it was. What happens to data that causes an exception, does ACT try to sync it again, does it get deleted from the client or publisher database etc. Cheers Patrick