Duplicate insert on PSIBLOGERR
Hi Integration experts,
We are sometimes getting duplicate insert errors on PSIBLOGERR table (PeopleTools 8.49.30) when a sync message is published. The process message log shows Integration Gateway General error while app server log shows unique constraint error. Anyone has any idea on why this could happen?
/vob/peopletools/src/psintbrkr/syncerror.hSQL error. Stmt #: 247 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSIBLOGERR) violated
Failed SQL stmt:INSERT INTO PSIBLOGERR (GUID, ERRORTIMESTAMP, SEQNO, PUBNODE, MESSAGE_SET_NBR, MESSAGE_NBR, IBDATAERRLOC) VALUES (:1,TO_DATE(SUBSTR(:2, 0, 19),'YYYY-MM-DD-HH24.MI.SS'),:3,:4,:5,:6,:7)