Error - "Error Position: 0 Return: 8601 - [CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target" When Running The AE For Post Data Conversion -PODC35093693
(Doc ID 2978556.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When running change assistant step - "Run Post Data Conversion AE - PODC35093693" while applying updates from HCM 9.2 PUM 47 on DB2 database, the following error occurs.
2023-09-20 14:15:38.564 - [Step - Run Post Data Conversion AE - PODC35093693] Failed
2023-09-20 14:15:38.571 - #embed step execution error/warn log: E:\PUMS\47\UPDATEDIRS\Output\softwareupdateHCM47GETCURRENT{HR92U047-HR92DEV}IP20230919141358\PODC35093693_PODCPODC35093693_out.log
PeopleTools 8.59.09 - Application Engine
Copyright (c) 1988-2023 Oracle and/or its affiliates.
All Rights Reserved
File: E:\PT859P09C_2203301559-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 8601 - [CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target. Target name is "HCSC_NOT_SENT_DTTM". SQLSTATE=42821
(SQLSTATE 22005) -408
Failed SQL stmt: UPDATE PS_HCSC_ANNOUNCE SET HCSC_NOT_SENT_DTTM = (SELECT HCSC_LAST_RUN_DATE FROM PS_HCSC_NOTIF WHERE PS_HCSC_ANNOUNCE.HCSC_NOTIF_TRNS_ID = PS_HCSC_NOTIF.HCSC_NOTIF_TRNS_ID)
Message Set Number: 200
Message Number: 0
Message Reason: File: E:\PT859P09C_2203301559-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 8601 - [][CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target. Target name is "HCSC_NOT_SENT_DTTM". SQLSTATE=42821
2023-09-20 14:15:38.571 - #embed step execution error/warn log: E:\PUMS\47\UPDATEDIRS\Output\softwareupdateHCM47GETCURRENT{HR92U047-HR92DEV}IP20230919141358\PODC35093693_PODCPODC35093693_out.log
PeopleTools 8.59.09 - Application Engine
Copyright (c) 1988-2023 Oracle and/or its affiliates.
All Rights Reserved
File: E:\PT859P09C_2203301559-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 8601 - [CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target. Target name is "HCSC_NOT_SENT_DTTM". SQLSTATE=42821
(SQLSTATE 22005) -408
Failed SQL stmt: UPDATE PS_HCSC_ANNOUNCE SET HCSC_NOT_SENT_DTTM = (SELECT HCSC_LAST_RUN_DATE FROM PS_HCSC_NOTIF WHERE PS_HCSC_ANNOUNCE.HCSC_NOTIF_TRNS_ID = PS_HCSC_NOTIF.HCSC_NOTIF_TRNS_ID)
Message Set Number: 200
Message Number: 0
Message Reason: File: E:\PT859P09C_2203301559-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 8601 - [][CLI Driver][DB2] SQL0408N A value is not compatible with the data type of its assignment target. Target name is "HCSC_NOT_SENT_DTTM". SQLSTATE=42821
Steps to reproduce the issue:
-------------------------------------
1. Run task in change assistant Post Data Conversion AE - PODC35093693.
Changes
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |