topic Re: ORA error message not dispayed when executing job in Talend Studio

ORA error message not dispayed when executing job

Anonymous — Fri, 29 Mar 2019 09:02:04 GMT

Hi,

Since i have migrated to TOS for DI 6.5.1 (linux), ora error messages when inserting to database are not always displayed. I execute my job, it run to the end and no error are dispayed (the trouble exist in talend when the job is not exported or in the linux command line windows when it was exported) but in the end, all records are not inserted in the database. If i change in the tOracleOutput the number of records to insert/update before to commit and change it from 10000 to 1, the rejected records change to only 1 but no ora message.

Is there a parameter that disable database error messages or cach then to let the job continue ?

Thank for your answers

Best regard

Re: ORA error message not dispayed when executing job

fdenis — Fri, 29 Mar 2019 12:15:53 GMT

check error level of the job.
check the linux ora driver does it return error message?

Re: ORA error message not dispayed when executing job

Anonymous — Wed, 03 Apr 2019 08:38:52 GMT

Hi,

I have changed Stats & Logs parameters. Now "Use logs (tLogCatcher)" is checked and logs are stored into database table. After running all my jobs, few records were inserted into the logs table. Logs correspond to exceptions into talend components but no logs for ora messages. In one of my jobs, there was a problem because the tOracleOutput was trying to insert in a table where one column was missing. The ora message appeared in the console (even if console was not checked in stat & logs parameters) after each 10000 inserts (at the commit point) but no log into the database. "Use project parameters" is checked in the job. Is there others parameters to modify ?

Thank

Stats_Logs.JPG

Re: ORA error message not dispayed when executing job

fdenis — Wed, 03 Apr 2019 09:21:37 GMT

whar about your ora driver are you worink on the same os with the same driver and conf for dev and prod?