Community
Showing results for 
Search instead for 
Do you mean 
Reply

Synchronization failed to complete, infinite loop, no error message. ACT! 9.0, 2007

Tuned Listener
Posts: 4
Country: United States

Synchronization failed to complete, infinite loop, no error message. ACT! 9.0, 2007

Hello,

 

As the subject says, our office ACT fails to complete sync. with no error message.

We have 15 clients (Win XP) who sync. inside a LAN from a single master DB (not share).

The sync bottom progress bar is stuck at ~80% while the top bar keeps runnin.

task manager shows odd network activity (screen shot - task mgr).

This is a recent problem, we had this configuration running for 2 years now.

Some clients are able to sync. while others can not.

I tried/checked the following:

SP2/3, .Net farmework, IE6/7, DB fix, reindex.

 

At the bottom is a Sync. preview report.txt from a problematic client.

 

I would appreciate any input on the subject.

Thanks,

Mark.

 

 

 

 

 

 

shaily_2007_new Database Sync Preview Report from ACTDiag
Apr 12 2009 11:06AM
Database Product Version: 9.00.2170.00
Database Server Name: SHAILY_LAPTOP\ACT7
Schema Version: 09.01.0152.0000
Schema Date:  2007-05-14 18:00:37.000
Database File Location: C:\Documents and Settings\admin\My Documents\ACT\ACT For Windows 9\Databases\shaily_2007_new.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:  shaily_2007_new
   PARENT DATABASE:  12 - synergy_2006_new
 LAST SUCCESS DATE:  Apr  6 2009  5:30AM      LAST ATTEMPT DATE:  Apr 12 2009  9:03AM
LAST COMPLETE DATE:  Apr  6 2009  5:31AM      SYNC DUR(MINUTES):  N/A
 RECV SUCCESS DATE:  Apr  6 2009  5:34AM      RECV ATTEMPT DATE:  Apr  6 2009  5:34AM
   ATTACHMENT SYNC:  1
 SUPPLEMENTAL SYNC:  1
 
TABLEDOMAIN             TABLENAME                               ADDS        UPDATES     DELETES
---------------------   ---------------------                   ---------   ---------   ---------
Activity                  TBL_ACCESSOR_ACTIVITY                   1           50          0       
Activity                  TBL_ACCESSOR_ACTIVITY_CLEARED           2           0           0       
Activity                   TBL_ACTIVITY                            1           54          0       
Activity                   TBL_ALARMSNOOZE                         6           6           61      
Activity                   TBL_COMPANY_ACTIVITY                    1           0           0       
Activity                   TBL_CONTACT_ACTIVITY                    1           0           0       
Company                TBL_COMPANY                             0           3           0       
Contact                  TBL_CONTACT                             0           60          0       
History                   TBL_COMPANY_HISTORY                     3           0           0       
History                   TBL_CONTACT_HISTORY                     4           0           0       
History                   TBL_HISTORY                             4           0           0       
History                    TBL_OPPORTUNITY_HISTORY                 2           0           1       
Opportunity             TBL_COMPANY_OPPORTUNITY                 1           0           1       
Opportunity             TBL_OPPORTUNITY                         1           35          1       
Opportunity             TBL_OPPORTUNITY_PRODUCT                 1           0           1       
System                  TBL_ACCESSOR_PREFERENCE                 0           2           0       
TOTALS:                                                         28          210         65      
 
LAST SYNC SESSION (SENT) STATISTICS:
DATASEGMENT      STATUS           ADDS        UPDATES     DELETES
------------     ------------     ---------   ---------   ---------
DATA             Never Sent       4           56          23      
TOTALS:                           4           56          23       

 

 

Moderator
Posts: 4,395
Country: USA

Re: Synchronization failed to complete, infinite loop, no error message. ACT! 9.0, 2007

From the report, the remote isn't trying to send any attachment changes to the parent. So it could be an issue with files sending from the parent. What does the sync report look like from the parent database? Try running a repair, rebuild sync objects, and a reindex from actdiag.

 

Database Rebuild and Repair Procedures

Tuned Listener
Posts: 4
Country: United States

Re: Synchronization failed to complete, infinite loop, no error message. ACT! 9.0, 2007

David,

 

Thank you for your reply.

I have spoke with support and they were unable to provide with a solution except

for re-creating the DB on the client.

 

Thanks anyway.

 

Mark.