"Disconnected from Server" Error Message when publishing R Shiny app

Posit Professional & Hosted Products shinyapps.io
1

This is my first time trying to publish an R Shiny app to the web, and could use some help! I am attempting to publish a quiz I coded in R that has Jeopardy questions and answers from the last 35 seasons. It works locally, but when I attempt to publish it to the web I get the "Disconnected from Server" message.

- Cite any error or warning messages, and where you receive them. 
"Disconnected from server" message when attempting to access the quiz online.
- Cite your application logs. 
"2020-06-11T15:34:10.880716+00:00 shinyapps[2442047]: R version: 3.6.1
2020-06-11T15:34:10.880717+00:00 shinyapps[2442047]: shiny version: 1.4.0.2
2020-06-11T15:34:10.880717+00:00 shinyapps[2442047]: httpuv version: 1.5.2
2020-06-11T15:34:10.880672+00:00 shinyapps[2442047]: Server version: 1.8.2.1-12
2020-06-11T15:34:10.880727+00:00 shinyapps[2442047]: rmarkdown version: (none)
2020-06-11T15:34:10.880740+00:00 shinyapps[2442047]: RJSONIO version: (none)
2020-06-11T15:34:10.880728+00:00 shinyapps[2442047]: knitr version: (none)
2020-06-11T15:34:10.880766+00:00 shinyapps[2442047]: htmltools version: 0.4.0
2020-06-11T15:34:10.880739+00:00 shinyapps[2442047]: jsonlite version: 1.6.1
2020-06-11T15:34:11.865760+00:00 shinyapps[2442047]: warning: using reticulate but python was not specified; will use python at /usr/bin/python3 
2020-06-11T15:34:11.865881+00:00 shinyapps[2442047]: Using pandoc: /opt/connect/ext/pandoc2
2020-06-11T15:34:11.930918+00:00 shinyapps[2442047]: Using jsonlite for JSON processing
2020-06-11T15:34:11.937278+00:00 shinyapps[2442047]: 
2020-06-11T15:34:11.937280+00:00 shinyapps[2442047]: Starting R with process ID: '183'
2020-06-11T15:34:11.991452+00:00 shinyapps[2442047]: 
2020-06-11T15:34:11.991453+00:00 shinyapps[2442047]: Listening on http://127.0.0.1:42039
2020-06-11T15:34:11.865780+00:00 shinyapps[2442047]: Did you forget to set the RETICULATE_PYTHON environment variable in your .Rprofile before publishing?
2020-06-11T15:34:12.873133+00:00 shinyapps[2442047]: Warning in file(file, "rt") :
2020-06-11T15:34:12.873135+00:00 shinyapps[2442047]:   cannot open file 'C:/Users/taylo/OneDrive/Documents/jeop3column.csv': No such file or directory
2020-06-11T15:34:12.873862+00:00 shinyapps[2442047]: Warning: Error in file: cannot open the connection
2020-06-11T15:34:12.883501+00:00 shinyapps[2442047]:   64: file
2020-06-11T15:34:12.883502+00:00 shinyapps[2442047]:   63: read.table
2020-06-11T15:34:12.883503+00:00 shinyapps[2442047]:   62: read.csv
2020-06-11T15:34:12.883663+00:00 shinyapps[2442047]: Error in file(file, "rt") : cannot open the connection
2020-06-11T15:34:12.883503+00:00 shinyapps[2442047]:   61: server [/srv/connect/apps/JeopardyQuiz/app.R#49]
2020-06-11T15:35:15.977219+00:00 shinyapps[2442047]: Server version: 1.8.2.1-12
2020-06-11T15:35:15.977221+00:00 shinyapps[2442047]: LANG: en_US.UTF-8
2020-06-11T15:35:15.977283+00:00 shinyapps[2442047]: R version: 3.6.1
2020-06-11T15:35:15.977284+00:00 shinyapps[2442047]: shiny version: 1.4.0.2
2020-06-11T15:35:15.977285+00:00 shinyapps[2442047]: httpuv version: 1.5.2
2020-06-11T15:35:15.977285+00:00 shinyapps[2442047]: rmarkdown version: (none)
2020-06-11T15:35:15.977285+00:00 shinyapps[2442047]: knitr version: (none)
2020-06-11T15:35:15.977299+00:00 shinyapps[2442047]: jsonlite version: 1.6.1
2020-06-11T15:35:15.977300+00:00 shinyapps[2442047]: htmltools version: 0.4.0
2020-06-11T15:35:15.977299+00:00 shinyapps[2442047]: RJSONIO version: (none)
2020-06-11T15:35:16.944337+00:00 shinyapps[2442047]: warning: using reticulate but python was not specified; will use python at /usr/bin/python3 
2020-06-11T15:35:16.944344+00:00 shinyapps[2442047]: Did you forget to set the RETICULATE_PYTHON environment variable in your .Rprofile before publishing?
2020-06-11T15:35:16.944449+00:00 shinyapps[2442047]: Using pandoc: /opt/connect/ext/pandoc2
2020-06-11T15:35:17.009035+00:00 shinyapps[2442047]: Using jsonlite for JSON processing
2020-06-11T15:35:17.015417+00:00 shinyapps[2442047]: 
2020-06-11T15:35:17.015418+00:00 shinyapps[2442047]: Starting R with process ID: '233'
2020-06-11T15:35:17.067549+00:00 shinyapps[2442047]: 
2020-06-11T15:35:17.067551+00:00 shinyapps[2442047]: Listening on http://127.0.0.1:45809
2020-06-11T15:35:18.111709+00:00 shinyapps[2442047]: Warning in file(file, "rt") :
2020-06-11T15:35:18.111712+00:00 shinyapps[2442047]:   cannot open file 'C:/Users/taylo/OneDrive/Documents/jeop3column.csv': No such file or directory
2020-06-11T15:35:18.112452+00:00 shinyapps[2442047]: Warning: Error in file: cannot open the connection
2020-06-11T15:35:18.121975+00:00 shinyapps[2442047]:   64: file
2020-06-11T15:35:18.121976+00:00 shinyapps[2442047]:   63: read.table
2020-06-11T15:35:18.121977+00:00 shinyapps[2442047]:   62: read.csv
2020-06-11T15:35:18.121978+00:00 shinyapps[2442047]:   61: server [/srv/connect/apps/JeopardyQuiz/app.R#49]
2020-06-11T15:35:18.122134+00:00 shinyapps[2442047]: Error in file(file, "rt") : cannot open the connection"
- Cite output of "rsconnect::appDependencies()"
Not sure WHERE to do this
- Provide your shiny app's application URL/id.
https://taylorjsimpson.shinyapps.io/JeopardyQuiz/?_ga=2.193292389.932765019.1591889094-926734937.1590084764

I would appreciate any help. I've been working on this app for a while and would be great to finally get it published!

-Taylor

6

Do not use absolute paths, use relative paths instead. Once the app is deployed to the server it no longer has access to your local files.

2 Likes
7

I meant to share the following yesterday, but mistakenly posted it somewhere else

I believe this suggests there is a line in your shiny app where you refer directly to the path to your csv file on your local machine. But this won't work once your app is deployed off your local machine.

If that is the issue, there are several options to deal with it, one easy way is to move all data your shiny app needs into a /data folder, that's a subdirectory of your shiny-app directory, and deploy that with your shinyapp.
In your code where your app loads this data, refer to the relative location, probably something like /data/jeop3column.csv.

Some discussion here

8

Working on this now, thanks!

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.