CheckSubmit Job Fails with java.sql.SQLException: The transaction is no longer active (Doc ID 474653.1)

Last updated on MARCH 06, 2017

Applies to:

Siebel Comm Self-Service Manager - Version 5.1 and later
Information in this document applies to any platform.
Area(s):eaPay/Payment Module/ePayment Mgr
Release(s):V3 (Siebel Self-Service)
Database(s):All Supported Databases
App Server OS(s):All Supported Platforms
Latest release tested against:V3 (Siebel Self-Service)
Keywords:Q103558, JTA, timeout setting does not work

Applicable Products
eaPay for Solaris (SOL3.4)

This document was previously published as Siebel FAQ 441.


Symptoms

As per eaPay Production Guide, User has increased JTA timeout setting in WebLogic to 120 seconds to handle an increased number of checks. But, the job still fails with the following error:

CheckSubmit job failed to update check status in DB. The transaction has been rolled back and the check file /opt/EDCSbd/payment/legacyelectric/out/bd/Production.debit.dat.20040120130739.pgp is going to be removed.

The error is java.sql.SQLException: The transaction is no longer active (status = Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 63 seconds Xid=18058:0d60b352408f87e0(8040715),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=63,seconds left=60,activeThread=Thread[ExecuteThread: '4' for queue: 'default',5,Thread Group for Queue: 'default'],ServerResourceInfo[weblogic.jdbc.jts.Connection] =(state=started,assigned=none),SCInfo[mydomain+CmdCenter] =(state=active),properties =({weblogic.jdbc=t3://:7021}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor (CoordinatorURL=CmdCenter+:7021+mydomain+, Resources={})],CoordinatorURL=CmdCenter+:7021+mydomain+)]).
No further JDBC access is allowed within this transaction.
at weblogic.jdbc.jts.Connection.checkIfRolledBack(Connection.java:512)
at weblogic.jdbc.jts.Statement.getInt(Statement.java:1083)
at weblogic.jdbc.rmi.internal.CallableStatementImpl.getInt(CallableStatementImpl.java:110)
at weblogic.jdbc.rmi.SerialCallableStatement.getInt(SerialCallableStatement.java:154)
at com.edocs.payment.db.SQLStatement.getInt(SQLStatement.java:600)
at com.edocs.payment.db.SQLStatement.executeSqlUpdate(SQLStatement.java:504)
at com.edocs.payment.db.proc.CheckPaymentLog.updateInternal(CheckPaymentLog.java:399)
at com.edocs.payment.db.proc.CheckPaymentLog.update(CheckPaymentLog.java:290)
at com.edocs.payment.cassette.checkfree.cdp.checkfree_CheckCassette.batchSubmit(checkfree_CheckCassette.java:342)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask.executeTask(CheckSubmitTask.java:185)
at com.edocs.payment.tasks.PaymentTask.doProcessTask(PaymentTask.java:24)
at com.edocs.pwc.tasks.CommonTask.processTask(CommonTask.java:184)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask_loedhe_EOImpl.processTask(CheckSubmitTask_loedhe_EOImpl.java:127)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask_loedhe_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:305)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:274)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

Caught CassetteException: com.edocs.payment.cassette.CassetteException: java.sql.SQLException: The transaction is no longer active (status = Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 63 seconds Xid=18058:0d60b352408f87e0(8040715),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=63,seconds left=60,activeThread=Thread[ExecuteThread: '4' for queue: 'default',5,Thread Group for Queue: 'default'],ServerResourceInfo[weblogic.jdbc.jts.Connection] =(state=started,assigned=none),SCInfo[mydomain+CmdCenter] =(state=active),properties=({weblogic.jdbc=t3://:7021}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor (CoordinatorURL=CmdCenter+:7021+mydomain+, Resources ={})],CoordinatorURL=CmdCenter+:7021+mydomain+)]). No further JDBC access is allowed within this transaction.
at com.edocs.payment.cassette.checkfree.cdp.checkfree_CheckCassette.batchSubmit(checkfree_CheckCassette.java:349)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask.executeTask(CheckSubmitTask.java:185)
at com.edocs.payment.tasks.PaymentTask.doProcessTask(PaymentTask.java:24)
at com.edocs.pwc.tasks.CommonTask.processTask(CommonTask.java:184)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask_loedhe_EOImpl.processTask(CheckSubmitTask_loedhe_EOImpl.java:127)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask_loedhe_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:305)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:274)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

Exception caught: com.edocs.payment.cassette.CassetteException: java.sql.SQLException: The transaction is no longer active (status = Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 63 seconds Xid=18058:0d60b352408f87e0(8040715),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=63,seconds left=60,activeThread=Thread[ExecuteThread: '4' for queue: 'default',5,Thread Group for Queue: 'default'],ServerResourceInfo[weblogic.jdbc.jts.Connection]=(state=started,assigned=none),SCInfo[mydomain+CmdCenter]=(state=active),properties=({weblogic.jdbc=t3://:7021}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor (CoordinatorURL=CmdCenter+:7021+mydomain+, Resources={})],CoordinatorURL=CmdCenter+:7021+mydomain+)]). No further JDBC access is allowed within this transaction.
at com.edocs.payment.cassette.checkfree.cdp.checkfree_CheckCassette.batchSubmit(checkfree_CheckCassette.java:349)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask.executeTask(CheckSubmitTask.java:185)
at com.edocs.payment.tasks.PaymentTask.doProcessTask(PaymentTask.java:24)
at com.edocs.pwc.tasks.CommonTask.processTask(CommonTask.java:184)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask_loedhe_EOImpl.processTask(CheckSubmitTask_loedhe_EOImpl.java:127)
at com.edocs.payment.tasks.chksubmit.CheckSubmitTask_loedhe_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:305)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:274)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

Failure in job processor thread for: {Job Instance ID=689864, Schedule ID=-1, DDN=legacyelectric, Job Name=legacyElecChkSub, Schedule Date/Time=Tue Jan 20 13:07:29 CST 2004(1074625649000), Status=Not yet started, Elapsed seconds=-1, Started At=Wed Dec 31 17:59:59 CST 1969(-1000), Ended At=Wed Dec 31 17:59:59 CST 1969(-1000), Last Task Name=, Last Task Order=-1, Input Value=, Group ID=0} com.edocs.payment.cassette.CassetteException: java.sql.SQLException: The transaction is no longer active (status = Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 63 seconds Xid=18058:0d60b352408f87e0(8040715),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=63,seconds left=60,activeThread=Thread[ExecuteThread: '4' for queue: 'default',5,Thread Group for Queue: 'default'],ServerResourceInfo[weblogic.jdbc.jts.Connection]=(state=started,assigned=none),SCInfo[mydomain+CmdCenter]=(state=active),properties=({weblogic.jdbc=t3://:7021}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=CmdCenter+:7021+mydomain+, Resources={})],CoordinatorURL=CmdCenter+:7021+mydomain+)]). No further JDBC access is allowed within this transaction.
at weblogic.rmi.internal.BasicOutboundRequest.sendReceive(BasicOutboundRequest.java:85)
at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:136)
at weblogic.rmi.internal.ProxyStub.invoke(ProxyStub.java:35)
at $Proxy7.processTask(Unknown Source)
at com.edocs.pwc.scheduler.JobProcessor.run(JobProcessor.java:502)

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