ETL9.2: Data Conversion Abend at Step DC30613712.MAIN.Step010 When Applying PUM40. (Doc ID 2823630.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

When applying PUM40 at step Run Data Conversion DC30613712,
the following error occurs.

ERROR
-----------------------
PeopleTools 8.58.06 - Application Engine
Copyright (c) 1988-2021 Oracle and/or its affiliates.
All Rights Reserved
Process 2550808 resumed after step DC30613712.MAIN.[start] (108,538)
 Message Set Number: 108
 Message Number: 538
 Message Reason: Process 2550808 resumed after step DC30613712.MAIN.[start] (108,538)
File: e:\pt858p06b_2008120500-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1738 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_VAL_RLST_TBL) violated
Failed SQL stmt: INSERT INTO PS_TL_VAL_RLST_TBL (LIST_ID ,LIST_TYPE ,EFFDT ,DESCR ,DESCRSHORT ,TRC_SUM_CATEGORY) SELECT LIST_ID ,LIST_TYPE ,'2002-01-01' EFFDT ,DESCR ,DESCRSHORT ,TRC_SUM_CATEGORY FROM PS_TL_VAL_LIST_TBL
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt858p06b_2008120500-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1738 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_VAL_RLST_TBL) violated

Failed SQL stmt: INSERT INTO PS_TL_VAL_RLST_TBL (LIST_ID ,LIST_TYPE ,EFFDT ,DESCR ,DESCRSHORT ,TRC_SUM_CATEGORY) SELECT LIST_ID ,LIST_TYPE ,'2002-01-01' EFFDT ,DESCR ,DESCRSHORT ,TRC_SUM_CATEGORY FROM PS_TL_VAL_LIST_TBL (200,0)
Process 2550808 ABENDED at Step DC30613712.MAIN.Step010 (SQL) -- RC = 805 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 2550808 ABENDED at Step DC30613712.MAIN.Step010 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


STEPS
-----------------------
1. Run data conversion DC30613712

Cause

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