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
UTF-8 Upgrade package v1.0.4
This is caused by a wrong format returned by PCK.AUTOMIC_UTF-8.MIG.SQLI.GET.GET_XAO_IDNR_END.SRC
In PCK.AUTOMIC_UTF-8.MIG.SQLI.GET.GET_XAO_IDNR_END.SRC set the output format to 'Date' and 'yyyy-mm-dd'
This will be fixed in a future version of the UTF-8 Upgrade package.
The reference of the fix is DE154413