UI Step |
---|
Upgrade Database
Run the following upgrade scripts on your i2b2 database instance, where {db} can be Oracle, sqlserver or postgresql In data folder | 1.7.09c | PmData/scripts/upgrade_{db}_i2b2pm_tables.sql Crcdata/scripts/crc_create_query_{db}.sql Hivedata/scripts/upgrade_{db}_i2b2hive_tables.sql | 1.7.10 | Metadata/scripts/ont_{db}.sql Crcdata/scripts/crc_create_query_{db}.sql Hivedata/scripts/upgrade_{db}_i2b2hive_tables.sql | 1.7.11 | Crcdata/scripts/crc_create_query_{db}.sql Hivedata/scripts/upgrade_{db}_i2b2hive_tables.sql | Run the ant scripts for Metadata and Crcdata UI Step |
---|
Stop WildFly Code Block |
---|
language | powershell |
---|
title | Linux Example |
---|
collapse | true |
---|
| $ /opt/wildfly-{version}.Final/bin/jboss-cli.sh --connect command=:shutdown |
|
UI Step |
---|
Backup your existing i2b2.war directory UI Expand |
---|
| On Linux, move the /opt/wildfly-{version}.Final/standalone/deployments/ and save it to a different location outside of /opt/wildfly-{version}.Final/
|
UI Expand |
---|
| On Windows, move the c:\opt\wildfly-{version}.Final\standalone\deployments\ and save it to a different location outside of c:\opt\wildfly-{version}.Final\
|
|
UI Step |
---|
Extract the download file i2b2core-war-1712.zip to a folder outside of wildfly folder.
|
UI Step |
---|
Copy all the files from the download war file deployment into your existing WildFly standalone directory. |
UI Step |
---|
Upgrade Database
Run the following upgrade scripts on your i2b2 database instance, where {db} can be Oracle, sqlserver or postgresql In data folder | 1.7.09c | PmData/scripts/upgrade_{db}_i2b2pm_tables.sql Crcdata/scripts/crc_create_query_{db}.sql Hivedata/scripts/upgrade_{db}_i2b2hive_tables.sql | 1.7.10 | Metadata/scripts/ont_{db}.sql Crcdata/scripts/crc_create_query_{db}.sql Hivedata/scripts/upgrade_{db}_i2b2hive_tables.sql | 1.7.11 | Crcdata/scripts/crc_create_query_{db}.sql Hivedata/scripts/upgrade_{db}_i2b2hive_tables.sql |
Run the ant scripts for Metadata and Crcdata |
UI Step |
---|
Update the datasource (*-ds.xml) files in your deployment directory Copy *-ds.xml files from the backup folder to wildfly-1#.0.1.Final/standalone/deployments
Edit the following files crc-ds.xml, ont-ds.xml, pm-ds.xml, work-ds.xml and replace ALL the <driver>{something}.jar</driver> with Oracle | SQL Server | PostgreSQL | <driver>ojdbc8.jar</driver> | <driver>mssql-jdbc-7.4.1.jre8.jar</driver> | <driver>postgresql42.2.8.jar</driver> |
|
UI Step |
---|
Backup your existing i2b2_config_data.js from your web server
On your webclient backup your existing i2b2_config_data.js to a folder outside of your web server. UI Expand |
---|
| On Linux, move the folder /var/www/html/webclient/ and save it to a different location outside of /var/wwww/html/webclient
|
UI Expand |
---|
| On Windows, move the folder c:\inetpub\webclient and save it to a different location outside of c:\inetpub\webclient
|
|
UI Step |
---|
Install the new webclient on your web server
UI Expand |
---|
| On Linux, extract the i2b2webclient-1712.zip to the folder /var/www/html/webclient/ and copy the backup i2b2_config_data.js to /var/wwww/html/webclient
|
UI Expand |
---|
| On Windows, extract the i2b2webclient-1712.zip c:\inetpub\webclient and copy the backup i2b2_config_data.js to c:\inetpub\webclient
|
|
UI Step |
---|
Run the database upgrade scripts based on the database vendor you are using. Run the .sql scripts on your database using preferred client. Within each file contains all the upgrade scripts from 1.7.09c to 1.7.12, run the required scripts for the version you are currently on.
Run the scripts to re created your stored procedures for the CRC Cell. Modify the db.properties file to reflect your database information. Than run the following ant -f crcdata/data_build.xml create_procedures_release_1-7 Run the scripts to created your stored procedures for the Ontology Cell total number Modify the db.properties file to reflect your database information. Than run the following ant -f metadata/data_build.xml create_procedures_release_1-7 UI Step |
---|
Start WildFly Code Block |
---|
language | powershell |
---|
title | Linux Example |
---|
collapse | true |
---|
| $ /opt/wildfly-{version}.Final/bin/standalone.sh -b 0.0.0.0 & |
|
UI Step |
---|
Verify your upgrade UI Expand |
---|
| 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.) |
|
|