Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 7 (Corporate Edition) » I've got this sync-ing feeling...
Post new topic  Reply to topic View previous topic :: View next topic 
I've got this sync-ing feeling...
PostPosted: Thu Jan 14, 2010 7:29 am Points: 0 Reply with quote
lisaharris
Experienced Miner
Joined: 07 Sep 2007
Posts: 77
Location: Mt. Laurel, NJ




Sorry, bad pun. I'm just at the end of my rope trying to figure this out.

Earlier this month, and after months of meetings and planning, we realigned our sales force. My involvement was to segment and reassign our GoldMine database. On Monday, January 4, I changed Key4 and Owner on tens of thousands of records. This change was done via a GoldMine Import.

Yesterday I found out that just over 13,000 of the changes didn't sync to the other office. So I reset the sync cutoff date to January 3, and let'er rip. Same count different still this morning.

The only way I could think to get around it was to run a SQL Query between the two Contact1 tables, find the differences, and create a new import table for the other office of the record changes that didn't make it there. It's importing now. Any clues on why something like this would happen?

Currently on 7.00.70304 (moving to 8.5.2 in a couple weeks -- countdown's on!)
SQL 2000 sp4 (Moving to 2005 sp3 soon!)

<-- will be me post-upgrade!!
View user's profile Send private message

PostPosted: Thu Jan 14, 2010 8:59 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Some initial thoughts.

How was the original import accomplished?

I would have indexed both databases before doing the import and doing the sync.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Thu Jan 14, 2010 9:06 am Points: 0 Reply with quote
lisaharris
Experienced Miner
Joined: 07 Sep 2007
Posts: 77
Location: Mt. Laurel, NJ




The original import was done using GoldMine and a dbf Dbase III file that consisted of three fields: Accountno (for matching), Key4 and owner.

Both databases are backed up, optimized and reindexed nightly by SQL jobs.
View user's profile Send private message

PostPosted: Thu Jan 14, 2010 10:42 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




It's always an adventure troubleshooting things like this on 7.0...

That being said...

Are you currently synchronizing with a filter on the site(s)? (Sorry, I should probably know this)

Have you considered doing a global replace on the key4 field with a dbase expression of contact1->key4 ? That might help to kick it in the butt and make some conttlog entries to cause a proper sync.

Did sync actually occur and the transfer sets were exchanged in both directions reliably? It could be that it's such a huge set that the process failed to get it from point A to point B and it haven't had a chance to see those changes yet... ?

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Thu Jan 14, 2010 11:17 am Points: 0 Reply with quote
lisaharris
Experienced Miner
Joined: 07 Sep 2007
Posts: 77
Location: Mt. Laurel, NJ




No filters on the sync.

Never thought to global replace key4, I just went to the other server via remote desktop, logged in to GM and imported the repair file I'd created.

I checked a few of the records' sync spy records and noticed that there was no entry for 1/4 (when I did the original data import) on those records in NJ -- the key4 and owner updated correctly.

Even more strange (which I'm finding as I investigate this further) is that I also ran queries to identify reassigned records that had a pending call, then I used GoldBox to reassign those pending calls to their new owners. And those all synced without an issue. So there were calls on sales reps' calendars for records that they didn't own (but should have).

I'm not going to bother with it much more since I'm upgrading to 8.5.2 in about 3 weeks.
View user's profile Send private message

PostPosted: Thu Jan 14, 2010 12:53 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




if I had to guess, I'd say there's a bug in the import wizard in your build of 7.0 and it failed to make conttlog entries when it updated the key4 field. The global replace of the field with itself ought to trigger the appropriate sync response.

You might want to use the territory realignment wizard in the future, however. Wink

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Thu Jan 14, 2010 3:25 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I agree with Doug concerning Global Replace. That just might do it.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Fri Jan 15, 2010 6:37 am Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




Lisa,

Have you thought to delete the TLogs empty on both sides the for doing your full synchronization, minus link documents, from 1/1/980?

_________________
DJ Hunt

Phone: (978)342-3333
Email: DJ@DJHunt.US

GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

I've got this sync-ing feeling...
  ContactReview Forum Index » GoldMine 7 (Corporate Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin