E-PRCS: Delete Run Controls Errors On EO_RDAE.PrcsComp.Step04 on DB2 Database
(Doc ID 3058138.1)
Last updated on NOVEMBER 11, 2024
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.60 and laterInformation in this document applies to any platform.
Symptoms
Delete Run Controls ID process, errors on EO_RDAE.PrcsComp.Step04 on DB2 specific platform.
ERROR
------------
File: /vob/peopletools/src/pspcm/pcmruncontrol.cppSQL error. Stmt #: 1156 Error Position: 0 Return: 8614 - [IBM][CLI Driver][DB2] SQL0206N "A.ROWID" is not valid in the context where it is used. SQLSTATE=42703
(SQLSTATE 42S22) -206
Failed SQL stmt: DELETE FROM PS_PRCSRUNCNTL WHERE ROWID IN ( SELECT rid FROM (SELECT a.rowid rid, COUNT(a.rowid) OVER ( PARTITION BY a.oprid, a.run_cntl_id) cnt FROM PS_PRCSRUNCNTL a, PS_PTPRCS_RCM c WHERE a.oprid=c.OPRID AND a.run_cntl_id=c.RUN_CNTL_ID AND c.PTRCMID = 'XXXX' AND c.PTSCHEDDEL='T') WHERE cnt = 1)
(SQLSTATE 42S22) -206
Failed SQL stmt: DELETE FROM PS_PRCSRUNCNTL WHERE ROWID IN ( SELECT rid FROM (SELECT a.rowid rid, COUNT(a.rowid) OVER ( PARTITION BY a.oprid, a.run_cntl_id) cnt FROM PS_PRCSRUNCNTL a, PS_PTPRCS_RCM c WHERE a.oprid=c.OPRID AND a.run_cntl_id=c.RUN_CNTL_ID AND c.PTRCMID = 'XXXX' AND c.PTSCHEDDEL='T') WHERE cnt = 1)
The issue can be reproduced at will with the following steps:
1. Log into PIA.
2. Schedule to run delete Run Controls ID process.
3. Delete Run Controls errors on EO_RDAE.PrcsComp.Step04.
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 |