Troubleshooting
Problem
Experience an exception: java.sql.SQLException: DSRA9350E: Operation Connection.rollback is not allowed during a global transaction. This was happening during accessing a legacy Workflow Systems via FileNet Content Engine administrative console for Content Engine (ACCE) and when trying to transfer a workflow in IBM Content Navigator.
Symptom
Here is the excerpt of the Process server trace where it shows the exception during the workflow transfer:
2019/05/06 18:57:59.454-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Info] Transfer finished successfully (2294).
2019/05/06 18:57:59.455-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Trace] DBI_TRAN, DistributedTransactionSuspend, check state threadState=0, transManager=1, con=eb89a82b
2019/05/06 18:57:59.455-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Trace] DBI_TRAN, Suspending distributed transaction, con=eb89a82b
2019/05/06 18:57:59.459-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Trace] DBI_MSGS, SQL executed in 3.9 msecs, prep=1, timeout=0, con=6054f44d: "SELECT F_Blob, F_ObjName, F_ObjInt, F_Flags FROM dbo.VWObject1 where F_ObjName = ? ", params="ws.runtime.latest"
2019/05/06 18:57:59.464-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Trace] DBI_MSGS, Transaction con=6054f44d committed in: 1.7 msecs
2019/05/06 18:57:59.464-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Trace] DBI_TRAN, Resuming distributed transaction, con=eb89a82b
2019/05/06 18:57:59.468-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Trace] DBI_TRAN, DistributedTransactionSuspend, check state threadState=0, transManager=1, con=eb89a82b
2019/05/06 18:57:59.468-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Trace] DBI_TRAN, Suspending distributed transaction, con=eb89a82b
2019/05/06 18:57:59.472-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Trace] DBI_MSGS, SQL executed in 3.7 msecs, prep=1, timeout=0, con=6054f44d: "SELECT F_ObjName, F_ObjInt, F_Flags FROM dbo.VWObject1 WITH ( UPDLOCK,ROWLOCK ) where F_ObjName = ? ", params="pa.wc.35.4"
...
2019/05/06 18:57:59.517-0500 RPCHandler ORB.thread.pool : 0 DB=FNPEDSCN Reg#1 [Error] FNRPE1210001000E Transfer failed; Exception: Database error. See chained exception
; null
at filenet.jpe.database.DbDesc.MapMSSQLError(DbDesc.java:1196)
at filenet.jpe.database.DbDesc.ConvertError(DbDesc.java:1141)
at filenet.jpe.database.DbDesc.ConvertError(DbDesc.java:1131)
at filenet.jpe.database.DbTransaction.EndTransaction(DbTransaction.java:366)
at filenet.jpe.server.transfer.TransferObjects.logNewWorkClass(TransferObjects.java:2383)
at filenet.jpe.server.transfer.TransferObjects.transferClasses(TransferObjects.java:925)
at filenet.jpe.server.transfer.TransferObjects.transfer(TransferObjects.java:213)
at filenet.jpe.server.transfer.TransferObjects.synchronousTransfer(TransferObjects.java:120)
at filenet.jpe.server.common.IVWRuntimeServer.transfer(IVWRuntimeServer.java:1373)
at filenet.jpe.rpc.ejb.EJB_rpc_transferWorkflowCollection.execute(EJB_rpc_transferWorkflowCollection.java:126)
...
Caused by: java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1159)
at filenet.jpe.database.DbTransaction.EndTransaction(DbTransaction.java:345)
... 32 moreDocument Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTHRT","label":"IBM Case Foundation"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"5.5.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
24 February 2020
UID
ibm10885060