Dynamics Community Forum Thread Details

Violation of PRIMARY KEY constraint 'pjcomdet0'

I am having difficulty resolving this issue in SL 2011. My client has a PO that they are receipting but as soon as I release the batch i receive the below error from the event log. I have queried the PJCOMDET table and I can see the two entries that are duplicated but i do not know how to go about resolving this error.

You help is greatly appreciated.

Event Log Message:

Processing: Batch Number: 048099    , Receipt Number: 032696
System Message 5: [Microsoft][SQL Server Native Client 11.0][SQL
                  Server]Violation of PRIMARY KEY constraint 'pjcomdet0'. Cannot
                  insert duplicate key in object 'dbo.PJCOMDET'. The duplicate
                  key value is (201807, PO, 05

Debugging info:
                  POAutoProjectCommitments '051123', '201807', '04400',
                  'AENSLIN'
Cursor(csrProjectCommitment)
                  POAutoProjectCommitments '051123', '201807', '0440
Optional
                  info: SqlState = 23000 NativeError = 2627 ErrorMsg =
                  [Microsoft][SQL Server Native Client 11.0][SQL
                  Server]Violation of PRIMARY KEY constraint 'pjcomdet0'. Cannot
                  insert duplicate key in object 'dbo.PJCOMDET'. The duplicate
                  key value is (201807, PO, 051123    ,
                  POAutoProjectCommitments
ODBCRowNumber = 1 Column = -1
                  SSrvrLine = 648 SSrvrMsgState = 1 SSrvrSeverity = 14 SSrvrPr

System Message 6127: Error occurred during an abortable transaction. Processing
                     will continue.