Data Conversion AE PODC32831683 Abended at Step EOPR_STAGE.BACKUP.BKUPSRC on DB2 When Upgrading to Image 42
(Doc ID 2969382.1)
Last updated on AUGUST 22, 2023
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Upgrading from Image 38 to Image 42 on a DB2 database.
At Change Assistant Step - Run Post Data Conversion AE - PODC32831683, the Job.log shows the process abended at Step EOPR_STAGE.Backup.BkUpSrc with an error.
ERROR
Stmt #: 1811 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0338N An ON clause associated with a JOIN operator or in a MERGE statement is not valid. SQLSTATE=42972 (SQLSTATE 42972) -338
Failed SQL stmt: INSERT INTO PS_EOPR_PRSMCR_BK (PORTAL_NAME, PORTAL_REFTYPE, PORTAL_OBJNAME, PORTAL_LABEL, DESCR254, EOPR_SYS_LOADED, PORTAL_ATTR_NMDSPL, EOPR_KEYWORD) SELECT C.PORTAL_NAME, C.PORTAL_REFTYPE, C.POR (200,0)
Process 21815 ABENDED at Step EOPR_STAGE.Backup.BkUpSrc (SQL) -- RC = 8601 (108,524)
STEPS
1. On a DB2 database, upgrade from Image 38 to 42
2. Change Assistant Step - Run Post Data Conversion AE - PODC32831683 will abend at Step EOPR_STAGE.Backup.BkUpSrc with the above error
Changes
Issue occurred while upgrading to Image 42.
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 |
Changes |
Cause |
Solution |
References |