Worksheets Get Struck Intermittently: Cannot obtain XAConnection - Error query.run: ODPM-70016 (Doc ID 1587991.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.4 and later
Information in this document applies to any platform.

Goal

Using weblogic and worksheets get struck intermittently. the collaborator log has:
ERROR query.run: ODPM-70016: Error loading query from Application Server:java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool DemantraDS to allocate to applications, please increase the size of the pool and retry.


Java console

JAVA CONSOLE DETAIL
Java Plug-in 10.13.2.20
Using JRE version 1.7.0_13-b20 Java HotSpot(TM) Client VM
User home directory = C:\Users\user1
----------------------------------------------------
c: clear console window
f: finalize objects on finalization queue
g: garbage collect
h: display this help message
l: dump classloader list
m: print memory usage
o: trigger logging
q: hide console
r: reload policy configuration
s: dump system and deployment properties
t: dump thread list
v: dump thread stack
x: clear classloader cache
0-5: set trace level to
----------------------------------------------------
log4j:WARN No appenders could be found for logger (dpweb.connection).
log4j:WARN Please initialize the log4j system properly.
2013-08-16 15:36:35,177 PDT [thread applet-com.demantra.partner.client.main.PartnerApplet.class-1] INFO dpweb.general :: ODPM-50010: Worksheets Window Logging Started...
2013-08-16 15:36:35,177 PDT [thread applet-com.demantra.partner.client.main.PartnerApplet.class-1] INFO dpweb.general :: ODPM-50009: Worksheets Window is started in Online mode.
2013-08-16 15:36:35,177 PDT [thread applet-com.demantra.partner.client.main.PartnerApplet.class-1] INFO dpweb.general :: ODPM-50005: Worksheets Window Applet code base :
http://<host_address>:7003/demantraweb/portal/
2013-08-16 15:36:35,239 PDT [thread applet-com.demantra.partner.client.main.PartnerApplet.class-1] INFO tunnel.general :: ODPM-50016: No proxy selected
2013-08-16 15:36:35,442 PDT [thread applet-com.demantra.partner.client.main.PartnerApplet.class-1] INFO dpweb.general :: ODPM-40690: Worksheets Window Started on Time Zone America/Los_Angeles DST on, Locale
English (United States)
2013-08-16 15:36:35,442 PDT [thread applet-com.demantra.partner.client.main.PartnerApplet.class-1] INFO dpweb.general :: ODPM-50011: Worksheets Window is using Server Time Zone US/Pacific
log4j:WARN No appenders could be found for logger (dpweb.connection).
log4j:WARN Please initialize the log4j system properly.
2013-08-16 15:36:38,219 PDT [Keep_Session_Alive_Thread] INFO dpweb.connection :: ODPM-50002: Connectivity status is: 'Connected'
2013-08-16 15:36:39,888 PDT [Get_Meta_Data_Thread] INFO dpweb.query.data :: ODPM-50008: Note: Query RK - 001 DP Item - SHK-SUPPS-DE loaded, contains 882 combinations
2013-08-16 15:36:47,251 PDT [Get_Meta_Data_Thread] INFO dpweb.query.data :: ODPM-50008: Note: Query RK - 001 DP Item - SHK-SUPPS-DE - AGGREGATE loaded, contains 78
combinations
2013-08-16 15:38:56,000 PDT [Get_Meta_Data_Thread] INFO dpweb.query.data :: ODPM-50008: Note: Query 108 DP New vs DP Prior loaded, contains 4711 combinations
2013-08-16 15:39:06,546 PDT [OpenCrosstabSwingWorker5] ERROR dpweb.combinationsCache :: com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool DemantraDS to allocate to applications, please increase the size of the pool and retry..
  at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:577)
  at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:342)
  at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:329)
  at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:417)
  at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:324)
  at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:94)
  at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:63)
  at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1677)
  at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1475)
  at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
  at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
  at com.demantra.applicationServer.connection.DBConnectionFactory.createConnection(DBConnectionFactory.java:169)
  at com.demantra.applicationServer.connection.DBConnectionFactory.createConnection(DBConnectionFactory.java:147)
  at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
  at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
  at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
  at com.demantra.applicationServer.pools.JDBCConnectionPool.getConnection(JDBCConnectionPool.java:260)
  at com.demantra.applicationServer.services.queryrun.StatementHandler.(StatementHandler.java:58)
  at com.demantra.applicationServer.services.queryrun.LoaderTask.(LoaderTask.java:63)
  at com.demantra.applicationServer.services.queryrun.LoaderTaskFactory.createQueueTask(LoaderTaskFactory.java:45)
  at com.demantra.common.queue.QueueTaskFactory.makeObject(QueueTaskFactory.java:29)
  at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
  at com.demantra.common.queue.BasicQueueManager.getNextTask(BasicQueueManager.java:356)
  at com.demantra.applicationServer.services.queryrun.QueryDataLoader.execute(QueryDataLoader.java:92)
  at com.demantra.applicationServer.services.queryrun.QueryDataLoader.loadData(QueryDataLoader.java:74)
  at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setQueryData(QueryDataHandler.java:287)
  at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setWorksheetData(QueryDataHandler.java:269)
  at com.demantra.applicationServer.services.queryrun.BaseQueryDataHandler.loadQueryData(BaseQueryDataHandler.java:140)
  at com.demantra.applicationServer.services.queryrun.QueryDataHandler.loadQueryData(QueryDataHandler.java:148)
  at com.demantra.applicationServer.services.queryrun.BaseDataRunner.loadQueryData(BaseDataRunner.java:85)
  at com.demantra.applicationServer.services.queryrun.BaseDataRunner.setData(BaseDataRunner.java:70)
  at com.demantra.applicationServer.services.queryrun.ExtendedDataRunner.run(ExtendedDataRunner.java:107)
  at java.lang.Thread.run(Thread.java:662)

Solution

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