SOA DB Adapter does not always honor the configured timeout (Doc ID 2113765.1)

Last updated on MARCH 07, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.7.0 version, Fabric


In a cluster environment with 2 nodes, you have set your timeouts to allow a DB Adapter to execute a store procedure that could take up to 3 hours.
Find that sometimes the DB Adapter times out the transaction after only 2 hours, generating the following error:

In the Audit Trail:

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms