Changes between Initial Version and Version 1 of i2b2 Gotchas Timeout on Complex Exports

Timestamp:

12/10/15 09:11:55 (9 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Gotchas Timeout on Complex Exports

@@ +1 @@
+= 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.
+
+[[BackLinks]]