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.

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

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

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.