|The tOracleBulkExec component fails to insert data into the table.|
|Product||Talend Data Integration|
|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|