Database Adapter and Bpel Process Manager run out of Database Connections
Oracle(R) BPEL Process Manager - Version: 10.1.2.0.2
Symptoms
The problem manifests itself by the database adapter and BPEL running out of database connections. New connections cannot be established.
The following error might occur as a side effect:
Database Adapter::Inbound oracle.tip.adapter.db.InboundWork runOnce Exception during
polling of the database ORABPEL-11624 DBActivationSpec Polling Exception.
Query name: [ClarifyPollingProdService], Descriptor name:
[ServiceRequestAutomation.TableCase].
Polling the database for events failed on this iteration.
If the cause is something like a database being down successful polling will resume once conditions change.
Caused by Exception [TOPLINK-4002]
(OracleAS TopLink - 10g (9.0.4.5) (Build 040930)):
oracle.toplink.exceptions.DatabaseException
Exception Description:
java.sql.SQLException: Io exception: Connection timed out
Internal Exception: java.sql.SQLException: Io exception: Connection timed out
Error Code: 17002.
Cause
Both OC4J running BPEL and the database adapter reached the maximum number of connections and were unable to establish new ones.
The reason for the problem is a database adapter Bug 5595347.
According to Bug 5595347, the database adapter might leave open connections behind.
The fix for Bug 5595347 is included in Patch 5638122.
Solution
To implement the solution, please execute the following steps:
Apply Patch 5638122.
References
Bug 5595347 - ORIONCMTCONNECTION NOT CLOSED IN ORABPEL~OC4J_BPEL~DEFAULT_ISLAND~1
Note 314422.1 - Remote Diagnostic Agent (RDA) 4 - Getting Started
Patch 5638122 - MERGE LABEL REQUEST ON TOP OF 10.1.2.0.2 FOR BUGS 5149866 5595347 5205630
Symptoms
The problem manifests itself by the database adapter and BPEL running out of database connections. New connections cannot be established.
The following error might occur as a side effect:
Database Adapter::Inbound oracle.tip.adapter.db.InboundWork runOnce Exception during
polling of the database ORABPEL-11624 DBActivationSpec Polling Exception.
Query name: [ClarifyPollingProdService], Descriptor name:
[ServiceRequestAutomation.TableCase].
Polling the database for events failed on this iteration.
If the cause is something like a database being down successful polling will resume once conditions change.
Caused by Exception [TOPLINK-4002]
(OracleAS TopLink - 10g (9.0.4.5) (Build 040930)):
oracle.toplink.exceptions.DatabaseException
Exception Description:
java.sql.SQLException: Io exception: Connection timed out
Internal Exception: java.sql.SQLException: Io exception: Connection timed out
Error Code: 17002.
Cause
Both OC4J running BPEL and the database adapter reached the maximum number of connections and were unable to establish new ones.
The reason for the problem is a database adapter Bug 5595347.
According to Bug 5595347, the database adapter might leave open connections behind.
The fix for Bug 5595347 is included in Patch 5638122.
Solution
To implement the solution, please execute the following steps:
Apply Patch 5638122.
References
Bug 5595347 - ORIONCMTCONNECTION NOT CLOSED IN ORABPEL~OC4J_BPEL~DEFAULT_ISLAND~1
Note 314422.1 - Remote Diagnostic Agent (RDA) 4 - Getting Started
Patch 5638122 - MERGE LABEL REQUEST ON TOP OF 10.1.2.0.2 FOR BUGS 5149866 5595347 5205630
Comments