Network Outage Stops BPEL Database Adapter Connected to MSSQL
Last updated on NOVEMBER 03, 2016
Applies to:Oracle(R) BPEL Process Manager - Version 10.1.3.4 to 10.1.3.4 [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,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 (10.1.3.4.0) (Build 080602)): oracle.toplink.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Connection resetError Code: 0
Network suffers a short outage, then interrupting the data flow between the middle tier and the MS SQL database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms