nf-osi / nfportalutils

Utilities for NF Portal project and data management
https://nf-osi.github.io/nfportalutils/
MIT License
2 stars 2 forks source link

Util to help with fixing schema issues for broken views #132

Closed anngvu closed 11 months ago

anngvu commented 11 months ago

When a view schema and data are mismatched (most of the time due to max size issues in STRING cols), the view can no longer be queried. The server does surface issues one at at time through the UI, but then these have to be fixed in the UI. We can have an automated job to repair these issues once the util is available to do resolve the issues more programmatically.

Most recent request https://github.com/nf-osi/dcc-site/issues/669. See also internal platform requests (from circa 2019) https://sagebionetworks.jira.com/browse/PLFM-4862 and https://sagebionetworks.jira.com/browse/PLFM-5869 matching this exactly.