Sqr 4705 Program Line Too Long Maximum Is 511
Last updated on FEBRUARY 01, 2019
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.53 and laterInformation in this document applies to any platform.
The SQR processing limit information can be displayed using the -olim flag. See below for details:
Because some children will go into remission, MMI therapy for 1–2 years is still considered first-line treatment for most children. However, the majority of pediatric patients with GD will eventually require either radioactive iodine or surgery. When ATDs are used in children, only MMI should be used, except in exceptional circumstances. One of the SQRS is giving an error Error on line 1: (SQR 4705) Program line too long; maximum is 511. This is happening for every line in the SQR.
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. Win pc sign pro 2010 with rhinestone torrent.
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! |
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |