Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Stale Connection intermittently seen when my application (deployed on WAS) connects to Oracle DB using WAS datasource(thin jdbc driver)

Posted on 2008-10-28
5
Medium Priority
?
5,959 Views
Last Modified: 2013-12-19
[10/28/08 9:56:55:961 GMT] 00000046 WSRdbXaResour E   DSRA0304E:  XAException occurred. XAException contents and details are:
The XA Error is            : -7
The XA Error message is    : Resource manager is unavailable.
The Oracle Error code is   : 17002
The Oracle Error message is: Internal XA Error
The cause is               : null.
[10/28/08 9:56:55:985 GMT] 00000046 WSRdbXaResour E   DSRA0302E:  XAException occurred.  Error code is: XAER_RMFAIL (-7).  Exception is: <null>
[10/28/08 9:56:55:993 GMT] 00000046 ConnectionEve A   J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adapter for resource CDMSOSDSXA.  The exception which was received is oracle.jdbc.xa.OracleXAException
[10/28/08 9:56:56:005 GMT] 00000046 RegisteredRes E   WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMFAIL. The exception stack trace follows: oracle.jdbc.xa.OracleXAException
      at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1120)
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:249)
      at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1324)
      at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1467)
      at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:145)
      at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1223)
      at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:637)
      at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3284)
      at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:397)
      at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:693)
      at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1859)
      at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2180)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:619)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2038)
      at com.filenet.engine.dbpersist.DBStatementBase.buildSingleExecution(DBStatementBase.java:450)
      at com.filenet.engine.dbpersist.DBStatementBase.execute(DBStatementBase.java:237)
      at com.filenet.engine.security.SecurityServer.getSecurityFromDB(SecurityServer.java:1578)
      at com.filenet.engine.security.SecurityServer.getObjectSecurity(SecurityServer.java:1164)
      at com.filenet.engine.persist.IndependentPersister.checkCreateInstancePermission(IndependentPersister.java:1679)
      at com.filenet.engine.persist.IndependentPersister.checkCreatePermissions(IndependentPersister.java:1483)
      at com.filenet.engine.persist.IndependentPersister.preCreate(IndependentPersister.java:1020)
      at com.filenet.engine.persist.IndependentPersister.preExecuteChange(IndependentPersister.java:453)
      at com.filenet.engine.persist.SubscribablePersister.preExecuteChange(SubscribablePersister.java:242)
      at com.filenet.engine.persist.ContainablePersister.preExecuteChange(ContainablePersister.java:93)
      at com.filenet.engine.persist.WithContentPersister.preExecuteChange(WithContentPersister.java:489)
      at com.filenet.engine.persist.VersionablePersister.preExecuteChange(VersionablePersister.java:225)
      at com.filenet.engine.persist.IndependentPersister.executeChangeWork(IndependentPersister.java:366)
      at com.filenet.engine.persist.IndependentPersister.executeChange(IndependentPersister.java:231)
      at com.filenet.engine.persist.SubscribablePersister.executeChange(SubscribablePersister.java:152)
      at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestBrokerImpl.java:1258)
      at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestBrokerImpl.java:1140)
      at com.filenet.engine.ejb.EngineCoreBean._executeChanges(EngineCoreBean.java:570)
      at com.filenet.engine.ejb.EngineCoreBean.executeChanges(EngineCoreBean.java:538)
      at com.filenet.engine.ejb.EJSLocalStatelessEngineCore_22877cb1.executeChanges(Unknown Source)
      at com.filenet.engine.ejb.EngineBean.executeChanges(EngineBean.java:641)
      at com.filenet.apiimpl.transport.ejbstubs.EJSRemoteStatelessEngine_2e64c374.executeChanges(Unknown Source)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:615)
      at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:727)
      at java.security.AccessController.doPrivileged(AccessController.java:241)
      at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:725)
      at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1123)
      at $Proxy84.executeChanges(Unknown Source)
      at com.filenet.apiimpl.transport.ejbstubs._Engine_Stub.executeChanges(Unknown Source)
      at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl._executeChanges(EJBSession.java:586)
      at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl.run(EJBSession.java:397)
      at java.security.AccessController.doPrivileged(AccessController.java:274)
      at javax.security.auth.Subject.doAs(Subject.java:573)
      at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:168)
      at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:615)
      at com.filenet.apiimpl.util.J2EEUtilWS.doAs(J2EEUtilWS.java:207)
      at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl.executeChanges(EJBSession.java:475)
      at com.filenet.apiimpl.transport.ejb.EJBSession.executeChanges(EJBSession.java:228)
      at com.filenet.apiimpl.util.SessionHandle.executeChanges(SessionHandle.java:122)
      at com.filenet.apiimpl.core.Session.callExecuteChanges(Session.java:179)
      at com.filenet.apiimpl.core.Session.executeChanges(Session.java:555)
      at com.filenet.apiimpl.core.Session.executeChange(Session.java:830)
      at com.filenet.apiimpl.core.IndependentlyPersistableObjectImpl.save(IndependentlyPersistableObjectImpl.java:77)
      at com.filenet.apiimpl.core.IndependentlyPersistableObjectImpl.save(IndependentlyPersistableObjectImpl.java:69)
      at com.filenet.wcm.api.impl.bd.ZMI_CreateDocument.execute(ZMI_CreateDocument.java:188)
      at com.filenet.wcm.api.impl.bd.MethodImplementation.createAndCall(MethodImplementation.java:152)
      at com.filenet.wcm.api.impl.bd.RcBd.doRpc(RcBd.java:116)
      at com.filenet.wcm.api.impl.bd.RcBd.doRpc(RcBd.java:33)
      at com.filenet.wcm.api.impl.RemoteCommand.execute(RemoteCommand.java:416)
      at com.filenet.wcm.api.impl.RemoteCommand.executeInner(RemoteCommand.java:398)
      at com.filenet.wcm.api.impl.RemoteCommand.execute(RemoteCommand.java:330)
      at com.filenet.wcm.api.impl.RemoteCommand.executeExpectingBO(RemoteCommand.java:249)
      at com.filenet.wcm.api.impl.ObjectStoreImpl.callCreateObject(ObjectStoreImpl.java:589)
      at com.filenet.wcm.api.impl.ObjectStoreImpl.createObject(ObjectStoreImpl.java:519)
      at com.filenet.bp8.apps.server.util.prefs.Bp8Config.addNewDocument(Bp8Config.java:148)
      at com.filenet.wcm.toolkit.server.util.prefs.WcmConfiguration.addUserPrefsDocument(WcmConfiguration.java:181)
      at com.filenet.bp8.apps.server.util.prefs.Bp8Config.createNewUserPrefs(Bp8Config.java:119)
      at com.filenet.wcm.toolkit.server.util.prefs.WcmConfiguration.loadUserPreferences(WcmConfiguration.java:207)
      at com.filenet.wcm.toolkit.server.util.prefs.WcmConfiguration.initialize(WcmConfiguration.java:106)
      at com.filenet.wcm.toolkit.server.util.prefs.WcmConfiguration.<init>(WcmConfiguration.java:64)
      at com.filenet.bp8.apps.server.util.prefs.Bp8Config.<init>(Bp8Config.java:81)
      at com.filenet.bp8.apps.server.controller.Bp8Controller.getBp8Config(Bp8Controller.java:221)
      at com.filenet.bp8.apps.server.controller.Bp8Controller.getConfiguration(Bp8Controller.java:213)
      at com.ibm._jsp._Bp8MainModuleJSP._jspService(_Bp8MainModuleJSP.java:190)
      at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:276)
      at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:463)
      at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:281)
      at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:256)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
      at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
      at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)
      at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:225)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:639)
      at com.filenet.wcm.toolkit.server.base.WcmController.serverSideInclude(WcmController.java:5541)
      at com.filenet.wcm.toolkit.server.base.WcmUiModule.serverSideInclude(WcmUiModule.java:602)
      at com.filenet.wcm.toolkit.server.base.WcmUiModule.serverSideInclude(WcmUiModule.java:567)
      at com.filenet.wcm.toolkit.server.base.WcmUiModule.renderJSP(WcmUiModule.java:669)
      at com.filenet.wcm.toolkit.server.util.WcmUi.render(WcmUi.java:90)
      at com.filenet.wcm.toolkit.server.util.WcmUi.render(WcmUi.java:82)
      at com.ibm._jsp._Bp8Main._jspService(_Bp8Main.java:140)
      at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:276)
      at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:463)
      at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:281)
      at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:256)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
      at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
      at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)
      at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:225)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:639)
      at com.filenet.wcm.toolkit.server.base.WcmController.serverSideInclude(WcmController.java:5541)
      at com.filenet.bp8.apps.server.controller.Bp8Controller.handleEvent(Bp8Controller.java:550)
      at com.ibm._jsp._Bp8Main._jspService(_Bp8Main.java:111)
      at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:276)
      at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:463)
      at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:281)
      at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:256)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
      at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
      at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)
      at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:225)
      at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
      at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
      at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)
      at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:113)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
      at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
      at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
      at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
      at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
      at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
      at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
      at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
      at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
      at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)

[10/28/08 9:56:56:081 GMT] 00000046 XATransaction E   J2CA0030E: Method enlist caught javax.transaction.SystemException: XAResource start association error:XAER_RMFAIL
      at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1274)
      at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:637)
      at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3284)
      at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:397)
      at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:693)
      at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1859)
      at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2180)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:619)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2038)
      at com.filenet.engine.dbpersist.DBStatementBase.buildSingleExecution(DBStatementBase.java:450)
      at com.filenet.engine.dbpersist.DBStatementBase.execute(DBStatementBase.java:237)
      at com.filenet.engine.security.SecurityServer.getSecurityFromDB(SecurityServer.java:1578)
      at com.filenet.engine.security.SecurityServer.getObjectSecurity(SecurityServer.java:1164)
      at com.filenet.engine.persist.IndependentPersister.checkCreateInstancePermission(IndependentPersister.java:1679)
      at com.filenet.engine.persist.IndependentPersister.checkCreatePermissions(IndependentPersister.java:1483)
      at com.filenet.engine.persist.IndependentPersister.preCreate(IndependentPersister.java:1020)
      at com.filenet.engine.persist.IndependentPersister.preExecuteChange(IndependentPersister.java:453)
      at com.filenet.engine.persist.SubscribablePersister.preExecuteChange(SubscribablePersister.java:242)
      at com.filenet.engine.persist.ContainablePersister.preExecuteChange(ContainablePersister.java:93)
      at com.filenet.engine.persist.WithContentPersister.preExecuteChange(WithContentPersister.java:489)
      at com.filenet.engine.persist.VersionablePersister.preExecuteChange(VersionablePersister.java:225)
      at com.filenet.engine.persist.IndependentPersister.executeChangeWork(IndependentPersister.java:366)
      at com.filenet.engine.persist.IndependentPersister.executeChange(IndependentPersister.java:231)
      at com.filenet.engine.persist.SubscribablePersister.executeChange(SubscribablePersister.java:152)
      at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestBrokerImpl.java:1258)
      at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestBrokerImpl.java:1140)
      at com.filenet.engine.ejb.EngineCoreBean._executeChanges(EngineCoreBean.java:570)
      at com.filenet.engine.ejb.EngineCoreBean.executeChanges(EngineCoreBean.java:538)
      at com.filenet.engine.ejb.EJSLocalStatelessEngineCore_22877cb1.executeChanges(Unknown Source)
      at com.filenet.engine.ejb.EngineBean.executeChanges(EngineBean.java:641)
      at com.filenet.apiimpl.transport.ejbstubs.EJSRemoteStatelessEngine_2e64c374.executeChanges(Unknown Source)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:615)
      at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:727)
      at java.security.AccessController.doPrivileged(AccessController.java:241)
      at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:725)
      at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1123)
      at $Proxy84.executeChanges(Unknown Source)
      at com.filenet.apiimpl.transport.ejbstubs._Engine_Stub.executeChanges(Unknown Source)
      at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl._executeChanges(EJBSession.java:586)
      at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl.run(EJBSession.java:397)
      at java.security.AccessController.doPrivileged(AccessController.java:274)
      at javax.security.auth.Subject.doAs(Subject.java:573)
      at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:168)
      at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:615)
      at com.filenet.apiimpl.util.J2EEUtilWS.doAs(J2EEUtilWS.java:207)
      at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl.executeChanges(EJBSession.java:475)
      at com.filenet.apiimpl.transport.ejb.EJBSession.executeChanges(EJBSession.java:228)
      at com.filenet.apiimpl.util.SessionHandle.executeChanges(SessionHandle.java:122)
      at com.filenet.apiimpl.core.Session.callExecuteChanges(Session.java:179)
      at com.filenet.apiimpl.core.Session.executeChanges(Session.java:555)
      at com.filenet.apiimpl.core.Session.executeChange(Session.java:830)
      at com.filenet.apiimpl.core.IndependentlyPersistableObjectImpl.save(IndependentlyPersistableObjectImpl.java:77)
      at com.filenet.apiimpl.core.IndependentlyPersistableObjectImpl.save(IndependentlyPersistableObjectImpl.java:69)
      at com.filenet.wcm.api.impl.bd.ZMI_CreateDocument.execute(ZMI_CreateDocument.java:188)
      at com.filenet.wcm.api.impl.bd.MethodImplementation.createAndCall(MethodImplementation.java:152)
      at com.filenet.wcm.api.impl.bd.RcBd.doRpc(RcBd.java:116)
      at com.filenet.wcm.api.impl.bd.RcBd.doRpc(RcBd.java:33)
      at com.filenet.wcm.api.impl.RemoteCommand.execute(RemoteCommand.java:416)
      at com.filenet.wcm.api.impl.RemoteCommand.executeInner(RemoteCommand.java:398)
      at com.filenet.wcm.api.impl.RemoteCommand.execute(RemoteCommand.java:330)
      at com.filenet.wcm.api.impl.RemoteCommand.executeExpectingBO(RemoteCommand.java:249)
      at com.filenet.wcm.api.impl.ObjectStoreImpl.callCreateObject(ObjectStoreImpl.java:589)
      at com.filenet.wcm.api.impl.ObjectStoreImpl.createObject(ObjectStoreImpl.java:519)
      at com.filenet.bp8.apps.server.util.prefs.Bp8Config.addNewDocument(Bp8Config.java:148)
      at com.filenet.wcm.toolkit.server.util.prefs.WcmConfiguration.addUserPrefsDocument(WcmConfiguration.java:181)
      at com.filenet.bp8.apps.server.util.prefs.Bp8Config.createNewUserPrefs(Bp8Config.java:119)
      at com.filenet.wcm.toolkit.server.util.prefs.WcmConfiguration.loadUserPreferences(WcmConfiguration.java:207)
      at com.filenet.wcm.toolkit.server.util.prefs.WcmConfiguration.initialize(WcmConfiguration.java:106)
      at com.filenet.wcm.toolkit.server.util.prefs.WcmConfiguration.<init>(WcmConfiguration.java:64)
      at com.filenet.bp8.apps.server.util.prefs.Bp8Config.<init>(Bp8Config.java:81)
      at com.filenet.bp8.apps.server.controller.Bp8Controller.getBp8Config(Bp8Controller.java:221)
      at com.filenet.bp8.apps.server.controller.Bp8Controller.getConfiguration(Bp8Controller.java:213)
      at com.ibm._jsp._Bp8MainModuleJSP._jspService(_Bp8MainModuleJSP.java:190)
      at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:276)
      at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:463)
      at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:281)
      at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:256)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
      at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
      at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)
      at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:225)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:639)
      at com.filenet.wcm.toolkit.server.base.WcmController.serverSideInclude(WcmController.java:5541)
      at com.filenet.wcm.toolkit.server.base.WcmUiModule.serverSideInclude(WcmUiModule.java:602)
      at com.filenet.wcm.toolkit.server.base.WcmUiModule.serverSideInclude(WcmUiModule.java:567)
      at com.filenet.wcm.toolkit.server.base.WcmUiModule.renderJSP(WcmUiModule.java:669)
      at com.filenet.wcm.toolkit.server.util.WcmUi.render(WcmUi.java:90)
      at com.filenet.wcm.toolkit.server.util.WcmUi.render(WcmUi.java:82)
      at com.ibm._jsp._Bp8Main._jspService(_Bp8Main.java:140)
      at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:276)
      at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:463)
      at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:281)
      at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:256)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
      at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
      at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)
      at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:225)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:639)
      at com.filenet.wcm.toolkit.server.base.WcmController.serverSideInclude(WcmController.java:5541)
      at com.filenet.bp8.apps.server.controller.Bp8Controller.handleEvent(Bp8Controller.java:550)
      at com.ibm._jsp._Bp8Main._jspService(_Bp8Main.java:111)
      at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:276)
      at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:463)
      at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:281)
      at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:256)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
      at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
      at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)
      at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:225)
      at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
      at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
      at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)
      at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:113)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
      at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
      at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
      at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
      at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
      at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
      at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
      at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
      at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
      at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
Caused by: oracle.jdbc.xa.OracleXAException
      at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1120)
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:249)
      at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1324)
      at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1467)
      at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:145)
      at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1223)
      ... 137 more
0
Comment
Question by:chittaranjanin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 1000 total points
ID: 22885323
0
 
LVL 16

Assisted Solution

by:JoWickerman
JoWickerman earned 1000 total points
ID: 22893570
Hi chittaranjanin,

Enable the pretest SQL in the JDBC datasource resource using the admin console. Be sure to specify a valid SQL statement. (Something like: "select 1 from schema.table" where table has only 1 row)

Cheers
0
 
LVL 16

Expert Comment

by:JoWickerman
ID: 23391012
Hi,

Are you happy with the solution? If so, you can close the question and award points.

Cheers.
0

Featured Post

ATEN's HDBaseT Presentation at InfoComm 2017

Hear ATEN Product Manager YT Liang review HDBaseT technology, highlighting ATEN’s latest solutions as they relate to real-world applications during her presentation at the HDBaseT booth at InfoComm 2017.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question