Page History
...
Community-Contributed Features
Contribution | Contributor | |
Backend Features
SAML Authentication
...
- Backup your existing data folder
- Copy all the folders from the extracted download data folder into your existing data Upgrade folder
Example: Downloads\2b2core-upgrade-1712a\i2b2\data to C:\opt\edu.harvard.i2b2.data\Release_1-7\Upgrade\. This will replace
existing Crcdata, Hivedata, Metadata, PMdata folders.
Alternative to above step, navigate to the edu.harvard.i2b2.data\Release_1-7\Upgrade\ directory of your extracted folder - Copy the db.properties files from your back up into the respective locations(namely Crcdata, Hivedata, Metadata, PMdata )
- Open the command prompt and navigate to cell folders 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 data folder\Release_1-7\Upgrade\ run the ant commands under each individual cell subfolder as below. | |
| Upgrade From Build | Upgrade to Latest build |
1.7.09c | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_table_release_1-7-09c upgrade_table_release_1-7-10 upgrade_table_release_1-7-11 upgrade_table_release_1-7-12 In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_hive_tables_release_1-7-09c upgrade_hive_tables_release_1-7-10 upgrade_hive_tables_release_1-7-11 upgrade_hive_tables_release_1-7-12 In the Metadata 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-12 In the PMdata folder run the following ant command: ant -f data_build.xml upgrade_pm_tables_release_1-7-09c upgrade_pm_tables_release_1-7-10 upgrade_pm_tables_release_1-7-11 upgrade_pm_tables_release_1-7-12 |
1.7.10 | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_table_release_1-7-10 upgrade_table_release_1-7-11 upgrade_table_release_1-7-12 In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_hive_tables_release_1-7-10 upgrade_hive_tables_release_1-7-11 upgrade_hive_tables_release_1-7-12 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-11 upgrade_tables_release_1-7-12 In the PMdata folder run the following ant command: ant -f data_build.xml upgrade_pm_tables_release_1-7-10 upgrade_pm_tables_release_1-7-11 upgrade_pm_tables_release_1-7-12 |
1.7.11 | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_table_release_1-7-11 upgrade_table_release_1-7-12 In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_hive_tables_release_1-7-11 upgrade_hive_tables_release_1-7-12 In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12 In the PMdata folder run the following ant command: ant -f data_build.xml upgrade_pm_tables_release_1-7-11 upgrade_pm_tables_release_1-7-12 |
| 1.7.12 | In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_table_release_1-7-12 In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_hive_tables_release_1-7-12 In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12 In the PMdata folder run the following ant command: ant -f data_build.xml upgrade_pm_tables_release_1-7-12 |
Changelog
Database Drivers
The JDBC drivers were updated to the following versions.
Driver | New Version |
ojdbc8.jar | Oracle 12.2.0.1 |
postgresql-42.2.5.jar | PostgreSQL 42.2.5 |
mssql-jdbc-7.0.0.jre8.jar | MS Sql Server 7.0.0 |
Supported Db Server versions
Type | Version |
SQL Server | 2012+ (tested with up to 2019) |
Oracle | 12g+ and 21c |
Postgres | 9 to 14 |
Supported software versions
Application | Version |
Java | 8 or 11 |
Wildfly | 17.0.0 |
Apache HTD | 2.4.17 or higher |
Apache Ant | 1.9.6 |
Apache Axis2 | 1.7.1 |
PHP | 7.2.27 or higher |
i2b2 Database Changes
New db updates include
...
8/21 - If Oracle has different timezone settings than the i2b2 application server, i2b2 sessions used to match the Oracle server. Now they will match i2b2.
- WEBCLIENT 12/9/20 - 63ddf0cedcb6f92f71621b73dcf4c9b9bf45bc5b - Changed response status check from "OK" to 200 for HTTP/2 compatibility
WEBCLIENT-335 5/7/20 - 4bedf1cdfa5e193510ef2bf3e7d7b76cebb40113 - Temporal Query Should Not Need a Constraining Population
WEBCLIENT 8/7/20 - 66313cc2e4bf4a9a09a03bcdfb66587c14061cba, 38ed9ec859e1dcfdbf4c28062a96092d18d53c5a - Obfuscated User Not Showing Graph
- WEBCLIENT-350350 Unable to drag items in workplace
- WEBCLIENT-325
- WEBCLIENT-341 Toggle between <and > group panel buttons resulting in blank QueryResults view
- WEBCLIENT-319 FindTerms- exceeding more than 200(default) return count - displaying server error
- WEBCLIENT-316 Admin tool unresponsive in IE11
- WEBCLIENT-305 Occasionally items in Find Terms by name are not draggable
- WEBCLIENT-304 Hierarchical levels in Find Terms might not work in ontologies that have extra backslashes
- WEBCLIENT-294 Webclient Reports "QUERY CANCELLED" While Query Is Still Running
- WEBCLIENT-291 Date constraints popup OK button disabled, maintains new date if canceled
- WEBCLIENT-196 Temporal query more than 2 events is not populating query name in the query name textbox and displaying new event added msg
- WEBCLIENT-156 switching from events grouppanel view to 'same financial encounter' selection is not switching to original concept group panel view
- CORE-282 Error returned when obfuscated user is locked out
- CORE-281 Query continues to run after user receives lockout message
- CORE-412 (AggService login)
- CORE-405 ??
- CORE-403 ??
CORE-399 use alias for index hint
...
