Can you make a public study private without reloading

[rlr...@umich.edu]

Hi-

We have some studies that have a large amount of data and take a long time to load.  There was an issue and one of our studies was loaded as public rather than private, and we were hoping someone could help us figure out how to make the study private without deleting and reloading the data (since this is a very time-consuming operation).

Any advice would be greatly appreciated!  Any scripts that do this would be even better!

Thanks!

Becky Reamy

[Dirk]

Hi,

In my case I just needed to update the column secure_obj_token within the i2b2metadata.i2b2_secure table. If the Security_REQUIRED Parameter is not set to "Y" that column will get the value "EXP:PUBLIC". Updating it to "EXP:Studyname" did do the trick for me. With regards to the performance, I noticed that we save a lot of time not using docker container, running the DB and the GUI on seperate hosts, merging the column-files prior to the data-import (if there are more than one) and removing existing studies from the DB directly, before re-importing those using PDI/Kettle.

Kind regards,

Joe

--
For more ways to get in contact with the tranSMART community visit https://wiki.transmartfoundation.org/display/transmartwiki/Getting+Support
---
You received this message because you are subscribed to the Google Groups "transmart-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to transmart-disc...@googlegroups.com.
To post to this group, send email to transmar...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/transmart-discuss/d3e612bc-fb83-4ba1-a738-b03c8f9e924f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.