Number of Threads Waiting for a Database Connection Increases, Calls to SOA Services Show Timeout Errors and no more BPEL Instances are Created
Last updated on NOVEMBER 01, 2016
Applies to:Oracle(R) BPEL Process Manager - Version 10.1.3.4 to 10.1.3.5.0
Information in this document applies to any platform.
JDBC version 10.1.0.5, 10.2.0.3, 10.2.0.4
Checked for relevance on 08-03-2012
***Checked for relevance on 09-August-2013***
When using SOA Suite Services like Applications Adapters and Database Adapters, after some running time all services stop and the application that make calls to these SOA services start to show timeout error.When checking the BPEL console, you can observed that no instance is generated.
Using AS Control you can observe that in the metrics of connection pool "Threads waiting connections" values are increasing and no more new connection is possible.
Checking the data-sources.xml file we can see that the connection pools define for several of these connections have the following attributes defined:
Restarting the SOA Suite solves the issue.
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