Error message after importing BOM with revision history in BOM Revision History window

(0) Share

Report

Posted on by ssorkin

When I click "Rev. Level" it gives me numerous errors, including these:

GP Error: 54

SQL Error: 2627 [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK##1515403'. Cannot insert duplicate key in object 'dbo.##1515403'.

The 1515403 number changes every time, so I'm confused what dbo.##<random number> is referring to? Is this a temp table?

This was directly after importing a MFG BOM to ENG BOM, and then ENG BOM to MFG BOM (with changes, keeping revision history). Any ideas? I know the general idea of what this means but can't understand why this occurred to begin with and how to fix it (those look like temporary tables).

Edit:

The BM010416 table has 4 entries for the MFG BOM and ENG BOM (2 each) -- the 4 entries represent each revision level of the BOM. Seems normal, but should all 4 records be in the BOM history table?

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Error message after importing BOM with revision history in BOM Revision History window

Hello. I know it's been a while but did you ever get a solution for this? I'm having this same issue. Any point in the right direction would be much appreciated. Thank you!