Forum Stats

  • 3,783,678 Users
  • 2,254,819 Discussions
  • 7,880,515 Comments

Discussions

OSB12c DB adapter- while updating the database table experiencing file in use error

User_UYCV0
User_UYCV0 Member Posts: 1 Green Ribbon
edited Jan 20, 2021 1:34PM in Integration - Adapters

I am currently working on a OSB service which polls a table for new records based on the value of a particular column. I am using 'Logical Delete' option to poll for new records. the DB table column will have the value 'Unprocessed' for new rows and will be updated to 'inprogress' by OSB DB adapter after that proxy response pipeline will update table with 'processed'. it is not working for some times we are seeing file in use error while updating it back to table 


for example - consider the below service outline.


Source Db2-- OSB service -- Oracle DB And DB2 .


DB2 Adapter Polling a table -> OSB Service -> Business service (Oracle DB call) and Db2 update Business service call(to update the status flag as processed).


Message Invoke JCA outbound service failed with application error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/OSBPIXINF90PKMSToOracle/Resources/PKMSUpdateStatusFlag.wsdl [ PKMSUpdateStatusFlag_ptt::update(S5Oput00Collection) ] - WSIF JCA Execute of operation 'update' failed due to: DBWriteInteractionSpec Execute Failed Exception.

Supplemental Detail update failed. Descriptor name: [PKMSUpdateStatusFlag.S5Oput00].

Caused by java.sql.SQLException: [SQL0913] Row or object S5OPUT00 in RMTCONQF90 type *FILE in use..

; nested exception is:

BINDING.JCA-11616