[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ACT 2006 Remote Database Synchronization Fails

Posted on 2006-05-24
12
Medium Priority
?
630 Views
Last Modified: 2008-01-09
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!
0
Comment
Question by:JWFreedom
  • 6
  • 5
12 Comments
 
LVL 7

Expert Comment

by:TheACTDude
ID: 16752318
I would try recreating the database for that user and resyncing.
0
 

Author Comment

by:JWFreedom
ID: 16752738
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.
0
 
LVL 7

Expert Comment

by:TheACTDude
ID: 16752827
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.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:JWFreedom
ID: 16753392
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"
0
 

Author Comment

by:JWFreedom
ID: 16754211
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?
0
 
LVL 7

Accepted Solution

by:
TheACTDude earned 2000 total points
ID: 16754296
0
 
LVL 31

Expert Comment

by:moorhouselondon
ID: 16754948
Will changing the date of the target pc to be within 28 days help at all?
0
 
LVL 7

Expert Comment

by:TheACTDude
ID: 16755609
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.
0
 

Author Comment

by:JWFreedom
ID: 16755626
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.
0
 
LVL 7

Expert Comment

by:TheACTDude
ID: 16755715
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.
0
 
LVL 7

Expert Comment

by:TheACTDude
ID: 16755750
One more thing, make sure you backup the master BEFORE doing any importing.
0
 

Author Comment

by:JWFreedom
ID: 16793317
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.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question