tOracleOutput - resource busy and acquire with NOWAIT specified error

One Star

tOracleOutput - resource busy and acquire with NOWAIT specified error

Could you please someone advice me to handle the below error?
Exception in component tOracleOutput_2
java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified
My job is very simple like the following sequence and only 20 records I have read and insert into output after truncate.
tOracleInput - tMap - tOracleOutput
But I often get the error message says that "java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified" against my "tOracleOutput" component.

Re: tOracleOutput - resource busy and acquire with NOWAIT specified error

you have an open session that is locking the table. If you dont have any uncommitted transactions outside of talend, you may be able to fix this by using the tOracleConnection and a tOracleCommit components to make the job run under a single session.
One Star

Re: tOracleOutput - resource busy and acquire with NOWAIT specified error

- tOracleOutput "table" mentioned in output is common table for other operations also, So how can I control this error in my talend job. Is there any wait option I can specify if the resource is busy.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog