Sync issue with ACT! 9

[Swamig007]

Hi,

I am trying to resolve a sync issue with ACT! Premium 2007 ... A laptop user has not been able to sync from remote location ... The database size in the remote laptop is 168 MB... Please help in pointing me to the right approach to get the sync completed ...



The version running on the Laptop is:

ACT! by Sage Premium for Workgroups 2007 (9.0) (EX Edition) Version 9.0.1.162

The sync log is as follows...

======== SYNC SESSION - 6/14/2008 11:14:20 AM ========

[ Info | 6/14/2008 11:14:20 AM ]Message: Sync remote client created.
[ Info | 6/14/2008 11:14:22 AM ]Message: Checking if schema changes are available for sync.
[ Info | 6/14/2008 11:14:37 AM ]Message: Client establishing synchronization with server database: xxxxxxx
[ Info | 6/14/2008 11:14:48 AM ]Message: Initial Handshake completed.
[ Info | 6/14/2008 11:14:48 AM ]Message: Checking if data changes are available for sync.
[ Info | 6/14/2008 11:14:53 AM ]Message: Client initialized database send session: 1
[ Info | 6/14/2008 11:15:22 AM ]Message: Client initialized.
[ Info | 6/14/2008 11:15:23 AM ]Message: Client schema synchronized.
[ Info | 6/14/2008 11:15:25 AM ]Message: Server initialized.
[ Info | 6/14/2008 11:15:26 AM ]Message: Server schema synchronized.
[ Info | 6/14/2008 11:38:43 AM ]Message: Files synchronized.
[ Error | 6/14/2008 11:38:53 AM ]Message: Failed to synchronize with the server. Synchronization failed due to an out of memory error on the server.



databas5 Database Sync Preview Report from ACTDiag

Jun 15 2008 8:55AM
Database Product Version: 9.00.2170.00
Database Server Name: SALESTABLET2\ACT7
Schema Version: 09.01.0152.0000
Schema Date: 2008-05-27 18:09:14.320
Database File Location: C:\Documents and Settings\Administrator\My Documents\ACT\ACT for Windows 9\Databases\databas5.ADF

Sync Role: Subscriber
Is Publisher: 0
Is Subscriber: 1

******************************************************
FIELD LEGEND:
LAST SUCCESSDATE - The successful "sent thru" datetime from this current database.
LAST ATTEMPT DATE - The datetime of the last sync attempt.
LAST COMPLETE DATE - The datetime the last sync actually finished/completed.
******************************************************


----------------------------------------------------------------------------------------------------
SYNCDBID: 1 (Current Database)
DATABASE TYPE: Desktop
DATABASE: databas5
PARENT DATABASE: 3 - Company1
LAST SUCCESS DATE: May 27 2008 6:35PM LAST ATTEMPT DATE: Jun 14 2008 3:14PM
LAST COMPLETE DATE: May 27 2008 6:35PM SYNC DUR(MINUTES): N/A
RECV SUCCESS DATE: May 27 2008 6:35PM RECV ATTEMPT DATE: May 27 2008 6:35PM
ATTACHMENT SYNC: 1
SUPPLEMENTAL SYNC: 1

TABLEDOMAIN TABLENAME ADDS UPDATES DELETES
--------------------- --------------------- --------- --------- ---------
Activity TBL_ACCESSOR_ACTIVITY 29 126 0
Activity TBL_ACCESSOR_ACTIVITY_CLEARED 1 0 1
Activity TBL_ACTIVITY 52 388 0
Activity TBL_ALARMSNOOZE 0 0 1
Activity TBL_COMPANY_ACTIVITY 80 0 0
Activity TBL_CONTACT_ACTIVITY 89 0 4
Activity TBL_GROUP_ACTIVITY 1 0 0
Attachment TBL_ATTACHMENT 167 0 164
Company TBL_COMPANY 0 26 0
Contact TBL_ADDRESS 99 4 5
Contact TBL_CONTACT 106 1520 7
Contact TBL_CONTACT_EXTERNALMAP 0 0 3
Contact TBL_EMAIL 102 3 5
Contact TBL_PHONE 95 1 6
Contact TBL_SECONDARY 2 0 0
Group TBL_GROUP 0 3 0
History TBL_COMPANY_HISTORY 47 0 0
History TBL_CONTACT_HISTORY 320 0 7
History TBL_HISTORY 360 4358 0
History TBL_OPPORTUNITY_HISTORY 5 0 0
Metadata TBL_PICKLIST 0 1 0
Metadata TBL_PICKLISTITEM 3 0 0
Metadata TBL_PROCESS 1 0 0
Metadata TBL_STAGE 3 0 0
Note TBL_CONTACT_NOTE 1 0 0
Note TBL_NOTE 0 1210 0
Opportunity TBL_OPPORTUNITY 5 220 3
Opportunity TBL_OPPORTUNITY_PRODUCT 270 0 3
Security TBL_CONTACT_ACL 104 0 25
Sync TBL_SYNCCONTACT 106 7 0
Sync TBL_SYNCCONTACT_ACL 424 0 0
Sync TBL_SYNCDB 0 2 0
Sync TBL_SYNCSET 0 1 0
Sync TBL_SYNCSUBSCRIPTION 104 0 5
System TBL_ACCESSOR_PREFERENCE 0 2 0
Files Files 205 2 90
TOTALS: 2781 7874 329

LAST SYNC SESSION (SENT) STATISTICS:
DATASEGMENT STATUS ADDS UPDATES DELETES
------------ ------------ --------- --------- ---------
DATA Completed 1116 964 0
DATA Incomplete 0 80 0
DATA Never Sent 0 6667 164
FILES Completed 202 2 0
SCHEMA Completed 204 0 0
TOTALS: 1522 7713 164

FIRST 25 FILES LOGGED (EXCLUDING Never Sent AND Incomplete) SINCE THE LAST SYNC:
FILENAME ACTION STATUS DATETIME

 

[GLComputing]

Have you tried runnin all the ACTDIAG repair options (including the Schema and other repairs) on BOTH Publisher and Subscriber?

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[Swamig007]

Thanks for the reply ... I do not find a repair schema, i did a rebuild of schema and sync objects and i am trying again ... But the sync seems to take around 8 hours to complete, i will update on the status again ...

 

[Swamig007]

No luck the sync failed with the exact same error only that it took a while longer ... Is there a way i can backup the database and restore it in the server, some sort of a manual sync? Please let me know when you can ....

 

[GLComputing]

First, follow this -

http://tinyurl.com/4ll83j

Then -

http://tinyurl.com/4v8zey

or

http://tinyurl.com/4vy8n9

Then you'll have one database and can re-create the remote

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[Swamig007]

Hi Mike,

Thanks a lot! the re-create remote trick worked ... I managed to get the successful sync ...

Thanks a ton !!!

Swami

 

[Swamig007]

Hi,

It looks like the problem has not been resolved ...

I did these steps ...

a) Backed up the subscriber and imported it into the main database.
b) re-created the remote database on the main ACT! server.
c) Deleted the database in remote computer and restored the recreated rdb it in the remote computer...

Everything looked fine... But the user @ the remote computer reported missing data. So i imported from the backup and merged it... I got the sync problem again...

I tried to repeat the re-create... I backed up the subscriber database and when i try to import into the main it goes up to 80% and ACT! crashes (it shows importing contacts and when it shows importing histories the entire ACT! crashes)...

Please help!...


Thanks in advance !

swami

 

[GLComputing]

I'd run the ACTDIAG data repair option on both before the import and on the main after the import before cutting the RDB

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au