I am facing a problem in record lock. below is the complete description of the problem please help.
I have a flowservice which connects to informix db and picks some records from it and updates the process flag as the processing takes place.
so during this time it publishes(local publish no broker involved) the document and updates the process flag in informix db.
The published document is subscribed by the Target and inserts it in oracle db.and publishes a ACknowledgement document which contains invoice numbers in it.
This ACknowledgement document is subscribed by Source and deletes the records from informix db based on the invoice no present in the ACknowledgement document published by target.
Triggers are of : concurrent type
jdbc connector : tried both No_transaction & local-transaction
getting the following error for few of the transactions and not for all.
[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service
[ADA.1.316] Cannot execute the SQL statement “delete temp_esn where trim(invoice_number) = ?”. "
(IX000/-244) Could not do a physical-order read to fetch next row.
(IX000/-107) ISAM error: record is locked."
Could not do a physical-order read to fetch next row.
please suggest me how to stop this error.
thanks & regards