-
タイトル
Migration fails with Transaction roll back error for PS large object. -
説明
While migrating large object like peopleSoft page the migration fails with Transaction Roll back error in the server.log
WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012121: TransactionReaper::doCancellations worker Thread[Transaction Reaper Worker 0,5,main] successfully canceled TX 0:ffff0ac020ec:20035e8f:59381457:74673
ERROR [org.jboss.as.ejb3.invocation] (QuartzWorkerThread-9) JBAS014134: EJB Invocation failed on component ProcessMigrationHelperBean for method public abstract int
com.quest.stat.agent.ejb.session.migractivity.ProcessMigrationHelper.migratePSObject(com.quest.stat.agent.ejb.model.MercMigrEvent,
com.quest.stat.helpers.SwatObject,java.lang.String,java.lang.String,java.lang.String,
com.quest.stat.util.MigrationLogHelper,
com.quest.stat.util.MigrationDMScriptsHelper,java.lang.String,java.util.Map): javax.ejb.EJBTransactionRolledbackException: Transaction rolled back at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleEndTransactionException(CMTTxInterceptor.java:139) [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]
-
原因
Timeout issue. -
対策
This was solved by adding the below value in standalone_full.xml:
For Stat 5.8:<subsystem xmlns="urn:jboss:domain:transactions:3.0">
<core-environment>
<process-id><uuid/></process-id>
</core-environment>
<recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>
<coordinator-environment default-timeout="1200"/> <=== Here is the timeout to increase
</subsystem>
For Stat 6.3.0:
<subsystem xmlns="urn:jboss:domain:transactions:5.0">
<core-environment node-identifier="${jboss.tx.node.id:1}">
<process-id>
<uuid/>
</process-id>
</core-environment>
<recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>
<coordinator-environment default-timeout="1200" statistics-enabled="${wildfly.transactions.statistics-enabled:${wildfly.statistics-enabled:false}}"/>