Migration to UTF-8 DB fails due to problem with date format XOA_IDNR_END

Products

• CA Automic Workload Automation - Automation Engine
• Automic SaaS
• CA Automic One Automation

Issue/Introduction

PCK.AUTOMIC_UTF-8.MIG-STEP03.SUPPORT.NOILM.SRC ends with the following error:

ORA-01830: date format picture ends before converting entire input string

 

This is the complete information in the Reports of PCK.AUTOMIC_UTF-8.MIG-STEP03.SUPPORT.NOILM.SRC

Activation Report:

<...>
2024-09-24 10:42:02 - U00020408 START_DATE#: 1997-05-09
2024-09-24 10:42:02 - U00020408 END_DATE#: 2024-09-08
2024-09-24 10:42:02 - U00020408 AH_IDNR_START#: 36562870
2024-09-24 10:42:02 - U00020408 AH_IDNR_END#: 227055945
2024-09-24 10:42:03 - U00020408 MELD_IDNR_END#: 2024-09-23
2024-09-24 10:42:03 - U00020408 XAO_IDNR_END#: 2024-09-23 00:00:00.000

Agent log:

2024-09-24 12:42:03 - U02000005 Job 'PCK.AUTOMIC_UTF-8.MIG-STEP03.SUPPORT.NOILM.SRC' with RunID '227315035' started.
2024-09-24 12:42:03 - U02012001 Successfully established connection to '<DB_instance>:<DB_port>/<DB_name>' with user '<DB_user>'.
2024-09-24 12:42:03             Oracle
2024-09-24 12:42:03             Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
2024-09-24 12:42:03             Version 19.18.0.0.0
2024-09-24 12:42:03 - U02012014 JDBC Driver version: 19.10.0.0.0
2024-09-24 12:42:03             delete from uc_migration
2024-09-24 12:42:03 - U02012003 0 row(s) affected
2024-09-24 12:42:03             alter session set nls_date_format = 'YYYY-MM-DD'
2024-09-24 12:42:03 - U02012003 0 row(s) affected
2024-09-24 12:42:03             insert into uc_migration values (1, '1997-05-09', '2024-09-08', 36562870, 227055945, '2024-09-23', '2024-09-23 00:00:00.000', upper('<DB_name>'),'N')
2024-09-24 12:42:03             ORA-01830: date format picture ends before converting entire input string


2024-09-24 12:42:03 - U02004025 Job-script execution was aborted.
2024-09-24 12:42:03 - U02012006 SQL Rollback executed

Environment

UTF-8 Upgrade package v1.0.4

Cause

This is caused by a wrong format returned by PCK.AUTOMIC_UTF-8.MIG.SQLI.GET.GET_XAO_IDNR_END.SRC

Resolution

Workaround:

In PCK.AUTOMIC_UTF-8.MIG.SQLI.GET.GET_XAO_IDNR_END.SRC set the output format to 'Date' and 'yyyy-mm-dd' 

Solution:

This will be fixed in a future version of the UTF-8 Upgrade package.

Additional Information

The reference of the fix is DE154413