Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you update to Microsoft Dynamics GP 2010: "[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PKUPRXXXXX'. Cannot insert duplicate key in object 'dbo.UPRXXXXXX'"

Error message when you update to Microsoft Dynamics GP 2010: "[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PKUPRXXXXX'. Cannot insert duplicate key in object 'dbo.UPRXXXXXX'"

Symptoms

When you update to Microsoft Dynamics GP 2010, the table conversion for the company database fails. A red X appears next to the company indicating a failure. To determine what tables failed, run the following script:


SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID
FROM DYNAMICS.dbo.DU000030 a
JOIN
DYNAMICS.dbo.DU000010 b
ON a.fileNumber = b.fileNumber
AND a.PRODID = b.PRODID
JOIN
DYNAMICS.dbo.SY01500 c
ON a.companyID = c.CMPANYID
WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15

     
You receive the following error message in the errordesc column:  

[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PKUPRXXXXX'. Cannot insert duplicate key in object 'dbo.UPRXXXXXX'.


You receive this error message when one or more of the following tables fail to update:
UPR10203
UPR10204
UPR10205
UPR10206
UPR10207
UPR10209
UPR10213
UPR10214

Cause

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

The primary key changed with Microsoft Dynamics GP 2010 and the records in the table are violating the new key. Records should not exist in the payroll work tables following a payroll check run. To fix this problem, remove the records.

To have us fix this problem for you, go to the "Fix it for me" section. If you would rather fix this problem yourself, go to the "Let me fix it myself" section.

↑ Back to the top

Fix it for me

To fix this problem automatically, click the Fix this problem link. Then click Run in the File Download dialog box, and follow the steps in this wizard.





Note This wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

Note If you are not on the computer that has the problem, you can save the automatic fix to a flash drive or to a CD, and then you can run it on the computer that has the problem.

↑ Back to the top

Let me fix it myself


To fix this problem yourself, follow these steps:

  1. Do not restore the company database. This problem can be resolved at the point of failure during the update to Microsoft Dynamics GP 2010.
  2. Start the SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.   

    Method 1: For SQL Server 2005

    If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

    Method 2: For SQL Server 2008

    If you are using SQL Server 2008, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
  3. Run the following scripts against the company database that is failing:

    Delete UPR10203
    Delete UPR10204
    Delete UPR10205
    Delete UPR10206
    Delete UPR10207
    Delete UPR10209
    Delete UPR10213
    Delete UPR10214
  4. Run the following script to clear the failed records:

    Delete DYNAMICS..DU000030 where Status = 135 and fileNumber in (424, 425, 426, 427, 428, 429, 385, 386)
  5. Start Microsoft Dynamics GP 2010 Utilities and update the company again.

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kbfixme, kbmsifixme, kb

↑ Back to the top

Article Info
Article ID : 2564486
Revision : 1
Created on : 1/7/2017
Published on : 1/18/2012
Exists online : False
Views : 90