Community
Showing results for 
Search instead for 
Do you mean 
Reply

Large synchronizations

New Member
Posts: 3
Country: USA

Large synchronizations

Act Premium 10.0.1 with 3 remote users and a couple local users.
 
The remote users synchronize manually because the process takes forever, even when they are on the local network. If the sync does complete it will show as successful although there is another issue there. The main issue, I think, is the number of changes that are being synchronized. One user can sync, which will take at least 20 minutes, then immediately sync again and it will sync over 10,000 modifications. Does this seem right? Any help would be appreciated.
 
Thanks,
Clark
 
Here is a log from last night.
 
[ Info | 4/3/2008 9:39:33 PM ]Message: Synchronization started.
[ Info | 4/3/2008 9:39:33 PM ]Message: Server object created.
[ Info | 4/3/2008 9:39:39 PM ]Message: Checking if schema changes are available for sync.
[ Info | 4/3/2008 9:39:47 PM ]Message: Server establishing synchronization with remote database: ****_JAN_08
[ Info | 4/3/2008 9:39:47 PM ]Message: Server generated remote sync session identifier: c10d3a7c-8589-46f1-9015-d996deec4297:<****_Jan_08>
[ Info | 4/3/2008 9:39:55 PM ]Message: Checking if data changes are available for sync.
[ Info | 4/3/2008 9:41:38 PM ]Message: Server initialized database send session: 12
[ Info | 4/3/2008 9:41:59 PM ]Message: Server initialized.
[ Info | 4/3/2008 10:03:42 PM ]Message: Synchronization completion done.
[ Info | 4/3/2008 10:03:42 PM ]Message: Synchronization has completed.
[ Info | 4/3/2008 10:03:42 PM ]Message: Items sent:
Company - Added 23, Updated 1
Accounting Link - Added 98, Deleted 26, Updated 1
System - Added 14, Updated 5
Group - Added 1
Opportunity - Added 250, Deleted 39, Updated 71
Security - Added 488, Deleted 1118, Updated 118
Contact - Added 610, Deleted 5, Updated 1003
Note - Added 66
History - Added 3463, Deleted 284, Updated 10
Attachment - Added 261, Deleted 13
Metadata - Added 11
Activity - Added 1349, Deleted 435, Updated 974
Sync - Added 67, Deleted 2, Updated 1
Total Records Synchronized - 10807
Files - Attempted 13, Completed 13
Exceptions Occurred - 0
 
And here's one from a different user from a few days ago.
 
======== SYNC SESSION - 4/1/2008 4:28:10 PM ========
[ Info | 4/1/2008 4:28:10 PM ]Message: Synchronization started.
[ Info | 4/1/2008 4:28:10 PM ]Message: Server object created.
[ Info | 4/1/2008 4:28:13 PM ]Message: Checking if schema changes are available for sync.
[ Info | 4/1/2008 4:28:23 PM ]Message: Server establishing synchronization with remote database: ***_LAPTOP_JAN08
[ Info | 4/1/2008 4:28:23 PM ]Message: Server generated remote sync session identifier: 1f942b35-fcfb-42ad-a3b7-105f7c7fb6fc:<***_Laptop_Jan08>
[ Info | 4/1/2008 4:28:28 PM ]Message: Checking if data changes are available for sync.
[ Info | 4/1/2008 4:29:26 PM ]Message: Server initialized database send session: 45
[ Info | 4/1/2008 4:29:51 PM ]Message: Server initialized.
[ Info | 4/1/2008 4:52:33 PM ]Message: Synchronization completion done.
[ Info | 4/1/2008 4:52:33 PM ]Message: Synchronization has completed.
[ Info | 4/1/2008 4:52:33 PM ]Message: Items sent:
Company - Added 20, Updated 1
Accounting Link - Added 84, Deleted 26, Updated 1
System - Added 14, Deleted 5, Updated 5
Group - Added 1
Opportunity - Added 247, Deleted 41, Updated 307
Security - Added 295, Deleted 2403, Updated 101
Contact - Added 542, Updated 1925
Note - Added 64, Updated 50
History - Added 3296, Deleted 276, Updated 4329
Attachment - Added 247, Deleted 13
Activity - Added 1443, Deleted 444, Updated 4043
Sync - Added 5
Total Records Synchronized - 20228
Files - Attempted 10, Completed 10
Exceptions Occurred - 0
Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: Large synchronizations

Is someone doing large amounts of changes - email merges, imports, mass-updates, etc?
How often do the users sync?
 
You might also see if this fix in ACT! 10.02 has an effect
 
  • Release clears TBL_LOGONHISTORYrecords from Sync Delete Log table during schema updates. This was done to correct any sync sessions which are stuck/incomplete due to excessive records in this table.
  • You can download the current patch from http://www.act.com/support/updates/index.cfm