| I've got this sync-ing feeling... | |
Posted: Thu Jan 14, 2010 7:29 am |
Points: 0 |
|
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!! |
|
|
|
|
| | |
Posted: Thu Jan 14, 2010 8:59 am |
Points: 0 |
|
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. |
|
|
|
|
Posted: Thu Jan 14, 2010 9:06 am |
Points: 0 |
|
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. |
|
|
|
|
| | |
Posted: Thu Jan 14, 2010 10:42 am |
Points: 0 |
|
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... ? |
|
|
|
|
| | |
Posted: Thu Jan 14, 2010 11:17 am |
Points: 0 |
|
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. |
|
|
|
|
| | |
Posted: Thu Jan 14, 2010 12:53 pm |
Points: 0 |
|
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. |
|
|
|
|
Posted: Thu Jan 14, 2010 3:25 pm |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
I agree with Doug concerning Global Replace. That just might do it. |
|
|
|
|
Posted: Fri Jan 15, 2010 6:37 am |
Points: 0 |
|
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 |
|
|
|
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
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|