Community
Showing results for 
Search instead for 
Do you mean 
Reply

Permanent fix for 'Cannot insert duplicate key row in object'

Copper Contributor
Posts: 93
Country: Switzerland

Permanent fix for 'Cannot insert duplicate key row in object'

In our company we are frequently (on a monthly basis) having this issue: http://kb.sagesoftwareonline.com/app/answers/detail/a_id/28141/~/error%3A-%22cannot-insert-duplicate...

 

Is there a permanent solution to this issue?

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Permanent fix for 'Cannot insert duplicate key row in object'

[ Edited ]

Hello albergante,
This error is caused by an issue in Microsoft SQL Server 2008 R2, which Microsoft fixed with SP1. To fix the issue, you would need to apply the service pack from the MS download site. Here is the link:
http://www.microsoft.com/en-us/download/details.aspx?id=26727

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: 7
Country: United_Kingdom

Re: Permanent fix for 'Cannot insert duplicate key row in object'

We've suffered this same problem for a long, long time. We have SQL Server 2008 R2 SP1 installed but it still occurs on a regular basis. So don't hold your breath on that solving the issue. The problem causes VSS Writers to go into failed states which in-turn prevents our 3 backup solutions on our server to fail because they all rely on the VSS Writers. The only way to clear the VSS Writer failed states is to reboot the server. A proper fix is really needed for this.