My Oracle Support Banner

E-AE: Application Engine Crashes If SQL Statements in its SQL Action are Larger than 32 KB (Doc ID 2857993.1)

Last updated on MARCH 29, 2022

Applies to:

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

Symptoms

A custom Application Engine (AE) program began crashing intermittently with errors such as the shown below. While investigating the cause, it was found that the size of some SQL statements in the AE's SQL actions had been increased, and were larger than 32 KB.

 

Error:

---------------------------------------------------

 

Samnple environment:

-----------------------------

PeopleTools (PT) 8.57.12

HCM 9.20 PUM 35

Database: DB2

 

Steps to replicate:

-----------------------------

1. Set up an AIX environment with a DB2 database.

2. Log into Application Designer, and create a custom AE program with SQL actions containing SQL statements larger than 32 KB.

3. Run the AE program through Process Scheduler (Navigation: PeopleTools > Process Scheduler > Schedule Process Requests (PT 8.59)).

4. Observe the crashing behavior.

 

Changes

 Some SQL statements grew in size, and were larger than 32 KB.

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.