wiki:i2b2 Gotchas Timeout on Complex Exports

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:

<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.

Error: Macro BackLinks(None) failed
'Environment' object has no attribute 'get_db_cnx'

Last modified 7 years ago Last modified on 12/10/15 09:12:36
Note: See TracWiki for help on using the wiki.