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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads