java.sql.SQLException

Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool oimOperationsDB to allocate to applications, please increase the size of the pool and retry..

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web21

Stack trace

  • java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool oimOperationsDB to allocate to applications, please increase the size of the pool and retry.. at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:591) at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:344) at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:363) at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1751) at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:462) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491) at sun.reflect.GeneratedMethodAccessor698.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy138.getConnection(Unknown Source) at oracle.iam.platform.utils.vo.OIMDataSource.getConnection(OIMDataSource.java:57) at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1190) at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:63) at com.thortech.xl.dataobj.tcDataSet.getColumnDataType(tcDataSet.java:564) at oracle.iam.oimdataproviders.impl.OIMRelationProvider.isDate(OIMRelationProvider.java:234) at oracle.iam.oimdataproviders.impl.OIMRelationProvider.getSearchFilter(OIMRelationProvider.java:308) at oracle.iam.oimdataproviders.impl.OIMRelationProvider.getSearchFilter(OIMRelationProvider.java:275) at oracle.iam.oimdataproviders.impl.OIMRoleGrantRelationProvider.lookup(OIMRoleGrantRelationProvider.java:717) at oracle.iam.platform.entitymgr.impl.EntityManagerImpl.findRelation(EntityManagerImpl.java:1489) at sun.reflect.GeneratedMethodAccessor1238.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy302.findRelation(Unknown Source) at oracle.iam.identity.rolemgmt.utils.RoleManagerUtils.getRoleGrantRelationEM(RoleManagerUtils.java:2693) at oracle.iam.identity.rolemgmt.utils.RoleManagerUtils.getRoleGrantRelation(RoleManagerUtils.java:2669) at oracle.iam.identity.rolemgmt.impl.RoleManagerImpl.getRoleGrantDetails(RoleManagerImpl.java:1004) at oracle.iam.identity.rolemgmt.impl.RoleManagerImpl.getUserRoleGrants(RoleManagerImpl.java:1655) at sun.reflect.GeneratedMethodAccessor1267.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy483.getUserRoleGrants(Unknown Source) at oracle.iam.identity.ruleengine.impl.RuleEngine.calculateContainingEntitiesToRemoveFromEntity(RuleEngine.java:435) at oracle.iam.identity.ruleengine.impl.RuleEngine.getRelationshipChangesInScope(RuleEngine.java:134) at oracle.iam.identity.ruleengine.impl.RuleEngine.getRelationshipChanges(RuleEngine.java:125) at oracle.iam.identity.usermgmt.impl.handlers.UserPostProcessActionHandler.callRuleEngine(UserPostProcessActionHandler.java:109) at oracle.iam.identity.usermgmt.impl.handlers.UserPostProcessActionHandler.execute(UserPostProcessActionHandler.java:87) at oracle.iam.platform.kernel.impl.OrchProcessData.runPostProcessEvents(OrchProcessData.java:1490) at oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:896) at oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:357) at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:949) at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:978) at oracle.iam.platform.kernel.impl.OrhestrationAsyncTask.execute(OrhestrationAsyncTask.java:134) at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:99) at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:69) at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68) at sun.reflect.GeneratedMethodAccessor1209.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy475.onMessage(Unknown Source) at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583) at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486) at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:389) at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659) at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345) at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3822) at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115) at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170) at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1558) at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:478) at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:462) at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:512) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491) at sun.reflect.GeneratedMethodAccessor698.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy138.getConnection(Unknown Source) at oracle.iam.platform.utils.vo.OIMDataSource.getConnection(OIMDataSource.java:57) at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:200) at com.thortech.xl.dataaccess.tcDataBase.getConnection(tcDataBase.java:3255) at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1267) at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1190) at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:63) at com.thortech.xl.dataobj.tcDataSet.getColumnDataType(tcDataSet.java:564) at oracle.iam.oimdataproviders.impl.OIMRelationProvider.isDate(OIMRelationProvider.java:234) at oracle.iam.oimdataproviders.impl.OIMRelationProvider.getSearchFilter(OIMRelationProvider.java:308) at oracle.iam.oimdataproviders.impl.OIMRelationProvider.getSearchFilter(OIMRelationProvider.java:275) at oracle.iam.oimdataproviders.impl.OIMRelationProvider.search(OIMRelationProvider.java:503) at oracle.iam.oimdataproviders.impl.OIMRoleGrantRelationProvider.lookup(OIMRoleGrantRelationProvider.java:717) at oracle.iam.platform.entitymgr.impl.EntityManagerImpl.findRelation(EntityManagerImpl.java:1489) at sun.reflect.GeneratedMethodAccessor1238.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy302.findRelation(Unknown Source) at oracle.iam.identity.rolemgmt.utils.RoleManagerUtils.getRoleGrantRelationEM(RoleManagerUtils.java:2693) at oracle.iam.identity.rolemgmt.utils.RoleManagerUtils.getRoleGrantRelation(RoleManagerUtils.java:2669) at oracle.iam.identity.rolemgmt.impl.RoleManagerImpl.getRoleGrantDetails(RoleManagerImpl.java:1004) at oracle.iam.identity.rolemgmt.impl.RoleManagerImpl.getUserRoleGrants(RoleManagerImpl.java:1655) at sun.reflect.GeneratedMethodAccessor1267.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy483.getUserRoleGrants(Unknown Source) at oracle.iam.identity.ruleengine.impl.RuleEngine.calculateContainingEntitiesToRemoveFromEntity(RuleEngine.java:429) at oracle.iam.identity.ruleengine.impl.RuleEngine.getRelationshipChangesInScope(RuleEngine.java:320) at oracle.iam.identity.ruleengine.impl.RuleEngine.getRelationshipChangesInScope(RuleEngine.java:134) at oracle.iam.identity.ruleengine.impl.RuleEngine.getRelationshipChanges(RuleEngine.java:125) at oracle.iam.identity.usermgmt.impl.handlers.UserPostProcessActionHandler.callRuleEngine(UserPostProcessActionHandler.java:109) at oracle.iam.identity.usermgmt.impl.handlers.UserPostProcessActionHandler.execute(UserPostProcessActionHandler.java:87) at oracle.iam.platform.kernel.impl.OrchProcessData.runPostProcessEvents(OrchProcessData.java:1490) at oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:896) at oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:357) at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:948) at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:978) at oracle.iam.platform.kernel.impl.OrhestrationAsyncTask.execute(OrhestrationAsyncTask.java:134) at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:99) at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:69) at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68) at sun.reflect.GeneratedMethodAccessor1209.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy475.onMessage(Unknown Source) at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583) at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486) at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:388) at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659) at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345) at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821) at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115) at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170) at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Unknown visitor
Unknown visitor2 times, last one
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,