06-29-2011 10:02 AM
Hello,
I use Act Premium 2011 with hotfix 4.
I've a dedicaced server for hosting my main database, the operating system is Windows Server 2008 R2. And i've 22 clients with Remote Databases, all of them is on Windows 7 except three on windows Xp.
On my main database i've 5622 file on attachments and the size of main database directory is 2,52Gb.
When clients sync theirs remote databases, each sync will take 1 or 2 hour and the size of each sync is 1 or 2 Gb.
When i launch the sync, i've a popup with many progress bar. The progress bar with the test of connection on the dedicaced server is ok. The progress bar with the change on the main database is ok. When i arrived on the progress bar of the number of files to sync, i've more of 2000 files to sync (Each client sync on morning and in the end of afternoon) and i don't understand why, because we didn't modify more than 30 files by day.
I've test to sync alone several times in a row the number of file to sync change but the size of sync is substantially the same.
I've try to check if the date configuration is the same on the server and on clients and it's the same.
I've no solutions for this problem and I just ask for your help.
Kind regards
Arctica
06-29-2011 10:08 AM
I'd first check in the database file folder - where you see the folders - attachments, templates, etc. Check out the Backup folder - make sure there are no .BAK files hanging out there. These are temporary files created during the ACT! backup process and should be deleted once the backup is successful and the zip file is created. If you are doing a backup every night, this could be part of it...just a first, quick thought.
Second, are the syncs completing - it's just that it is taking forever? Is everyone syncing at the same time, possibly?
06-29-2011 11:04 AM
06-29-2011 01:43 PM
Can you post the error that is given when they sync?
06-29-2011 07:07 PM - edited 06-30-2011 12:16 AM
We have this error when the sync bug :
[ Error | 13/05/2011 16:13:05 ]Message: File synchronisation failed.
[ Error | 13/05/2011 16:13:05 ]Message: Synchronisation has failed. Server Error Description: Agent Facade failed to apply changes. Status Manager failed to apply statuses. Status are not in sync with the source packets
à Act.Framework.Synchronization.DB.SyncStatusManager.ApplyStatus(SyncCommandList statusList, SyncOperationList operationList, SyncEntity remoteSyncEntity, SyncEntity localSyncEntity, SyncFunctionType functionType, Int32& totalFilesSynced)
à Act.Framework.Synchronization.DB.SyncStatusManager.ProcessStatus(SyncMessage syncMessageFromRemote, SyncMessage syncMessageToRemote, SyncEntity remoteSyncEntity, SyncEntity localSyncEntity, SyncFunctionType functionType)
à Act.Framework.Synchronization.DB.SyncStatusManager.ProcessStatus(SyncMessage syncMessageFromRemote, SyncMessage syncMessageToRemote, SyncEntity remoteSyncEntity, SyncEntity localSyncEntity, SyncFunctionType functionType)
à Act.Framework.Synchronization.Agents.SyncAgentFacade.ApplyChanges(SyncFunctionType functionType)
This error doesn't appear everytime.
The problem is with the attachments, i've try to create a remote database without attachments and when i've launch sync, i can make sync in few seconds. When i've a sync with attachments he sends few files and receive a lot of file.
I add the sync log to this reply :
[ Info | 30/06/2011 04:08:35 ]Message: Sync remote client created.
[ Info | 30/06/2011 04:08:40 ]Message: Checking if schema changes are available for sync.
[ Info | 30/06/2011 04:08:44 ]Message: Client establishing synchronisation with server database: SANOTEKPREMIUM20110301
[ Info | 30/06/2011 04:08:51 ]Message: Initial Handshake completed.
[ Info | 30/06/2011 04:08:51 ]Message: Checking if data changes are available for sync.
[ Info | 30/06/2011 04:08:54 ]Message: Client initialized database send session: 53
[ Info | 30/06/2011 04:08:56 ]Message: Client initialized. [ Info | 30/06/2011 04:08:57 ]
Message: Client schema synchronised.
[ Info | 30/06/2011 04:11:47 ]Message: Server initialized.
[ Info | 30/06/2011 04:11:49 ]Message: Server schema synchronised.
[ Info | 30/06/2011 04:38:41 ]Message: Files synchronised.
[ Info | 30/06/2011 04:38:57 ]Message: Content synchronised.
[ Info | 30/06/2011 04:39:01 ]Message: Exceptions synchronised.
[ Info | 30/06/2011 04:39:04 ]Message: Synchronisation completion done.
[ Info | 30/06/2011 04:39:15 ]Message: Synchronisation has completed.
[ Info | 30/06/2011 04:39:15 ]Message: Items sentync - Added 6
Total Records Synchronised - 6Files
- Attempted 49, Completed 49
Exceptions Occurred - 0
[ Info | 30/06/2011 04:39:15 ]Message: Items received:Activity - Added 60,Deleted 1,Updated 21Company - Updated 4Contact - Added 19, Updated 16History - Added 36Security - Added 20, Updated 4Sync - Added 7Total Records Synchronized - 188Files - Attempted 1192, Completed 1192Exceptions Occurred - 0
07-01-2011 01:49 AM
Anyone have an idea for my problem?
Kind regards
Arctica