Link to home
Start Free TrialLog in
Avatar of JWFreedom
JWFreedom

asked on

ACT 2006 Remote Database Synchronization Fails

I had to shutdown the ACT server and move it to a different location.  After the move I wanted to test a synchronization of a laptop.  I particular user receive's the error:

Failed to synchronize with the server.  Exchange of watermarks failed.  The database cannot sync because data is unavailable.  Contact your administrator for assistance.

The sync setup for this use was done a few months ago and the sync worked fine.  Other users (using laptops) are sync'ing with success.

Any ideas to what the problem could be?

Thanks in advance for any/all assistance!
Avatar of TheACTDude
TheACTDude

I would try recreating the database for that user and resyncing.
Avatar of JWFreedom

ASKER

I can only assume that this issue is that the sync didn't happen within the scheduled 30 days and now it won't sync (ACT 2006 feature).  The issue is that I can't find that error anywhere to confirm my assumption.  I don't really want to go through the mess of exporting and importing then recreating the database if I don't have to.
I agree with you. The sync transaction logs aren't matching. Honestly when I come accross this in the field, I bite the bullet and recreate the remote.

To verify go to Help -> About -> Database Info You should see some sync entries there. Compare this on the remote to the parent db.
TheACTDude,

Thanks, I will do that, but FYI here is the log entry on the server:

======== SYNC SESSION - 5/24/2006 10:53:32 AM ========

[ Info | 5/24/2006 10:53:32 AM ]Message: Synchronization started.
[ Info | 5/24/2006 10:53:32 AM ]Message: Server object created.
[ Info | 5/24/2006 10:53:34 AM ]Message: Checking if schema changes are available for sync.
[ Info | 5/24/2006 10:53:47 AM ]Message: Server establishing synchronization with remote database: EP_JL
[ Info | 5/24/2006 10:53:47 AM ]Message: Server generated session identifier: 6cf72dd5-bb26-45e2-b839-d656acb02413:fea2b625-6f3a-433c-8803-e911f76edded

If the sync was successfull it would have made it past the "Server generated session identifier"
The Remote DB shows that the last successfull sync was on 3/28.  It is now 5/24 - so I can almost guarantee that the sync went beyond the 30 days.  I forget how do I export the changed information in the remote DB so I can add it to the master DB?
ASKER CERTIFIED SOLUTION
Avatar of TheACTDude
TheACTDude

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Will changing the date of the target pc to be within 28 days help at all?
Too many items in the ACT database are date specific (activities, notes, histories). I honestly dont know how those would be affected during the sync process. The last thing you want is for all the changes in the remote db to become 28 days old in the master. Interesting thought though

The sync process in ACT is so finnicky. When things go wrong, the best thing to do is just recut the remote and re-sync.
I looked at both documents and maybe I overlooked it, but I don't remember seeing anything about only exporting changed records!  I remember doing this once before, but unfortunately I never wrote it down.
I would import the whole DB. This will guarantee that nothing was left out. ACT will see the records have the same ID's and will merge just the changes in. You shouldnt get any duplicate records.

But Make sure the duplicate checking is set properly.
One more thing, make sure you backup the master BEFORE doing any importing.
Well I tried to import the whole DB to no avail.  So I did a lookup on changed records and did it that ways.  Unfortunately my way may or may not be correct.