DMS Script HR918036_01.dms Fails when applied to DEMO Database in HR 9.1 BUNDLE 18. (Doc ID 2021540.1)

Last updated on JUNE 19, 2015

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

DMS script HR918036_01.dms fails when being applied to DEMO database in HR BUNDLE 18.

When applying HR 9.1 BUNDLE 18 the DMS script HR918036_01.dms fails on date conversion.

PeopleTools 8.51.09 - Data Mover
Copyright (c) 2015 PeopleSoft, Inc.
All Rights Reserved

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: E:\pt851-903-R1-retail\peopletools\src\psdmtx\dmtcmd.cppSQL error. Stmt #: 346 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or time from character string. (SQLSTATE 22008) 241
Failed SQL stmt:INSERT INTO PS_HRS_APP_DIS_AUD (HRS_PERSON_ID, AUDIT_OPRID, AUDIT_STAMP, DISABILITY_STS_USA, HR_EE_SIGNATURE, HR_DISCLOSURE_DT,HRS_DIS_SEEN_FLG) SELECT HRS_PERSON_ID, 'DC20217693', CONVERT(CHAR(10),GETDATE(),10 (200,0)
Logging status in C:\logs\datamove.log

Error: SQL execute error for INSERT INTO PS_HRS_APP_DIS_AUD (HRS_PERSON_ID, AUDIT_OPRID, AUDIT_STAMP, DISABILITY_STS_USA, HR_EE_SIGNATURE, HR_DISCLOSURE_DT,HRS_DIS_SEEN_FLG) SELECT HRS_PERSON_ID, 'DC20217693', CONVERT(CHAR(10),GETDATE(),102)+'-'+CONVERT(CHAR(8),GETDATE(),108)+ '.000000', DISABILITY_STS_USA, HR_EE_SIGNATURE, HR_DISCLOSURE_DT, HRS_DIS_SEEN_FLG FROM PS_HRS_APP_DIS WHERE DISABILITY_STS_USA <> ' ' OR HR_EE_SIGNATURE <> ' ' OR HR_DISCLOSURE_DT IS NOT NULL OR HRS_DIS_SEEN_FLG = 'Y'


[Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or time from character string. (SQLSTATE 22008) 241

Ended: Mon May 11 11:23:21 2015

Unsuccessful completion

ERROR

INSERT INTO PS_HRS_APP_DIS_AUD (HRS_PERSON_ID, AUDIT_OPRID, AUDIT_STAMP, DISABILITY_STS_USA, HR_EE_SIGNATURE, HR_DISCLOSURE_DT,HRS_DIS_SEEN_FLG) SELECT HRS_PERSON_ID, 'DC20217693', CONVERT(CHAR(10),GETDATE(),102)+'-'+CONVERT(CHAR(8),GETDATE(),108)+ '.000000', DISABILITY_STS_USA, HR_EE_SIGNATURE, HR_DISCLOSURE_DT, HRS_DIS_SEEN_FLG FROM PS_HRS_APP_DIS WHERE DISABILITY_STS_USA <> ' ' OR HR_EE_SIGNATURE <> ' ' OR HR_DISCLOSURE_DT IS NOT NULL OR HRS_DIS_SEEN_FLG = 'Y'

[Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or time from character string. (SQLSTATE 22008) 241



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the "hr918036_01.dms"



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