HANA R integration: "Authentication with Rserve failed"

[former_member584201]

Hi,

following the official SAP HANA R Integration Guide - SAP Help Portal I was able to integrate an R serve without authentication. I now want to Set Up Rserve Authentication - SAP Help Portal. I followed the instructions to the latter.

My Rserv.conf looks as follows:

HANA config for crypted authentication:

Added credentials to my HANA user:

The passwordfile has the plain structure of:

<user> <password>

When I run a test R script in HANA I get the following error message: "Authentication with Rserve failed"

The same happens with plain text password authentication. When I am not using password authentication (authentication disabled) I am getting no error and the script runs fine. I did check telnet on port 6311 for the R server from my local machine. Works fine.

What could be wrong here?

Regards,
Marcus

[dvankempen]

Hi Marcus,

Not sure if this covers your scenario, but have you checked the video tutorials from Philip and blog from Marcus on the topic?

• SAP HANA Academy - R: 09. Getting Started with R Integration [2.0 SPS 02]
• SAP HANA Academy - R Integration - Hands-on TechEd 2017
• SAP HANA and R hands-on: From freestyle to deployment

[former_member584201]

Hi Denys,

thanks for the links. Had a look at the first one. Did it pretty much the same way. I noticed, however, that I cannot even get it to work when using Rserve as an explicit remote source via

-- create a remote source (need to customize server and port values)CREATE REMOTE SOURCE "Rserve" ADAPTER "rserve" CONFIGURATION 'server=0.0.0.0;port=30020';-- assign remote source to userALTER USER RUSER SET PARAMETER RSERVE REMOTE SOURCES = 'Rserve';

Only the very plain setup works. Very weird and I am at a loss. Maybe it is somehow related to how the HANA server and the Rserve host are connected to each other...

[dvankempen]

Could be; sounds like something is blocking the traffic (?)

Note that the material dates from 2017/18 when the feature was introduced. These days the focus is on SAP HANA Cloud which does not support R-integration, so I would not have an answer for you 1-2-3.

[harro_dittmar46]

Hello Denys,

One year has passed, and I wonder if you could elaborate on the comment "These days the focus is on SAP HANA Cloud which does not support R-integration"? I also did not find recent references and I cannot get the load balancing among multiple R Hosts to work. The diagrams in the "SAP R HANA Integration Guide", and 2 blogs by Intel and Prowess suggest that it is possible, but I do not find documentation or use cases online. If the R Integration is not scalable, we will have to find another solution. Can you advise me whether SAP plans to continue R support? That would be much appreciated.

Kind regards,

Harro

[dvankempen]

Hi Harro,

Good question.

Would you mind asking this question to the SAP Community? Copy/paste will do (with maybe a reference to the blog post).

The community is monitored 24/7 by the topic area experts both from SAP, its partners, and customers, which also allows for knowledge sharing. We monitor several tags and try to respond when and where we can.

Thanks for contributing!

https://answers.sap.com