E-AE: Enabling Explain Plan For Application Engine Via -TRACE Option Results In Database Errors: ORA-12899: value too large for column "SYS"."PLAN_TABLE$"."STATEMENT_ID" (actual: 32, maximum: 30) (Doc ID 2277577.1)

Last updated on JUNE 16, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.

Symptoms

Problem statement:
-------------------------------

When enabling via explain plan feature via for Application Engine via -TRACE option results in database errors like the below:

File: /vob/peopletools/src/psappeng/psaetrac.cppSQL error. Stmt #: 2054 Error Position: 0 Return: 604 - ORA-00604: error occurred at recursive SQL level 1 ORA-12899: value too large for column "SYS"."PLAN_TABLE$"."STATEMENT_ID" (actual: 32, maximum: 30)
Optimizer trace FAILED: EXPLAIN PLAN SET STATEMENT_ID = 'FMC_DEU_PYRL.2_IT0000.AddAlter.' FOR UPDATE PS_FMC_DEU_PAY0000 p SET alter_emplid = NVL(( SELECT e.alter_emplid FROM PS_PERS_DATA_EFFDT e WHERE e.emplid = p.emplid AND e.EFFDT=(SELECT MAX(EFFDT) FROM PS_PERS_DATA_EFFDT ef WHERE ef.EMPLID=e.EMPLID AND ef.EFFDT<=TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'))), 'XXX')



Environment:
--------------------

Linux nesv362 3.0.101-0.7.44-default #1 SMP Wed Oct 19 14:28:11 UTC 2016 (ad8e171) x86_64 x86_64 x86_64 GNU/Linux
(SLES 11)
PeopleTools 8.52.26



Steps:
---------
Run an AE Program with 4096 TRACE parameter

Error:
--------

ORA-00604: error occurred at recursive SQL level 1 ORA-12899: value too large for column "SYS"."PLAN_TABLE$"."STATEMENT_ID" (actual: 32, maximum: 30)




Business Impact:
--------------------------
The customer cannot use the Database optimizer information as per their business requirements

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms