cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to connect to RServe from Hana Studio

Saritha_K
Contributor
0 Kudos

Hi Experts,

I am trying to connect to RServe from my instance but am getting below error-

Could not execute 'CALL MY_F("RHANA"."PRIME",?)' in 5.500 seconds .

SAP DBTech JDBC: [2048]: column store error: search table error:  [34081] Connection error: Unable to connect with Rserve.;None of the Rserve can be connected:*************:30120: Cannot connect to the host with the port;

Am trying to perform steps mentioned in blog-

to start with.

Below are my system details-

HANA Database 102(SP11)

R server 2.15 configured on a linux host

I have performed all steps as mentioned in the HANA R Integration guide and have below queries-

1. How do I check whether my RServe is running properly on port 30120 or not

2. Do I have to configure any security groups?

Kindly advise.

Regards,

Saritha K

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Saritha,

need to create a new user an run the Rserve instance...

R CMD Rserve --RS-port 6311 --no-save --RS-encoding "utf8"

Also you need to add the port 6311 in the security group.


Can you please check whether all the steps are performed according the below link?

http://scn.sap.com/community/developer-center/hana/blog/2012/05/21/when-sap-hana-met-r--first-kiss#c...

Try to do a Telnet to the IP/Port to see if it's open...

If all you have done, then check for firewall settings.

Regards,

Govind

Saritha_K
Contributor
0 Kudos

Hi,

I did a telnet and its working fine.

Does it have to be port 6311 specifically??

Mine is Linux SLES 11 64 bit. In the link it was mentioned that there was some problem with 64 bit version and 32 bit worked fine. Is it something to be focused upon??

How should we add this port in the security group?

Regards,

Saritha K

Saritha_K
Contributor
0 Kudos

Hi,

My problem got resolved after making entry for the host name at my remote server level.

Regards,

Saritha K