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 NOVEMBER 10, 2014

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

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