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">
<setting name="rserveHost" serializeAs="String">
<setting name="rservePort" serializeAs="String">
<setting name="grpcHost" serializeAs="String">
<value>localhost</value> <!-- Set to 0.0.0.0 if you want it reachable from the outside world -->
If you encounter errors related to connection is failing for 6311 and 50051 then those ports need to be opened and listening.
PS C:\Windows\system32\WindowsPowerShell\v1.0> Test-NetConnection your-R-server -port 6311
WARNING: TCP connect to your-R-server :6311 failed
PS C:\Windows\system32\WindowsPowerShell\v1.0> Test-NetConnection your-R-server -port 50051
WARNING: TCP connect to your-R-server :50051 failed
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.