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.