E-ORA/AE: Application Engine Restart Failed with ORA-06550/PLS-00103 Error on SQL Statement RECSTATS
(Doc ID 979151.1)
Last updated on MARCH 17, 2023
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.48 to 8.51 [Release 8.4]Information in this document applies to any platform.
Symptoms
Since our upgrade to Tools 8.49.19 from 8.46.19, The Application Engine (AE) start abending with ORA-6550. Further review indicated it occurs when the AE tries to run stats.
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1603 Error Position: 14 Return: 6550 - ORA-06550: line 1, column 15: PLS-00103: Encountered the symbol "TABLE" when expecting one of the following: := . ( @ % ;
Failed SQL stmt:RECSTATS PS_RE_OPTS_TAO4 LOW
Process 768988 ABENDED at Step AR_REV_EST.GETOPTS.STATS (SQL) -- RC = 6550 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
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 |