My Oracle Support Banner

SOA DB Polling Services Stopped Polling After Network Interruption (Doc ID 2565610.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Service Bus - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 12.2.1.0.0 version, OSB Core Functionality

SOA DB Polling services stopped polling after network interruption

We have a number of SOA and OSB Composites initiated by DB Polling Adapter. During a scheduled network maintenance event Weblogic datasources lost connections to various databases. This loss of connections lasted 12 minutes, after which datasources successfully resestablished connectivity. For most of our polling services, polling resumed once connectivity was re-established. 2 of our OSB polling services did not resume polling, however. Both services reported error:
<[service_name: PAYMENT_AP_PUB/ProxyServices/PAYMENT_AP_PUB_DB] Fast classification of SQLState: null errorCode: 0 message: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'XXAP_base_domain': XAER_RMERR : A resource manager error has occurred in the transaction branch
javax.transaction.xa.XAException: Unexpected error during start for XAResource 'XXAP': Transaction timed out after 300 seconds

<[service_name: CUST_HUB_XCM_PUB/ProxyServices/pollXCMCustHub] Fast classification of SQLState: null errorCode: 0 message: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'XCM_base_domain': XAER_RMERR : A resource manager error has occurred in the transaction branch
javax.transaction.xa.XAException: Unexpected error during start for XAResource 'XCM': Transaction timed out after 300 seconds


Manual intervention (restart of the OSB managed server) was required to restart the polling
 

Solution

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
Goal
Solution
References


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