Data Load Hits ORA-01843: "not a valid month" Or ORA-01810: "Format Code Appears Twice", And ORA-20100, ORA-6512, ORA-4088
Last updated on OCTOBER 30, 2017
Applies to:Oracle Health Sciences Data Management Workbench - Version 2.4.6 and later
Information in this document applies to any platform.
DMW File Watcher Text Data Load fails with the following errors:
EOL_ NEXT * WHT O(") CHARACTER (BOUNDFILLER FIELD)
value used for ROWS parameter changed from 64 to 4
Record 1: Rejected - Error on table CDR_W123_456789.TXT_TV9876543210.
ORA-20100: ORA-01810: format code appears twice$2
ORA-06512: at "CDR_W123_456789.TXT_TV9876543210$INS", line 711
ORA-04088: error during execution of trigger 'CDR_W123_456789.TXT_TV9876543210$INS'
The issue can be reproduced at will with the following steps:
Create a new Study, create a Data Model with input type=file and with some DATE columns in the Text Data Load. Other Data Loads without Date columns work OK.
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