E-QR/AE: Batch or Online App Engine Processes Failed with Incomplete SQL or "AppEngine error" (Doc ID 1385164.1)

Last updated on FEBRUARY 03, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.51 [Release 8.4]
Information in this document applies to any platform.
***Checked for relevance on 21-MAR-2014***

Symptoms

Case 1:

After tools upgrade from 8.48 to 8.51, Intermittently some App Engine processes start to abend with variant kind of error, as it tries to run incomplete SQL against the database. Restarting the process scheduler with cache clear fixes this issue. However, it keeps coming back after a few days/runs.

Error:

Varying errors like:

Field xxx is not defined on state record yy_AET,
ORA-00927: missing equal sign,
ORA-00904: "U"."PRINT_SEQ_NB": invalid identifier,

...etc.

Case 2: 

After applying PeopleTools patch 8.50.16 with POC from 8.50.09, a delivered CRM 8.9 Online Application Engine program run failed intermittently with error.

Error:

PSAPPSRV.3048 (3607) [05/04/11 07:39:38 CAWASHINGTON@candice-was-lap.jhacorp.com (IE 8.0; WINNT) ICPanel](0) CallAppEngine: Application RF_GET_ENTL: AppEngine error. (2,653) FUNCLIB_RF.ENTITLEMENT_SEARCH.FieldFormula Name:RUN_ENTITLEMENT_SEARCH PCPC:4119 Statement:40
Called from:DERIVED_RC_CASE.RC_ENTITLEMENT_PB.FieldChange Name:find_entitlements Statement:38
Called from:DERIVED_RC_CASE.RC_ENTITLEMENT_PB.FieldChange Name:case_entl Statement:114
Called from:DERIVED_RC_CASE.RC_ENTITLEMENT_PB.FieldChange Name:rc_entitlement_pb_FieldChange Statement:151
Called from:DERIVED_RC_CASE.RC_ENTITLEMENT_PB.FieldChange Statement:200

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