Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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