Version Information
Current Version: | 1.8.2beta |
---|---|
Release Date: | May 2025 |
License: | Mozilla 2 Open-Source License |
Download
Description | i2b2 Release Version | Minimum Version Required | Download Link |
---|---|---|---|
Files to install the i2b2 server to 1.8.2beta | 1.8.2beta | 1.7.09c | |
Files to install the i2b2 db instance to 1.8.2beta | 1.8.2beta | 1.7.09c | |
Files to install the webclient | 1.8.2beta |
Notes
i2b2 1.8.2beta release requires a new install of i2b2 Core Server since Wildfly 34 and java to 17 versions are now the pre-requisites due to support to spring 6 libraries included in the i2b2 application.
i2b2 database can be upgraded to latest version.
Upgrade Instructions
Follow the steps below to install i2b2 server, upgrade database instance and the webclient.
Steps to Install i2b2 Server
In the following instructions the variable {version } refers to your version of Wildfly installed. We now support Wildfly 34 version.
Stop WildFly
Install Core i2b2 Server
- Install Java 17
- Upgrade Wildfly to version 34
- Copy the entire wildfly-34.0.1.Final folder to your /opt folder.
- Linux: cp –r wildfly-34.0.1.Final /opt
- Windows: xcopy /E wildfly-34.0.1.Final C:\opt
- In /opt/wildfly-34.0.1.Final/standalone/deployments folder, copy the datasource files from your existing installation.
- Update the <driver>(driver name)</driver> tag to reflect the updated database driver versions:
- Postgres: postgresql-42.7.4.jar
- Oracle: ojdbc11.jar
- SqlServer: mssql-jdbc-12.8.1.jre11.jar
- ds.xml files to edit:
- crc-ds.xml
- ont-ds.xml
- pm-ds.xml
- work-ds.xml
Migrate cell properties to 1.8.2 if needed. In 1.7.12, cell properties have been moved to the database, in a table called hive_cell_params. If any cell properties were previously changed, they will need to be manually updated in the database. After this, the properties files can be deleted to prevent confusion.
More documentation on setting cell properties is available at this page. Most commonly, the AGG_SERVICE_ACCOUNT password will need to be updated. Generally, the cell URLs do not need to be configured anymore, as the hostname and port is now auto-detected.
Properties files are stored at /opt/wildfly-{version}.Final/standalone/configuration/ on Linux and c:\opt\wildfly-{version}.Final\standalone\configuration\ on Windows. The table can be edited with a SQL editor in hive_cell_params.
Steps Upgrade i2b2 database
Steps to perform db upgrade:
- Open the command prompt and navigate to the extracted data folder.
- Edit the db.properties files to reflect your database configuration, or copy the db.properties files from your existing data installation folder into the respective locations (namely Crcdata, Hivedata, Metadata, PMdata )
- From the command prompt, navigate to each cell folder and run the following upgrade ant commands on your i2b2 database instance, where {db} can be Oracle, sqlserver or postgresql.
- Alternative to above Step, you can run individual SQL scripts on your db instance in place of ant commands.
- In datafolder\Release_1-8\Upgrade\ run the ant commands under each individual cell folder as below
Upgrade db From Build | Upgrade db to Latest build |
---|---|
1.7.09c | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-09c upgrade_tables_release_1-7-10 upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-10 upgrade_tables_release_1-7-12a In the Pmdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-09c |
1.7.10 | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_table_release_1-7-10 upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-10 upgrade_tables_release_1-7-12a |
1.7.11 | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11 upgrade_table_release_1-7-12a In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12a |
1.7.12a | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12a In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12a In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12a |
1.7.13 | For Oracle and Postgres, no database upgrade is required. If using SQL Server, reload the following stored procedures: In the Metadata folder run the following ant command: ant -f data_build.xml rebuild_procedures |
1.8.0 | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-8-0 In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-8-0 In the Metadata folder run the following ant command: ant -f data_build.xml rebuild_procedures |
1.8.1 | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-8-1 In the Metadata folder run the following ant command: ant -f data_build.xml rebuild_procedures |
HIVE_CELL_PARAMS configuration
Check HIVE_CELL_PARAMS table is updated with cell properties parameters as detailed here
Steps to Upgrade i2b2 Webclient
Backup existing webclient folder to a different location outside of your current webclient installation folder
Install new webclient
- Replace your existing webclient folder on your web server with the extracted new webclient folder
- i2b2_config_data.js has been renamed to i2b2_config_domain.json. Edit the i2b2_config_domain.json using your existing i2b2_config_data.js from your backed up web directory. Details are provided here
Backup your entire webclient folder before proceeding with webclient upgrade
Start WildFly
You can either run WildFly standalone or as a service.
Verify Your Upgrade
Test Webclient
Navigate to your local i2b2 Web Client in your preferred browser and verify you are able to log on and perform standard i2b2 functions. (e.g. Run queries, retrieve previous queries, view breakdowns, etc.)