java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • IOExceptions in WLI server
    via by 666705,
  • Error in Obtaining Connection
    via by 843830,
  • TxDataSources / XA Drivers
    via by Pete Hilfiker,
  • Problem getting connection with optimistic concurrency
    via by Ellen Kraffmiller,
  • Weird Problem
    via by Rupesh,
    • java.sql.SQLException: Transaction BEA1-7CE0DDBD91BDCD32FFBB not active anymore. tx status = Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 520 seconds Name=[EJB ejb.BRAINTracker.logOutgoingDealMessage(com.hp.brain.spihDeal.SPIHDEALMSGDocument,long,java.lang.String,java.lang.String,java.lang.String,java.lang.String)],Xid=BEA1-7CE0DDBD91BDCD32FFBB(26587383),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=543,seconds left=23,activeThread=Thread[ExecuteThread: '7' for queue: 'weblogic.kernel.Default',5,Thread Group for Queue: 'weblogic.kernel.Default'],XAServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(ServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(state=started,assigned=none),xar=weblogic.jdbc.wrapper.JTSXAResourceImpl@953854,re-Registered = false),SCInfo[brain+cgServer]=(state=active),properties=({weblogic.transaction.name=[EJB ejb.BRAINTracker.logOutgoingDealMessage(com.hp.brain.spihDeal.SPIHDEALMSGDocument,long,java.lang.String,java.lang.String,java.lang.String,java.lang.String)], ISOLATION LEVEL=2, weblogic.jdbc=t3://15.140.173.79:7004}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=cgServer+15.140.173.79:7004+brain+t3+, XAResources={JMS_FileStore, weblogic.jdbc.wrapper.JTSXAResourceImpl, JMS_cgJMSStore},NonXAResources={})],CoordinatorURL=cgServer+15.140.173.79:7004+brain+t3+)] at weblogic.jdbc.jts.Driver.getTransaction(Driver.java:430) at weblogic.jdbc.jts.Driver.connect(Driver.java:127) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305) at data.TrackingDataAccess.getConnection(TrackingDataAccess.java:50) at data.TrackingDataAccess.insRelation(TrackingDataAccess.java:421) at ejb.BRAINTracker.insRelationImpl(BRAINTracker.java:204) at ejb.BRAINTracker.logOutgoingDealMessage(BRAINTracker.java:416) at ejb.BRAINTracker_xmojr0_ELOImpl.logOutgoingDealMessage(BRAINTracker_xmojr0_ELOImpl.java:101) at sun.reflect.GeneratedMethodAccessor317.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.bea.wlw.runtime.core.control.EJBControlImpl.invoke(EJBControlImpl.jcs:665) at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:377) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:423) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:396) at com.bea.wlw.runtime.jcs.container.JcsProxy.invoke(JcsProxy.java:388) at $Proxy77.logOutgoingDealMessage(Unknown Source) at control.SPIHInterfacesImpl.logOutgoingMessage(SPIHInterfacesImpl.jcs:512) at control.SPIHInterfacesImpl.sendMsg(SPIHInterfacesImpl.jcs:652) at control.SPIHInterfacesImpl.sendSPIHDEALMSG_DealFromOrder(SPIHInterfacesImpl.jcs:121) at sun.reflect.GeneratedMethodAccessor514.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:371) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:423) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:396) at com.bea.wlw.runtime.jcs.container.JcsProxy.invoke(JcsProxy.java:381) at $Proxy81.sendSPIHDEALMSG_DealFromOrder(Unknown Source) at process.ProcessOrder.ctlSPIHInterfacesSendSPIHDEALMSG_DealFromOrder(ProcessOrder.jpd:369) at process.ProcessOrder_wf$ImplControlSend42.invoke(ProcessOrder_wf.java:359) at com.bea.wli.bpm.runtime.Perform.execute(Perform.java:32) at com.bea.wli.bpm.runtime.ProcessState.executeInternalCallback(ProcessState.java:726) at process.ProcessOrder_wf$_ProcessState.executeInternalCallback(ProcessOrder_wf.java:762) at com.bea.wli.bpm.runtime.ProcessState.executeInternalCallback(ProcessState.java:685) at com.bea.wli.bpm.runtime.ProcessState.processNodeOrchestration(ProcessState.java:681) at sun.reflect.GeneratedMethodAccessor140.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:371) at com.bea.wli.bpm.runtime.JpdInternalDispMethod.invoke(JpdInternalDispMethod.java:87) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:423) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:396) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:248) at com.bea.wlw.runtime.core.bean.BaseContainerBean.invokeBase(BaseContainerBean.java:224) at com.bea.wlw.runtime.core.bean.BMPContainerBean.invoke(BMPContainerBean.java:2033) at com.bea.wli.bpm.runtime.ProcessContainerBean.invoke(ProcessContainerBean.java:163) at com.bea.wlwgen.PersistentContainer_5fh2mm_ELOImpl.invoke(PersistentContainer_5fh2mm_ELOImpl.java:261) at com.bea.wlwgen.ProcessOrderBMPContAdpt.invokeOnBean(ProcessOrderBMPContAdpt.java:114) at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(BaseDispatcherBean.java:153) at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.run(BaseDispatcherBean.java:85) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147) at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(BaseDispatcherBean.java:50) at com.bea.wlw.runtime.core.bean.AsyncDispatcherBean.onMessage(AsyncDispatcherBean.java:248) at weblogic.ejb20.internal.MDListener.execute(MDListener.java:370) at weblogic.ejb20.internal.MDListener.onMessage(MDListener.java:262) at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:2678) at weblogic.jms.client.JMSSession.execute(JMSSession.java:2598) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor2 times, last one,