Cannot Insert Duplicate Row In PS_HR_MO_COMPONENT With Unique Index When Trying To Run DataMover Import Script UPD17385181_01_IMP.dms (Doc ID 2248745.1)

Last updated on AUGUST 08, 2017

Applies to:

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

Symptoms


When running Data Mover 805 - ORA-00001: unique constraint (HRSYS.PS_HR_MO_COMPONENT) violated .Applying all the Patches and Fixes available in Image 18

step on CA is : Running DataMover Export UPD17385181_01_EXP_DMS


ERROR
-----------------------

Started: Mon Aug 08 09:06:14 2016
Data Mover Release: 8.55.08
Database: HRP002 (ENG)
SQL Successful - DELETE FROM PS_HR_MO_COMPONENT WHERE PNLGRPNAME='TL_PAYTIME_SUMM' AND MARKET='GBL'
Input file: C:\psft\pt\change_assistant\staging\softwareupdateUSC_HRP_IMAGE_18{HR92U018-HRP002}IP\Data\upd17385181_01.dat (ENG)
Commit done at end of record
Importing HR_MO_COMPONENT
SQL Error. Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_HR_MO_COMPONENT' with unique index 'PS_HR_MO_COMPONENT'. The duplicate key value is (TL_OT_HISTORY_LIST, GBL).
INSERT INTO PS_HR_MO_COMPONENT (PNLGRPNAME, MARKET, HR_MO_POPUP_TYPE, HR_MO_OWNER_ID, HR_MO_SUB_ID, HR_MO_RCD_SENT, HR_MO_MSE_OVR_ID, HR_MO_PERSON_REC, HR_MO_PERSON_FIELD, HR_MO_JOB_REC, HR_MO_JOB_FIELD, SYSTEM_DATA_FLG) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
SQL Error. Error Position: 0 Return: 0 -
Error: SQL unable to commit transaction for HR_MO_COMPONENT
Ended: Mon Aug 08 09:06:14 2016
Unsuccessful completion



The issue can be reproduced at will with the following steps:
1. step on CA is : Running DataMover Export UPD17385181_01_EXP_DMS

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