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

Last updated on MAY 08, 2023

Applies to:

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

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