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.