My Oracle Support Banner

Data MoverSQL error While Executing UPD28888754_01_IMP_DMS (Doc ID 2516211.1)

Last updated on OCTOBER 25, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 While applying PUM 29 to HCM 9.2.027 Demo (PUM 27) and during the Execute DMS step, the Data Mover import fails for UPD28888754_01_IMP_DMS with the following error.

Importing FSFB_FLTRFLDS

Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 805 - [IBM][CLI Driver][DB2] SQL0803N 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 "PSRF1YX4" constrains
Failed SQL stmt: INSERT INTO PS_FSFB_FLTRFLDS (FILTER_ID, FIELDNAME, EFF_STATUS, LABEL_ID, REQUIRED_FLG, FSFB_RESTRICT_FLG, PROMPT_TABLE, DISPLAY_ORDER, XLAT_FLDNAME, KEY_F (200,0)
SQL Error. Error Position: 0 Return: 805 - [IBM][CLI Driver][DB2] SQL0803N 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 "PSRF1YX4" constrains

INSERT INTO PS_FSFB_FLTRFLDS (FILTER_ID, FIELDNAME, EFF_STATUS, LABEL_ID, REQUIRED_FLG, FSFB_RESTRICT_FLG, PROMPT_TABLE, DISPLAY_ORDER, XLAT_FLDNAME, KEY_FIELD, DESCR_FLD, FSFB_YES, FSFB_NO, FSFB_EXCLUDEIN_FLG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)

SQL Error. Error Position: 0 Return: 0 -

Error: SQL unable to commit transaction for FSFB_FLTRFLDS

Ended: Fri Mar 8 17:32:08 2019

Unsuccessful completion

In the UPD28888754_01_IMP.DMS script the earlier command "DELETE FROM PS_FSFB_FLTRFLDS WHERE FILTER_ID LIKE 'PY%FL'" successfully completed and verified by performing a select on the table PS_FSFB_FLTRFLDS.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.