E-IB: Renaming Default Local Node Error:"One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by (Doc ID 663636.1)

Last updated on JULY 25, 2016

Applies to:

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

This document was previously published as Customer Connection Solution 201074005


***Checked for relevance on 12-JAN-2012***


Symptoms

Customer recently upgraded to PT 8.48+ and when renaming the default local node it fails with the error: "One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by

" constrains table" Failed SQL stmt: INSERT INTO PSRTNGDFNPARM (ROUTINGDEFNNAME, EFFDT, PARAMETERNAME, SENDERNODENAME, RECEIVERNODENAME, XFRMNAME, XFRMNANE_SECOND, INMSGNAME, INMSGVERSION, .....ETC.

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