My Oracle Support Banner

Comprehensive Error Report Generated In DMW UI Has Extra Error Messages (Doc ID 2724099.1)

Last updated on NOVEMBER 09, 2020

Applies to:

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

Symptoms

On Oracle Health Sciences Data Management Workbench 2.5.2 version, Data Load

The Comprehensive Error Report generated during the Data Load through UI reported invalid data errors even though the data value is valid based on the Date
Format defined in the  Data Load Parameters for Text Load.

Example:
-----------------------
DM3,<FILE_NAME>,1,SSTARTDATESTARTDATESTARTDATE30,2000-01-01T12:00:00,"ORA-28106:input value for argument # is not valid"
DM3,<FILE_NAME>,1,BBRTHDTBRTHDTBRTHDTBRTHDTBRT30,1990-01-01T12:00:00,"ORA-28106:input value for argument # is not valid"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a new study.

2. Create a Text Data Model using a mdd file.
   Table created = DM5

3. Setup the Watcher Configuration
   Data Load Parameters for Text
           DataFormat:      Fixed         Delimited  - Select Delimited
           *DelimiterChar:  ,
           EnclosingChar: "
          *SkipRecords: 1
          *Reported Errors:
          RowsBeforeCommit:
          DateFormat: YYYY-MM-DD"T"HH24:MI:SS

4.  Install the Data Model

5. Copy the .csv file to the defined FileWatcher Directory.

Note: Make sure the data file (.csv) contains an invalid value for AGE & BRTHDT column but the rest are valid values.

6. Check the data load status.
   FileWatcher process the data file and the Data Load job fails.

7. Click on the View Comprehensive Error Report.
   The report will include errors like:

   TABLE_NAME FILE_NAME RECORD_NUMBER COLUMN_NAME VALUE ERROR_MESSAGE
DM5 <FILEWATCHER_PATH>/TEXTDEV/TestStudyTemp/DM5.csv 1 ORIGINAL_ERROR Captured in the TextLoad.log ORA-20100: ORA-06502: PL/SQL: numeric or
value error: character to number conversion error
DM5 <FILEWATCHER_PATH>/TEXTDEV/TestStudyTemp/DM5.csv 1 AGE ABC ORA-06502: PL/SQL: numeric or value error
DM5 <FILEWATCHER_PATH>/TEXTDEV/TestStudyTemp/DM5.csv 1 BRTHDT ABC ORA-01841: (full) year must be between -4713 and +9999, and not be 0
DM5 <FILEWATCHER_PATH>/TEXTDEV/TestStudyTemp/DM5.csv 1 SSTARTDATESTARTDATESTARTDATE30 2000-01-01T12:00:00 ORA-28106: input value for argument # is not valid
DM5 <FILEWATCHER_PATH>/TEXTDEV/TestStudyTemp/DM5.csv 1 BBRTHDTBRTHDTBRTHDTBRTHDTBRT30 1990-01-01T12:00:00 ORA-28106: input value for argument # is not valid

   From looking at the Comprehensive Error Report, the following column/data
   shouldn't be  reported as an error based on the Date Format defined in the  
   Data Load Parameters for Text:

DM5 <FILEWATCHER_PATH>/TEXTDEV/TestStudyTemp/DM5.csv 1 SSTARTDATESTARTDATESTARTDATE30 2000-01-01T12:00:00 ORA-28106: input value for argument# is not valid
DM5 <FILEWATCHER_PATH>/TEXTDEV/TestStudyTemp/DM5.csv 1 BBRTHDTBRTHDTBRTHDTBRTHDTBRT30 1990-01-01T12:00:00 ORA-28106: input value for argument# is not valid

NOTE: If trying to upload the file with the correct values for the columns AGE & BRTHDT, the data load is completed successfully.

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.