Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BPEL process times out after 5 minutes

user1165407Sep 6 2011 — edited Feb 26 2020
Hi,

I have created a BPEL Asynchronous process that is invoking a view which takes time to give all the records; while the process is invoking this database adapter, my process abruptly ends with the following fault after 5 minutes

Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'CAMPAIGN_BATCH_COUPONS_VSelect' failed due to: DBReadInteractionSpec Execute Failed Exception. Query name: [CAMPAIGN_BATCH_COUPONS_VSelect], Descriptor name: [CAMPAIGN_BATCH_COUPONS_V.WcCampaignBatchCouponsV]. Caused by java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation . See root exception for the specific exception. This exception is considered retriable, likely due to a communication failure. Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml). ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

It looks like my process is timed out. Is there anything that I can do for it to not time out like this?


Can anybody please help me on this?

Thanks in advance.

Edited by: user1165407 on Sep 6, 2011 4:19 PM
This post has been answered by NarsingPumandla on Sep 6 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2012
Added on Sep 6 2011
2 comments
780 views