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.
Symptoms
ERROR
---------------
(SQR 4038) Out of space while processing expression; Use -Mfile to increase EXPRESSIONSPACE.
Changes
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
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 |