E-UPD: ORA-00001: unique constraint (SYSADM.PS_PSPNLFIELDLANG) violated INTO PSPNLFIELDLANG (Doc ID 2226245.1)

Last updated on JANUARY 26, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

The bellow errors are received:

 

ERROR 1:
-----------
Error: ORA-00001: unique constraint (SYSADM.PS_PSPNLFIELDLANG) violated Failed SQL stmt: INSERT INTO PSPNLFIELDLANG (PNLNAME, PNLFLDID, LANGUAGE_CD, EDITSIZE, FIELDLEFT, FIELDTOP, FIELDRIGHT, FIELDBOTTOM, EDITLBLLEFT, EDITLBLTOP, EDITLBLRIGHT, EDITLBLBOTTOM, DSPLFORMAT, LBLTYPE, LBLLOC, LBLPADSIZE, LABEL_ID, LBLTEXT, FIELDSIZETYPE, LABELSIZETYPE, GRDLBLALIGN, PTLBLIMGCOLLAPSE, PTLBLIMGEXPAND, USEDEFAULTLABEL) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24)

 

ERROR 2:
-----------

805 - ORA-00001: unique constraint (SYSADM.PS_PSPNLFIELDLANG) violated Failed SQL stmt: INSERT INTO PSPNLFIELDLANG (PNLNAME, PNLFLDID, LANGUAGE_CD, EDITSIZE, FIELDLEFT, FIELDTOP, FIELDRIGHT, FIELDBOTTOM, EDITLBLLEFT, EDITLBLTOP, EDITLBLRIGHT, EDITLBLBOTTOM, DSPLFORMAT, LBLTYPE, LBLLOC, LBLPADSIZE, LABEL_ID, LBLTEXT, FIELDSIZETYPE, LABELSIZETYPE, GRDLBLALIGN, PTLBLIMGCOLLAPSE, PTLBLIMGEXPAND, USEDEFAULTLABEL) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24)

 

ERROR 3:
-----------
"805 - ORA-00001: unique constraint (SYSADM.PS_PSPNLFIELDLANG) violated INTO PSPNLFIELDLANG (PNLNAME, PNLFLDID, LANGUAGE_CDLDIZ (62,16)
Systeemfout: USEDEFAULTLABEL) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24) (62,16) "

 

ERROR 4:
-----------
805 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PSPNLFIELDLANG' with unique index 'PS_PSPNLFIELDLANG'. The duplicate key value is (PTIASPLANGWARN, 17, ENG).Failed SQL stmt: INSERT INTO PSPNLFIELDLANG (PNLNAME, PNLFLDID, LANGUAGE_CD, EDITSIZE, FIELDLEFT, FIELDTOP, FIELDRIGHT, FIELDBOTTOM, EDITLBLLEFT, EDITLBLTOP, EDITLBLRIGHT, EDITLBLBOTTOM, DSPLFORMAT, LBLTYPE, LBLLOC, LBLPADSIZE, LABEL_ID, LBLTEXT, FIELDSIZETYPE, LABELSIZETYPE, GRDLBLALIGN, PTLBLIMGCOLLAPSE, PTLBLIMGEXPAND, USEDEFAULTLABEL) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms