Resource-busy error

Note:
This connector only encounters this error when it is running on an Oracle database.

The connector sometimes encounters an error when retrieving or changing data in an application. This error occurs when the connector tries to update a record that is currently locked. The connector must lock the record before it can update it. The record may be locked by another process, or because the connector is multi-threaded, it may be locked by the connector itself.

An error message like the following displays:

[Time: 2001/05/29 16:30:07.356] [System: ConnectorAgent] [SS: SOVTConnector] 
 [Type: Trace] [Mesg: Select CLIENT,COUNTRY,STRT_CODE,CITY_CODE,
 CITYP_CODE,STRTYPEAB,COMMU_CODE,REGIOGROUP,TAXJURCODE from ADRSTREET
 where CLIENT='100' and COUNTRY='DE' and STRT_CODE='000001114136' 
 FOR UPDATE NOWAIT]
 [Time: 2001/05/29 16:30:07.526] [System: ConnectorAgent] [SS: SOVTConnector]
 [Type: Trace ] [Mesg: :logMsg]
 [Time: 2001/05/29 16:30:07.536] [System: ConnectorAgent] [SS: SOVTConnector] 
 [Type: Error ] [MsgID: 37002]
 [Mesg: Execution of Retrieve statement failed : java.
 sql.SQLException: ORA-00054: Versuch, mit NOWAIT eine bereits 
 belegte Ressourceanzufordern.]
 

To resolve this problem, you can stop the process that is preventing the connector from obtaining a lock on the record, or you can adjust the RetryCountInterval configuration property for the connector.

Copyright IBM Corp. 1997, 2004