My Oracle Support Banner

E-SQR: SQR 5402 Error Using Newer SQR Commands to Generate XML Output (Doc ID 2566117.1)

Last updated on MARCH 16, 2021

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, SQR

Description
---------------
SQR program written to generate XML output using the newer XML commands in SQR fails with the "(SQR 5402)" error for any sizeable output. The relevant SQR commands are documented in PeopleBooks. See the below related PeopleBooks link for further details on the relevant commands.

SQR Commands to Generate XML Output (https://docs.oracle.com/cd/E92519_02/pt856pbr3/eng/pt/tsqr/ref_SQRCommandsToGenerateXMLOutput.html?pli=ul_d109e359_tsqr)

 
ERROR
---------------
Error on line 337:

  (SQR 5402) String cannot be placed on page: <string content here>

-- placement specified is out of range. (1,1,0)


SQR for PeopleSoft: Program Aborting.
 
 
Replication
---------------
The issue can be reproduced with the following steps:
1. Submit SQR program that uses newer SQR Commands to Generate XML Output
2. Monitor via Process Monitor and observe error in generated ".out" file
 

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.