PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Duplicate insert on PSIBLOGERR

edited Jun 18, 2016 5:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center