E-SQR: SQR Selecting/Inserting NULL Date Fails "Fractional second precision..." or "SQR 1308" Errors on SQL Server 2012/2014 (Doc ID 2074420.1)

Last updated on DECEMBER 16, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

On : PeopleTools 8.54 version, SQR (for MSS platform specifically)

SQR programs which select NULL DATE values from one table and attempt to directly insert the NULL into another table and DATE field fails with an error. This same SQR SQL code worked in prior releases of PeopleTools.
 
ERRORS
---------------
SQR 5528) ODBC SQL dbexec: SQLExecute error 0 in cursor 9:
[Microsoft][SQL Server Native Client 11.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.

 

-OR-

 

-------------------------------------------------
(SQR 1308) BNDCUR: Could not bind column 1.

SQR for PeopleSoft: Program Aborting.
-------------------------------------------------


 
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. Submit SQR program which runs affected code on Microsoft SQL Server 2012/2014.
2. Observe error in respective ".out" file.

 

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