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

    Forum Stats

  • 3,715,830 Users
  • 2,242,890 Discussions
  • 7,845,632 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

User_UYCV0
User_UYCV0 Member Posts: 1
edited January 20 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

Sign In or Register to comment.