- 3,715,830 Users
- 2,242,890 Discussions
- 7,845,632 Comments
OSB12c DB adapter- while updating the database table experiencing file in use error
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: