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 |