You are not logged in.

#1 2010-07-07 16:07:08

Mani
Member
23 posts

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.


Thanks and Regards,
Mani.

Offline

#2 2010-07-07 18:23:38

JohnGarrettMartin
Member
812 posts

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.

Offline

#3 2010-07-08 12:04:51

Mani
Member
23 posts

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.


Thanks and Regards,
Mani.

Offline

Board footer