= i2b2 Gotchas Timeout on Complex Exports

Tags: [[i2b2]] [[Gotchas]] [[JBOSS]]

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:

{{{
#!xml
<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.

[[BackLinks]]