E-AE: Application Engine Restart Failed with ORA-06550/PLS-00103 Error on SQL Statement RECSTATS
Last updated on JANUARY 24, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.48 to 8.49 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.51 to 8.51 [Release 8.4]
Information in this document applies to any platform.
***Checked for relevance on 19-Jan-2012***
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms