topic Re: tOracleOutput - resource busy and acquire with NOWAIT specified error in Talend Studio

tOracleOutput - resource busy and acquire with NOWAIT specified error

Anonymous — Sat, 16 Nov 2024 13:21:49 GMT

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

Anonymous — Wed, 07 Jul 2010 18:23:38 GMT

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.

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

Anonymous — Thu, 08 Jul 2010 12:04:51 GMT

- 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.