Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ORA error message not dispayed when executing job

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

Labels (2)
3 Replies
fdenis
Master
Master

check error level of the job.
check the linux ora driver does it return error message?
Anonymous
Not applicable
Author

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
fdenis
Master
Master

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