E-SQR - Invalid String Or Buffer Length Error on SQR's On PT 8.54.19 (Doc ID 2109184.1)

Last updated on FEBRUARY 22, 2016

Applies to:

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

Symptoms

ISSUE STATEMENT
---------------
The issue is that certain SQRs that do not handle NULL date fields correctly.
 
ERROR
---------------
SQL Status = 0, SQL Error = [Microsoft][SQL Server Native Client 11.0]Invalid string or buffer length

Error on line 71:
  (SQR 3301) Program stopped by user request.

 
ENVIRONMENT
---------------
Application & Version: PT 8.54.19
Bundle/Patch: N/A
Environment: Demo
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. PeopleTools > Process Scheduler > System Process Requests
2. Enter run control ID
3. Select BILDGL01.SQR Type = Web and Format = PDF
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms