Skip to main content

Error: 'cannot insert duplicate key row in object dbo.MRPSTOCKDET'

I cannot run the stock forecast (MRP) due to the following error message: An error was found when processing an SQL statement (see below).

J
Written by Jes Foxall-Beckley
Updated over 3 weeks ago

receiving error "An error was found when processing an SQL statement".
​
SQL_SERVER_NAME: cannot insert duplicate key row in object dbo.MRPSTOCKDET with unique index 'By_Stock_Type'. The duplicate key value is (1,BI,partnumber, , ,0,0,0,0).
​
The following command could not be processed.
​
EXEC pr_MRPWriteStockWorkFile 1

Please raise a new case online and reference the title of this article.

Did this answer your question?