oracletalend
How to catch DB Error in Sub Job in Talend
I have the below design in Talend I am catching the error when the component fails but if there is any error from DB like Cannot Insert as Parent Key not found Cannot Insert into column col2 expected 15 but actual 16 it is not showing any error if the insert job is ran a subjob
If I run the Job FACTDIM_COMBINE I can see the error but if it is ran as Subjob I am not able see the error
Please help to get the DB error when it is run as SubJob also
Solution
Please use tLogCatcher component in your job. This will log all the errors even in the sub jobs. Also enable die on error functionality in all the components where ever necessary
- Fetch last row for each month, or previous month if not found
- Convert table with columns as path (bread crumbs / levels) to hierarchy (tree) representation
- Why my query to select from Oracle database turn to text (blank query) every time i run it
- Oracle ORA-00902 Invalid datatype error
- Check if Advanced Compression is available
- Strange full table scan statements in Oracle
- Options to enforce a logical constraint in an Oracle database
- How to sort numbers before letters with linguistic sorting?
- How to sort all numbers before letters with linguistic sorting?
- Oracle Trigger Creation Error: PLS-00049 BAD BIND VARIABLE 'OLD'
- plsql script is raising 'ERROR at line 1 DECLARE', I don't see the reason
- Update table column based on join in Oracle
- Oracle Apex - Download CSV produces an empty report
- SSIS - the value cannot be converted because of a potential loss of data
- Filtering duplicate values, searching for pairs
- Trying to filter a sql report by a range of numbers
- Adding html target attribute to APEX tree link
- How to compile and run an Oracle OCI/OCCI program with C++ in Alpine
- Date function not returning expected Month
- Extract specific value from CLOB (containing XML) while creating one delimited string per row of a table. CLOB value may be null on some rows
- Is java.sql.Timestamp timezone specific?
- SQL pivot and sum total
- Inserting current date and time to Oracle database using Java
- Queue monitoring oracle script
- Date Time Format, Perl Oracle SQL
- Performance tuning of Update statement in ORACLE
- Ansible playbook takes forever to execute an Oracle DB query
- Search All Fields In All Tables For A Specific Value (Oracle)
- Get 12 month running total for subgroups in Oracle
- Returning clause in json_table or skip error on error?