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.


The issue is that certain SQRs that do not handle NULL date fields correctly.
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.

Application & Version: PT 8.54.19
Bundle/Patch: N/A
Environment: Demo
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


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