search

Clarivate-LSPS / tMDataLoader

new Groovy-based tranSMART ETL
8 stars 19 forks source link

Rnaseq mods #51

Closed Kabenla closed 8 years ago

Kabenla commented 8 years ago

This modification fixes transmart database schema and table permissions issues that are encountered when attempting to load RNASeq data

xuatiknc commented 8 years ago

You need to execute the following queries to solve the problem you found:

alter user tm_dataloader set search_path= "$user", tm_cz, tm_lz, tm_wz, i2b2demodata, i2b2metadata, deapp, public;
grant amapp, biomart, biomart_stage, biomart_user, deapp, fmapp, galaxy, i2b2demodata, i2b2metadata, searchapp, tm_cz, tm_lz, tm_wz to tm_dataloader;

This a part of much larger set of changes that I will eventually commit.