After Database upgrade from 11.1.x version to 11.2.0.4 WLI Datasources throw the Exception "weblogic.common.resourcepool.ResourceDeadException: Pool cgDataSource is disabled" (Doc ID 1986854.1)

Last updated on JUNE 10, 2016

Applies to:

Oracle WebLogic Integration - Version 10.3.1 and later
Information in this document applies to any platform.

Symptoms

On : 10.3.1 version, Miscellaneous

After DB upgrade to 11.2.0.4, the WLI process is getting stuck and aborted due to:

ERROR
-----------------------

#### <> <> <> javax.ejb.EJBException: [WLI-Core:484047]Tracking MDB failed to acquire resources.
java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDeadException: Pool cgDataSource is disabled, cannot allocate resources to applications.
  at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1340)
  at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:425)
  at weblogic.jdbc.jta.DataSource.connect(DataSource.java:382)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
  at com.bea.wli.management.tracking.InstanceInfoMDB.getResources(InstanceInfoMDB.java:77)
  at com.bea.wli.management.tracking.InstanceInfoMDB.onMessage(InstanceInfoMDB.java:119)
  at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
  at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
  at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
  at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4547)
  at weblogic.jms.client.JMSSession.execute(JMSSession.java:4233)
  at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3709)
  at weblogic.jms.client.JMSSession.access$000(JMSSession.java:114)
  at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5058)
  at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
; nested exception is: java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDeadException: Pool cgDataSource is disabled, cannot allocate resources to applications..
javax.ejb.EJBException: [WLI-Core:484047]Tracking MDB failed to acquire resources.
java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDeadException: Pool cgDataSource is disabled, cannot allocate resources to applications.
  at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1340)
  at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:425)
  at weblogic.jdbc.jta.DataSource.connect(DataSource.java:382)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
  at com.bea.wli.management.tracking.InstanceInfoMDB.getResources(InstanceInfoMDB.java:77)
  at com.bea.wli.management.tracking.InstanceInfoMDB.onMessage(InstanceInfoMDB.java:119)
  at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
  at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
  at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
  at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4547)
  at weblogic.jms.client.JMSSession.execute(JMSSession.java:4233)
  at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3709)
  at weblogic.jms.client.JMSSession.access$000(JMSSession.java:114)
  at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5058)
  at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
; nested exception is: java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDeadException: Pool cgDataSource is disabled, cannot allocate resources to applications.
  at com.bea.wli.management.tracking.InstanceInfoMDB.getResources(InstanceInfoMDB.java:81)
  at com.bea.wli.management.tracking.InstanceInfoMDB.onMessage(InstanceInfoMDB.java:119)
  at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
  at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
  at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
  at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4547)
  at weblogic.jms.client.JMSSession.execute(JMSSession.java:4233)
  at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3709)
  at weblogic.jms.client.JMSSession.access$000(JMSSession.java:114)
  at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5058)
  at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
>




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms