[resolved] ORA-00911: invalid character if importing data from csv file

[Anonymous]

Dear Team,
I am using Talend ETL tool (Version 5.)
I have created an ETL Job importing data from csv flat file to Oracle DB 10g. I do not make any data conversion so I insert string format to the target table where the column types are also string. I made an update / insert operation.
I can sucessfully update and insert all rows but I get an error message:
ORA-00911: invalid character
Consol display information:
Starting job Staging_Cust_CN1 at 11:22 26/08/2014.
connecting to socket on port 3494
connected
ORA-00911: invalid character
disconnected
Job Staging_Cust_CN1 ended at 11:22 26/08/2014.  
The software does not give me any hints where should I look for the problem. There is no complier error in the code.
I have created my own test file with out special characters but still getting the error.
Where can I find additional information about the error.
Any advice is appreciated.
Thank you!
Best Regards,
Robert

[Anonymous]

Hi,
Is your workflow tfileinputdelimited-->tOracleOutPut?
How did you set your component tOracleOutPut DB? You made an update / insert operation? Did you set Key column for your update operation?
In addition, have you already checked the option "Die on Error" in the DB component properties to see if there is any error info printed on console.
Best regards
Sabrina

[Anonymous]

                                                                                                  Hi Sabrina,
Thank you for your prompt answer.
I have a combined key from two rows. This is my tOracleOutPut. Screeen shot. I hope you have a better resolution.
 
An I added the update/insert operation.
If I check the target Table, the data is insert and updated accordingly. The job is running accordingly. But I have that funny error message.
Best Regards,
Robert
                                                

[Anonymous]

Could you please check if the there is mismatch between the schema used in the tOracleOutput component and the actual table. If you e.g. attempt to write an char into a numeric field this will also cause such errors.

[Anonymous]

Hi,
It seems your screenshot is missing. Have you checked "Die on error" option? No error info is printed on console? All your data in .csv file is successfully inserted and updated into your oracle without special character which is unsupported by your oracle?
Best regards
Sabrina

[Anonymous · Accepted solution]

Hi Sabrina, Jlolling,
Thank you for your prompt answers!
Issue is resolved.
I did not add the target table definition at the component  tOracleRow, furthermore in the component tOracleRow the check box "die on error" was not checked in.
Best Regards!
Robert

[Anonymous]

Hi rblazsek,
It's glad to see the issue is resolved. Thanks for sharing your solution with us.
Best regards
Sabrina