Analytic data connections with R - Troubleshooting and settings
Article Number: 000051950 | Last Modified: 2018/09/20
When setting up Qlik Sense communication with R, you may encounter connection issues related to SSEtoRserve.exe.config setup
The communication method from Sense to R is taken care using gRPC. R is not a supported language in gRPC by default.
A possible solution for this is to develop a connector in any of the supported languages of gRPC. Qlik provides an open-source connector developed in C# which in turn access Rserve to be able to run R scripts. Download SSEtoRserve.exe from https://github.com/qlik-oss/sse-r-plugin, the downloadable file can be found here: https://community.qlik.com/community/advanced-analytics-integration
Open the folder \sse-r-plugin-1.0.0-qlik-oss then modify the file SSEtoRserve.exe.config associated with SSEtoRserve.exe with the settings below:
To make sure that Qlik is communicating with R: You may also need to change the grpc host to 0.0.0.0 in the config and also start the Rserve with a "RS-enable-remote".
<setting name="grpcPort" serializeAs="String"> <value>50051</value> </setting> <setting name="rserveHost" serializeAs="String"> <value>127.0.0.1</value> </setting> <setting name="rservePort" serializeAs="String"> <value>6311</value> </setting> <setting name="grpcHost" serializeAs="String"> <value>localhost</value> <!-- Set to 0.0.0.0 if you want it reachable from the outside world --> </setting>
If you encounter errors related to connection is failing for 6311 and 50051 then those ports need to be opened and listening.
You can also try this R IDE tool called R Studio - It is free. Try to connect to R with tools outside of Qlik just to see if the issue is happening when connecting with Qlik product or any product which will then indicate to general connection issue. https://www.rstudio.com/products/RStudio/
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.