My Oracle Support Banner

CA Run Data Conversion AE DCEO22098552 Failing with Error 'ORA-00001: unique constraint (SYSADM.PS_EOWC_SC_CONFIG) violated' When Applying PUM#32 (Doc ID 2662565.1)

Last updated on APRIL 30, 2020

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 applying PUM#32, Change Assistant Data Conversion step Run Data Conversion AE - DCEO22098552 failed with the following error.

ERROR
--------
  PeopleTools 8.57.09 - Application Engine
Copyright (c) 1988-2020 Oracle and/or its affiliates.
All Rights Reserved
Process 2058379 resumed after step DCEO22098552.MAIN.[start] (108,538)
 Message Set Number: 108
 Message Number: 538
 Message Reason: Process 2058379 resumed after step DCEO22098552.MAIN.[start] (108,538)
File: e:\pt857p09b_1908140501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_EOWC_SC_CONFIG) violated
Failed SQL stmt: INSERT INTO PS_EOWC_SC_CONFIG (PAGELET_CONFIG_ID , EOWC_SCNTR_GRPLETS , DISPLAY_ORDER , SHOW_LINK) SELECT A.PAGELET_CONFIG_ID , '1' , 3 , 'Y' FROM PS_FSPC_ADM_TBL A WHERE NOT EXISTS ( SELECT 'x' FROM PS_EOWC_SC_CONFIG B WHERE A.PAGELET_CONFIG_ID = B.PAGELET_CONFIG_ID AND B.EOWC_SCNTR_GRPLETS = '1' AND B.DISPLAY_ORDER = 3)

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt857p09b_1908140501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_EOWC_SC_CONFIG) violated
Failed SQL stmt: INSERT INTO PS_EOWC_SC_CONFIG (PAGELET_CONFIG_ID , EOWC_SCNTR_GRPLETS , DISPLAY_ORDER , SHOW_LINK) SELECT A.PAGELET_CONFIG_ID , '1' , 3 , 'Y' FROM PS_FSPC_ADM_TBL A WHERE NOT EXISTS ( SELECT 'x' FROM PS_EOWC_SC_CONFIG B WHERE A.PAGELET_CONFIG_ID = B.PAGELET_CONFIG_ID AND B.EOWC_SCNTR_GR (200,0)
Process 2058379 ABENDED at Step DCEO22098552.MAIN.INSERT (SQL) -- RC = 805 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 2058379 ABENDED at Step DCEO22098552.MAIN.INSERT (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s




The issue can be reproduced at will with the following steps:
1. Apply PUM#32.
2. Change Assistant Data Conversion step Run Data Conversion AE - DCEO22098552 failed.

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
References


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