== i2b2 fixes ==

=== Potential Fix for i2b2 Workbench Missing en_GB Properties file ===
Missing properties file Workplace_en_GB.properties file causes a Missing Resource Exception within the workbench.[[BR]]


When you installed the Window's version of the workbench, it would have been unzipped into a directory, [[BR]]
For example, C:\i2b2Workbench\Windows [[BR]]

There is a directory for plugins, viz: C:\i2b2Workbench\Windows\plugins[[BR]]

Copy the attached file into that directory. (It replaces one already there so you may want to save the old one). When it has been replaced, restart the workbench.

=== Transaction timeout when building complex exports ===

I reviewed some log files today after the STEMI query I ran for Prof Samani and Pete Braund crashed in a similar way to previous complex queries.

It seems likely 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.