sselman
Well Known Member
I am seeing a primary key violation in my jde.log for R3483, even when I purge F3413 and run the MRP for a single item. Is this normal for this program? It is almost like the code is not checking for the existance of the time series bucket before it tries to perform an insert.
The MRP appears to be correct even with these errors. If I turn off the time series generation, the errors are not in the log files. the only thing I have seen on support is related to lower level codes and I have verified those are set correctly and have even reset them and still see the error.
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854001 jdbodbc.C6869
ODB0000164 - STMT:00 [23000][2627][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'F3413_PK'. Cannot insert duplicate key in object 'CRPDTA.F3413'. The duplicate key value is (11558, 11, 05, 113301).
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854002 jdbodbc.C6869
ODB0000164 - STMT:01 [01000][3621][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854003 jdbodbc.C6869
ODB0000164 - STMT:02 [23000][2627][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'F3413_PK'. Cannot insert duplicate key in object 'CRPDTA.F3413'. The duplicate key value is (11558, 11, 98, 113301).
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854004 jdbodbc.C6869
ODB0000164 - STMT:03 [01000][3621][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854005 ODBC_P2.C1613
ODB0000123 - Execute buffered insert, record 1 of 100 failed. ODBC:
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854006 ODBC_P2.C1613
ODB0000123 - Execute buffered insert, record 2 of 100 failed. ODBC:
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854007 ODBC_P2.C1613
ODB0000123 - Execute buffered insert, record 3 of 100 failed. ODBC:
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854008 ODBC_P2.C1613
ODB0000123 - Execute buffered insert, record 4 of 100 failed. ODBC:
The MRP appears to be correct even with these errors. If I turn off the time series generation, the errors are not in the log files. the only thing I have seen on support is related to lower level codes and I have verified those are set correctly and have even reset them and still see the error.
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854001 jdbodbc.C6869
ODB0000164 - STMT:00 [23000][2627][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'F3413_PK'. Cannot insert duplicate key in object 'CRPDTA.F3413'. The duplicate key value is (11558, 11, 05, 113301).
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854002 jdbodbc.C6869
ODB0000164 - STMT:01 [01000][3621][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854003 jdbodbc.C6869
ODB0000164 - STMT:02 [23000][2627][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'F3413_PK'. Cannot insert duplicate key in object 'CRPDTA.F3413'. The duplicate key value is (11558, 11, 98, 113301).
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854004 jdbodbc.C6869
ODB0000164 - STMT:03 [01000][3621][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854005 ODBC_P2.C1613
ODB0000123 - Execute buffered insert, record 1 of 100 failed. ODBC:
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854006 ODBC_P2.C1613
ODB0000123 - Execute buffered insert, record 2 of 100 failed. ODBC:
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854007 ODBC_P2.C1613
ODB0000123 - Execute buffered insert, record 3 of 100 failed. ODBC:
3396/2696 WRK:Starting jdeCallObject Sun Oct 27 11:08:38.854008 ODBC_P2.C1613
ODB0000123 - Execute buffered insert, record 4 of 100 failed. ODBC:
