Resource-busy error

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

The connector sometimes encounters an error like the following when retrieving or changing data in an application.

[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.536] {System: ConnectorAgent] [SS: SOVTConnector]
[Type: Error] [MsgID: 37002]
[Mesg: Execution ofRetrieve statement failed : java.
sql.SQLException: ORA-00054: Versuch, mit NOWAIT eine bereits belegate Ressourceanzuforderm.]

This error occurs when the connector tries to update a record that is currently locked. The record may be locked by another process, or because the connector is multi-threaded, it may be locked by th connector itself.

Note that records must be locked during the update process. The connector attempts to retrieve an after-image of the object received by the integration broker and, in the process, locks the entire object in the database to preserve data integrity.

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. 2004, 2005