My Oracle Support Banner

E-AE/E-QRY: "Max Fetch Size" Value Not Working In PSAESRV section Via Process Scheduler For Scheduled Queries (Doc ID 2598727.1)

Last updated on DECEMBER 21, 2020

Applies to:

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

Symptoms

On : PeopleTools 8.56 version, Query

Description
---------------
Setting PSAESRV "MAX FETCH SIZE" parameter doesn't seem to be working for trying to limit Query result sets when running via the Process Scheduler using Schedule Query. Even though reconfigured to restrict the result size Query is allowed to generate larger result sets.
 
Symptom
---------------
PSAESRV "MAX FETCH SIZE" parameter exceeded when limited
 
 
 
Replication
---------------
The issue can be reproduced with the following steps:
1. Add value to set limit for PSAESRV "MAX FETCH SIZE" parameter
2. Schedule a Query known be be larger than the limit configured
3. Observe set limit exceeded
 

Changes

 

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.