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.
Last modified
8 years ago
Last modified on 12/10/15 09:12:36
Note:
See TracWiki
for help on using the wiki.
