I2b2 Migration fixing
- Dominant language
- Shell
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
When updating a DWH from earlier versions, i get an AJAX error and cannot create queries on _/webclient_.
**Reason**
I2b2 database changes its structure between versions but changes are not migrated. Therefore some columns are missing when updating to newer DWH versions.
# Requirements
Add more fixes to the sql update scripts inside _src/resources/sql_
## 1 i2b2hive.hive_cell_params
Missing complete table with data
## 2 i2b2crcdata.qt_query_result_type
Missing column _user_role_cd_
## 3 i2b2metadata.table_access
Missing column _c\_ontology_protection_
This specific case and fixes are from DWH version 1.5rc1 and 1.7.1.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.