App fails when routed to production backend files instead of dev files

[jaybee84]

Describe the bug The app was found to be routing to dev RDS files. These files are not regularly updated and are for testing only. When the app was routed back to the production backend RDS files which are updated regularly, the staging app fails to show content.

From the logs it seems to be looking for a StudyId column that does not exist in the production RDS files.

To Reproduce Steps to reproduce the behavior:

1. Go to 'https://sagebio.shinyapps.io/projectLive_NF-staging/'
2. Select NTAP from dropdown list
3. Click on 'Participating Studies'
4. See error

Expected behavior I should be able to see a list of all studies and plots associated with a study when the study is selected.

Additional context Shiny Apps logs show the following:

2022-05-09T23:10:15.349654+00:00 shinyapps[5349080]: The following object is masked from ‘package:magrittr’:
2022-05-09T23:10:15.349702+00:00 shinyapps[5349080]: 
2022-05-09T23:10:15.349750+00:00 shinyapps[5349080]:     set_names
2022-05-09T23:10:15.349817+00:00 shinyapps[5349080]: 
2022-05-09T23:10:22.348174+00:00 shinyapps[5349080]: ℹ Loading projectLive
2022-05-09T23:10:23.348006+00:00 shinyapps[5349080]: 
2022-05-09T23:10:23.348103+00:00 shinyapps[5349080]: Listening on http://127.0.0.1:36213
2022-05-09T23:10:54.373178+00:00 shinyapps[5349080]: This Font Awesome icon ('bar-chart-o') does not exist:
2022-05-09T23:10:54.373256+00:00 shinyapps[5349080]: * if providing a custom `html_dependency` these `name` checks can 
2022-05-09T23:10:54.373313+00:00 shinyapps[5349080]:   be deactivated with `verify_fa = FALSE`
2022-05-09T23:10:54.373359+00:00 shinyapps[5349080]: This Font Awesome icon ('bar-chart-o') does not exist:
2022-05-09T23:10:54.373420+00:00 shinyapps[5349080]: * if providing a custom `html_dependency` these `name` checks can 
2022-05-09T23:10:54.373480+00:00 shinyapps[5349080]:   be deactivated with `verify_fa = FALSE`
2022-05-09T23:10:57.348058+00:00 shinyapps[5349080]: 
2022-05-09T23:10:57.347978+00:00 shinyapps[5349080]: Welcome, jaya bee!
2022-05-09T23:11:03.348007+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:03.348086+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:03.348149+00:00 shinyapps[5349080]:   156: <Anonymous>
2022-05-09T23:11:03.348212+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:03.348270+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:03.348324+00:00 shinyapps[5349080]:   163: <Anonymous>
2022-05-09T23:11:03.348430+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:03.348380+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:03.348481+00:00 shinyapps[5349080]:   208: <Anonymous>
2022-05-09T23:11:03.348531+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:03.348585+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:03.348634+00:00 shinyapps[5349080]:   120: <Anonymous>
2022-05-09T23:11:03.348683+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:03.348734+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:03.348783+00:00 shinyapps[5349080]:   170: <Anonymous>
2022-05-09T23:11:04.352576+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:04.352644+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:04.352704+00:00 shinyapps[5349080]:   147: <Anonymous>
2022-05-09T23:11:04.352767+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:04.352819+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:04.352872+00:00 shinyapps[5349080]:   170: <Anonymous>
2022-05-09T23:11:04.352921+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:04.352973+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:04.353022+00:00 shinyapps[5349080]:   170: <Anonymous>
2022-05-09T23:11:04.353131+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:04.353180+00:00 shinyapps[5349080]:   216: <Anonymous>
2022-05-09T23:11:04.353075+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:04.353228+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:04.353277+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:04.353325+00:00 shinyapps[5349080]:   193: <Anonymous>
2022-05-09T23:11:04.353469+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:04.353380+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:04.353544+00:00 shinyapps[5349080]:   145: <Anonymous>
2022-05-09T23:11:04.353605+00:00 shinyapps[5349080]: Warning: Error in dplyr::select: Can't subset columns that don't exist.
2022-05-09T23:11:04.353663+00:00 shinyapps[5349080]: ✖ Column `studyId` doesn't exist.
2022-05-09T23:11:04.353714+00:00 shinyapps[5349080]:   189: <Anonymous>

[andrewelamb]

@jaybee84 It looks like the production files never got updated. Essentially the production files (live files) here need to be set to be the same as the development (dev) files.

[jaybee84]

@andrewelamb the production files are being updated regularly: https://www.synapse.org/#!Synapse:syn22281727 using the scheduled jobs

[andrewelamb]

Yep, but the 'schema' changed for a couple of the RDS files. Mostly they need some new columns, that are getting added in the dev versions.

[andrewelamb]

fixed by this PR.