New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Unable to load data stored with pins on rstudio connect #622
Comments
|
Hello everyone, I tried to load data with pins using the previous versions ie 1.0.0 and 0.4.5 but it failed too. Is that functionality (read data from Rconnect on RSW) still supported? |
|
Hey -- this particular error seems to be a yaml parsing error. Could you try deleting the cache and then reading the pin? You can remove this folder or run edit: something else surprising about that file is it has a line at least 20955 characters long? any idea what that could be? |
|
Hello @machow, Thanks for your reply. I started with the removing of the folder rsc-e62371cfd77db754024f9c5ed3556a73/ There is no file to get here. So I used the following command to pushish a dataset on rconnect: But when I tried to read it, I got the same message: I also tried to delete all caches and relaunch the pin_read() command but without success: About the data.txt file, it is a long one. I can't get the top of it from the R terminal but this is an HTML file: |
|
Is that HTML file you posted a picture of the contents of data.txt? |
|
Yes, absolutely. |
|
An update about this topic: I tried to bypass the pin_read function. I used the function read.csv with the URL to the dataset pins on rconnect instead of the pin_read function. Sadly, it didn't work. I also used download.files() function to get the dataset on my working environment on RSW but I got an HTML instead. The HTML is associated with the authentification to the active directory of the company. (login/password etc...). The file is the same that data.txt in the cache. What I didn't understand for the moment, is how can I write pins on rsconnect without problem (board_rsconnect function perfectly) but when I try to read the file on the same rstudio connect, I get that HTML login file. |
|
Hey -- can do these steps, so we can see more of what's going on?:
Here's the code for using library(httr)
board <- ... # create board_rsconnect here
with_verbose(pin_read(board, "mtcars3"))It should print a "Status" out, which will help identify what's going on! (highlighted in example below) (h/t @colearendt for feedback, and @sellorm who has this |
|
Hello @machow, Thanks for your reply. This is the output of the previous command. I just hid the server URL and the name. Hope this helps you :) |
|
Thanks--it looks like it is trying to do a redirect to login.microsoftonline.com, but I'm not sure why :/. What happens if you open RSC in the browser, and then paste the URL for retrieving For example, here's what I get when I do something similar with an internal testing server: |
|
@yacaslimi - in addition to what @machow suggests could you also check if you have a WAF (Web Application Firewall) in front of you connect server. I have seen a small number of cases where a misconfigured WAF caused problems with some, but not all, requests to Connect. If you do, turn it off and try again. If that works, you'd need to play around with the WAF config to allow these requests. |
|
I've checked with the IT service. There is effectively a WAF in front of rconnect. According to them, it is not possible to module the waf to allow a specific type of request as those indue by the pin_read() function. I'll continue to investigate from my side and will keep you informed of further development. |
|
Thanks for the update @yacaslimi. In cases where I've seen this before the IT team has been able to temporarily disable the WAF to confirm the issue and then reenable it with new or edited WAF rules to allow the appropriate API request(s), which has fixed the issue. I hope you manage to get this resolved and please let us know if we can be of further assistance. |









Hello,
I'm currently working with the package pins. I am an RSW user with the following configuration:
R version 4.1.3 (2022-03-10)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Ubuntu 18.04.6 LTS
Matrix products: default
BLAS: /usr/lib/x86_64-linux-gnu/openblas/libblas.so.3
LAPACK: /usr/lib/x86_64-linux-gnu/libopenblasp-r0.2.20.so
locale:
[1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C LC_TIME=en_US.UTF-8
[4] LC_COLLATE=en_US.UTF-8 LC_MONETARY=en_US.UTF-8 LC_MESSAGES=en_US.UTF-8
[7] LC_PAPER=en_US.UTF-8 LC_NAME=C LC_ADDRESS=C
[10] LC_TELEPHONE=C LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C
attached are base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] pins_1.0.1 yaml_2.3.5
loaded via a namespace (and not attached):
[1] fansi_1.0.3 digest_0.6.29 utf8_1.2.2 crayon_1.5.1 rappdirs_0.3.3 R6_2.5.1
[7] jsonlite_1.8.0 lifecycle_1.0.1 magrittr_2.0.3 httr_1.4.3 pillar_1.7.0 rlang_1.0.2
[13] cli_3.3.0 curl_4.3.2 rstudioapi_0.13 fs_1.5.2 vctrs_0.4.1 ellipsis_0.3.2
[19] tools_4.1.3 glue_1.6.2 rsconnect_0.8.26 compiler_4.1.3 askpass_1.1 pkgconfig_2.0.3
[25] openssl_2.0.2 tibble_3.1.7
I managed to push datasets on R Studio connect with pins.

Now I'd like to use one of that datasets on RSW. I am able to connect on RsStudio connect with the command:
However, when I tried to load one of the datasets by using:
It doesn't load the data. Instead, there is the following message:
By searching similar issues, someone has achieved to load it by deleting the data.txt file but it failed for me. #463
Do you know where the error came from?
The text was updated successfully, but these errors were encountered: