Data Load Hits ORA-01843: "not a valid month" Or ORA-01810: "Format Code Appears Twice", And ORA-20100, ORA-6512, ORA-4088 (Doc ID 2265360.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.6 and later
Information in this document applies to any platform.

Symptoms

DMW File Watcher Text Data Load fails with the following errors:

SQL string for column : "CDR_W###.CDR_ATK_TEXT_SERVICES.CDR_CHECK_EOL(:"MY_DATE",:EOL_)"
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.

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