Using a tOracleBulkExec component, the Job fails to insert data into the table 

Talend Version 6.3.1

Summary

The tOracleBulkExec component fails to insert data into the table.
Additional Versions  
Product Talend Data Integration
Component Studio
Problem Description Date column-related error messages such as the following were reported, and the bad rows were moved to a .bad file.
ORA-01843: not a valid month
Problem root cause

The tOracleBulkExec component Advanced settings did not match the .csv file read by the component. Thus the control file did not generate correctly.

Solution or Workaround

Click Advanced settings, then ensure that the tOracleBulkExec configuration fields, such as Record Terminator and Field Terminated by, match the file read by the component.

JIRA ticket number  
Version history
Revision #:
5 of 5
Last update:
‎09-29-2018 12:13 AM
Updated by: