My Oracle Support Banner

E-CA: Re-Synching Maintenance Log Step Fails with "[Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" (Doc ID 1593790.1)

Last updated on APRIL 26, 2018

Applies to:

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

Symptoms

Peopletools 8.53.06

Applying a Change Package via PeopleSoft Update Manager  (PUM) with Change Assistant, and  received the error:

 "E:\pt85306d-retail\peopletools\src\psjca\psjsp.cppSQL error. Stmt #: 904 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. (SQLSTATE 0100
Failed SQL stmt: INSERT INTO PS_PTIASPLOGTGT (DBNAME, PTIASPRPTNO, PTIASPPKGAPPLYDT) VALUES (:1, :2, :3)"

This was at the Re-Sync Target Maintenance Log step.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.