ACT 2009 Duplicates Opportunities when you execute a resync

[jimbrownell55@msn.c…]

When we resync, the Opportunity line items get duplicated.  If we sync 5 times we get 5 entries.  Any idea why?

[ghollister]

Is this happening with all remote users?

[jimbrownell55@msn.c…]

Yes - for all remote users.  Some further information: I am looking at the tables through ACT READER and note:

• The duplication happens in dbo_TBL_OPPORTUNITY_PRODUCT
• All fields except OPPORTUNITY_PRODUCTID and CREATEDATE are the same
• Sync #1, started with 1 product opportunity entry; ended with 2 entries
• Sync #2, started with the 2 entries; ended with 4 entries

Jim

[ghollister]

Has this issue always occurred, or did it correspond with an update to ACT!?

One suggestion would be to run maintenance on the Publisher database, create a new remote database and test sync. Do the following on the Publisher database:

- In ACT!, go to Tools/Database Maintenance/Check & Repair...run twice in a row

- Close ACT!

- Open ACT! Diagnostics by typing actdiag in the Run box from the Start menu

- In ACT! Diagnostics, select Databases, then Database List and highlight the Publisher database on the list

- Right-click on the database and run the following maintenance items, in this order:

Database Fixes/Schema Update/Fix Known Schema Update Issues

Database Rebuilds/Rebuild Schema

Database Rebuilds/Rebuild Sync Objects

Reindex

You can also try running this same process on one of the remotes and testing sync. You can also determine if this is database-specific by opening the demo database (ACT11Demo), enabling sync, creating a remote and syncing (you will need to add the Demo to your sync service if using Network Sync).

[jimbrownell55@msn.c…]

This began after we upgraded from 2005 to 2009 of ACT.

[ghollister]

OK. Please run the maintenance I suggested and post the results.