aktin / aktin/debian-dwh-pkg

I2b2 Migration fixing

Open
#16 0 comments 0 reactions 0 assignees View on GitHub
bug
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.