My Oracle Support Banner

Network Outage Stops BPEL Database Adapter Connected to MSSQL (Doc ID 1372121.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle(R) BPEL Process Manager 10g - Version to [Release AS10gR3]
Information in this document applies to any platform.


After a network outage, a BPEL Database Adapter stops polling target table hosted in a MS SQL server. The situation is not reverted until the instance was restarted. The following type of error can be observed in log files:

<2010-10-28 12:25:36,150> <INFO> <default.collaxa.cube.activation> <Database Adapter::Inbound> <oracle.tip.adapter.db.exceptions.DBResourceException createEISException> A retriable exception occured. In BPEL you can configure a fault policy (starting with to automatically perform retries. Please configure bpel/domains/<domainName>config/fault-bindings.xml

<2010-10-28 12:25:36,151> <WARN> <default.collaxa.cube.activation> <Database Adapter::Inbound>
DBActivationSpec Polling Exception.Query name: [My_query], Descriptor name: [My_Query]. Polling the database for events failed on this iteration. [Caused by: Connection reset]

If the cause is something like a database being down successful polling will resume once conditions change. Caused by Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 ( (Build 080602)): oracle.toplink.exceptions.DatabaseException
Internal Exception: Connection resetError Code: 0


Network suffers a short outage, then interrupting the data flow between the middle tier and the MS SQL database.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.