My Oracle Support Banner

E-SQR: PT 8.53 SQR Language Reference For PeopleSoft Processing Limits - (SQR 4038) Out of space (Doc ID 1639710.1)

Last updated on JULY 21, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.45 to 8.45 [Release 8.4]
Information in this document applies to any platform.
The SQR processing limit information can be displayed using the -olim flag. See below for details:

PeopleSoft PeopleTools 8.54 > SQR Language Reference for PeopleSoft > SQR Command Line

SQR Command Flags

Flag Description
-olim Displays the SQR resources that are used by the SQR report.
- Limit is the programmatic limit, the maximum amount of memory that can be allocated to the variable.
- Defined is the value defined in the pspssqr.ini file; this is a user-defined value.
- Actual is the actual amount of memory/space used by the variable at runtime.


(SQR 4038) Out of space while processing expression; Use -Mfile to increase EXPRESSIONSPACE.


The PeopleSoft PeopleTools 8.53 SQR Language Reference for PeopleSoft Processing-Limits Section is out of date and incorrect.

This enhancement is effective per development starting on PT 8.53.00.

The current processing limits are given in the table below. Basically the maximum is now 2^31 . The limits though are high can be used only depending
on the load the system can take . e.g. Increase in variable count will add to process memory.

Limit Name                       Limit from 8.53  Onwards
---------------                  --------------------------------
DYNAMICARGS                       2147483648
EXPRESSIONSPACE                   2147483648
FORWARDREFS                       2147483648
ONBREAKS                          2147483648
POSITIONS                         2147483648
PROGLINEPARS                      2147483648
PROGLINES                         2147483648
QUERIES                           2147483648
QUERYARGS                         2147483648
SQLSIZE                           2147483648
STRINGSPACE                       2147483648
SUBVARS                           2147483648
VARIABLES                         2147483648
WHENS                             2147483648


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

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