Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT 2009 Duplicates Opportunities when you execute a resync

New Member
Posts: 11
Country: United States

ACT 2009 Duplicates Opportunities when you execute a resync

When we resync, the Opportunity line items get duplicated.  If we sync 5 times we get 5 entries.  Any idea why?
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: ACT 2009 Duplicates Opportunities when you execute a resync

Is this happening with all remote users?

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 11
Country: United States

Re: ACT 2009 Duplicates Opportunities when you execute a resync

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

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: ACT 2009 Duplicates Opportunities when you execute a resync

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).

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 11
Country: United States

Re: ACT 2009 Duplicates Opportunities when you execute a resync

 

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

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: ACT 2009 Duplicates Opportunities when you execute a resync

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

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.