Version 2 (modified by 9 years ago) ( diff ) | ,
---|
i2b2 Gotchas Timeout on Complex Exports
It seems that the ‘JBOSS transaction timeout’ is being reached when a complex set of requirements is passed to hibernate for building the export data set.
In jboss/server/default/conf/jboss-service.xml
, there is a stanza devoted to the transaction manager:
<mbean code="com.arjuna.ats.jbossatx.jta.TransactionManagerService?" name="jboss:service=TransactionManager"> <attribute name="TransactionTimeout?">300</attribute> <attribute name="ObjectStoreDir?">${jboss.server.data.dir}/tx-object-store</attribute> </mbean>
300 seconds is 5 minutes. I’ve set it on uhlbriccsapp03 to be 1200 seconds, or 20 minutes, and as a result the query I ran today was able to complete successfully.
Note:
See TracWiki
for help on using the wiki.