Community
Showing results for 
Search instead for 
Do you mean 
Reply

Synchronization Memory Error

New Member
Posts: 1
Country: United States

Synchronization Memory Error

We are using ACT 2006, when users try sync we are getting the error. Failed to synchonize with the server. Server Error: Synchronization failed due to an out of memory error on the server. The server has plenty of space and memory. The temp files are cleand up also. Is this releated to database size, or the amount and type of data being sync'd.
Moderator
Posts: 4,395
Country: USA

Re: Synchronization Memory Error

fics,

 

How many remotes do you have syncing and do all of them receive this error?  On the server, try reducing the number of opened applications and turn off or exclude ACT! from antivirus software.

New Member
Posts: 3
Country: United States

Re: Synchronization Memory Error

[ Edited ]

Hello, we have exactly the same problem; we have 5 remote users, and using remote databases. Around a month ago syncing started to throw the Synchronization has failed. Server Error Description: Synchronization failed due to an out of memory error on the server. Exception of type System.OutOfMemoryException' was thrown after over 100 man hours of recreating databases and repopulating them we are right back at the same place we started.

 

I have spoken to several act support people who claim the database is damaged or sql is causing the issues. Oh at there request we ordered a new server and upgraded to 2009 (what a mistake) This made absolutely no difference what so ever, to prove the point I have built yet another server and dedicated windows 2003 server standard with sql sp2 solely for act.

 

Once again this has had no effect, the error is the same as it was 2 servers ago I have used 3 different databases including the demo db. I was told yesterday that we should go argue with Microsoft as this is there issue. “sql express will not hold this many records without corruption”

 

Our setup at this moment

 

Act 2009 std

SQL sp2

Server 2003 (2gb ram – 2 Zeon processors 2GHz) 120mb network connection page file is system managed, and the time out options in actdiag have been increased x 3

No firewall or antivirus installed

 

DB has 2200 records and is around 190mb in size. Sage Act confirms db is ok.

 

 

======== SYNC SESSION - 05/10/2008 02:36:37 ========

[ Info | 05/10/2008 02:36:37 ]Message: Sync remote client created.
[ Info | 05/10/2008 02:36:39 ]Message: Checking if schema changes are available for sync.
[ Info | 05/10/2008 02:36:41 ]Message: Client establishing synchronization with server database: SALES
[ Info | 05/10/2008 02:36:47 ]Message: Initial Handshake completed.
[ Info | 05/10/2008 02:36:47 ]Message: Checking if data changes are available for sync.
[ Info | 05/10/2008 02:36:49 ]Message: Client initialized database send session: 4
[ Info | 05/10/2008 02:36:50 ]Message: Client initialized.
[ Info | 05/10/2008 02:36:50 ]Message: Client schema synchronized.
[ Info | 05/10/2008 02:38:03 ]Message: Server initialized.
[ Info | 05/10/2008 02:38:05 ]Message: Server schema synchronized.
[ Info | 05/10/2008 02:38:05 ]Message: Files synchronized.
[ Error | 05/10/2008 02:41:13 ]Message: Content synchronization failed.
[ Error | 05/10/2008 02:41:13 ]Message: Synchronization has failed. Server Error Description: Synchronization failed due to an out of memory error on the server. Exception of type 'System.OutOfMemoryException' was thrown.

======== SYNC SESSION - 05/10/2008 02:33:23 ========

[ Info | 05/10/2008 02:33:23 ]Message: Sync remote client created.
[ Error | 05/10/2008 02:33:50 ]Message: ACT! is unable to connect to the sync server. Check to be sure "accept incoming sync" is enabled in the main database and that the Network sync service is running. Also be sure you are connected to your network.

======== SYNC SESSION - 04/10/2008 20:49:05 ========

[ Info | 04/10/2008 20:49:05 ]Message: Sync remote client created.
[ Info | 04/10/2008 20:49:06 ]Message: Checking if schema changes are available for sync.
[ Info | 04/10/2008 20:49:08 ]Message: Client establishing synchronization with server database: SALES
[ Info | 04/10/2008 20:49:14 ]Message: Initial Handshake completed.
[ Info | 04/10/2008 20:49:14 ]Message: Checking if data changes are available for sync.
[ Info | 04/10/2008 20:49:16 ]Message: Client initialized database send session: 4
[ Info | 04/10/2008 20:49:16 ]Message: Client initialized.
[ Info | 04/10/2008 20:49:16 ]Message: Client schema synchronized.
[ Info | 04/10/2008 20:50:19 ]Message: Server initialized.
[ Info | 04/10/2008 20:50:20 ]Message: Server schema synchronized.
[ Info | 04/10/2008 20:50:20 ]Message: Files synchronized.
[ Error | 04/10/2008 20:51:31 ]Message: Synchronization has failed. Synchronization failed due to an out of memory error on the server. Exception of type 'System.OutOfMemoryException' was thrown.

======== SYNC SESSION - 04/10/2008 20:39:14 ========

[ Info | 04/10/2008 20:39:14 ]Message: Sync remote client created.
[ Info | 04/10/2008 20:39:22 ]Message: Checking if schema changes are available for sync.
[ Info | 04/10/2008 20:39:25 ]Message: Client establishing synchronization with server database: SALES
[ Info | 04/10/2008 20:39:31 ]Message: Initial Handshake completed.
[ Info | 04/10/2008 20:39:31 ]Message: Checking if data changes are available for sync.
[ Info | 04/10/2008 20:39:33 ]Message: Client initialized database send session: 4
[ Info | 04/10/2008 20:39:35 ]Message: Client initialized.
[ Info | 04/10/2008 20:39:35 ]Message: Client schema synchronized.
[ Info | 04/10/2008 20:40:41 ]Message: Server initialized.
[ Info | 04/10/2008 20:40:41 ]Message: Server schema synchronized.
[ Info | 04/10/2008 20:40:41 ]Message: Files synchronized.
[ Error | 04/10/2008 20:41:41 ]Message: Synchronization has failed. Synchronization failed due to an out of memory error on the server. Exception of type 'System.OutOfMemoryException' was thrown.

======== SYNC SESSION - 04/10/2008 20:34:16 ========

[ Info | 04/10/2008 20:34:16 ]Message: Sync remote client created.
[ Info | 04/10/2008 20:34:30 ]Message: Checking if schema changes are available for sync.
[ Info | 04/10/2008 20:34:39 ]Message: Client establishing synchronization with server database: SALES
[ Info | 04/10/2008 20:34:44 ]Message: Initial Handshake completed.
[ Info | 04/10/2008 20:34:44 ]Message: Checking if data changes are available for sync.
[ Info | 04/10/2008 20:34:46 ]Message: Client initialized database send session: 4
[ Info | 04/10/2008 20:34:48 ]Message: Client initialized.
[ Info | 04/10/2008 20:34:48 ]Message: Client schema synchronized.
[ Info | 04/10/2008 20:35:57 ]Message: Server initialized.
[ Info | 04/10/2008 20:35:57 ]Message: Server schema synchronized.
[ Info | 04/10/2008 20:35:57 ]Message: Files synchronized.
[ Error | 04/10/2008 20:36:58 ]Message: Synchronization has failed. Synchronization failed due to an out of memory error on the server. Exception of type 'System.OutOfMemoryException' was thrown.

======== SYNC SESSION - 04/10/2008 19:48:57 ========

[ Info | 04/10/2008 19:48:57 ]Message: Sync remote client created.
[ Info | 04/10/2008 19:49:15 ]Message: Checking if schema changes are available for sync.
[ Info | 04/10/2008 19:49:30 ]Message: Client establishing synchronization with server database: SALES
[ Info | 04/10/2008 19:49:43 ]Message: Initial Handshake completed.
[ Info | 04/10/2008 19:49:43 ]Message: Checking if data changes are available for sync.
[ Info | 04/10/2008 19:49:48 ]Message: Client initialized database send session: 4
[ Info | 04/10/2008 19:50:02 ]Message: Client initialized.
[ Info | 04/10/2008 19:50:07 ]Message: Client schema synchronized.
[ Info | 04/10/2008 19:51:33 ]Message: Server initialized.
[ Info | 04/10/2008 19:57:01 ]Message: Server schema synchronized.
[ Info | 04/10/2008 19:57:02 ]Message: Files synchronized.
[ Error | 04/10/2008 20:15:15 ]Message: Synchronization has failed. Synchronization failed due to an out of memory error on the server. Exception of type 'System.OutOfMemoryException' was thrown.

Message Edited by blackrain on 10-04-2008 07:32 PM
Moderator
Posts: 4,395
Country: USA

Re: Synchronization Memory Error

Errors with Server Error Description are issues with the server side.  When receiving the error, check the process under task manager to see whats taking up a lot of resources.  More than likely its going to be sqlserver.exe.   You can release the memory by restarted SQL Server (ACT7) service.

 

As a work around, you can create a Windows task to restart the service nightly.

 

 

 

New Member
Posts: 14
Country: United States

Re: Synchronization Memory Error

How do i check the process under Task Manager & Realease the memory by restarting the sql server
Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Synchronization Memory Error

Go to the Services console from Administrative  Tools.  Find the Act7 SQL instance in the Services list, click stop, let it do it's thing.  Then click start.

 

Just be sure that Act! is not open one any machines.

New Member
Posts: 14
Country: United States

Re: Synchronization Memory Error

Is there an article in Act knowledge base that shows me how to do this?