Skip to Content
0

Hana Express Edition at Azure Connection Problem

Dec 15, 2016 at 02:19 PM

410

avatar image
Former Member

I created my own instance of SAP HANA Express Edition at Microsoft Azure via using SAP CAL portal. The instance was created successfully. It starts and runs in green, also on Azure Portal everthing looks good as well. However when I am trying to connect to my instance using http://<VM Public ID>:80. It seemed like this resource is not accessible or rejecting http requests.

I also tried to connect to the system using Eclipse, but I faced with the same result. The instance of HANA seemed to be neither accessible nor rejecting my requests.

I checked virtual machine, ports are open.

Is there any step that I miss ? How I can reach ?


Waiting for your help

Regards,

http://<VM Public ID>:80

http://<VM Public ID>:8000

With Eclipse

nx5l4.png (78.5 kB)
aqpqo.png (185.3 kB)
hyvvt.png (122.9 kB)
6s5fc.png (91.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Denys van Kempen
Dec 15, 2016 at 03:53 PM
0

Hi Zafer,

There is nothing listening to port 80, which is why no web page displays. Port 8000 (80 + instance number) shows the HANA XS test page.

Concerning connecting with Eclipse / HANA studio, probably the ports are blocked.

Are you working from a location with a proxy server? You need to configure Eclipse to use the same setting (check Preferences > General > Network

There is a video about how to configure and connect HANA express on CAL that you might find interesting:

https://www.youtube.com/watch?v=TInu4N46IQc&list=PLkzo92owKnVy6nOZMFZIZxcvBCoRdshsR&index=4

Regards,

Denys

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Dec 15, 2016 at 07:14 PM
0

Hi Zafer,

Along with what Denys have said, Eclipse studio tries to connect to sql port at 3<instance number>13. Ex 30013. Please check to see if the ports 30001, 30013, 30014 are open and listening on the host VM (netstat -a | grep 30013 should show if listening). If there is a firewall or ports are blocked, please fix this and retry.

Thanks,

Vidya Mandapudy

,

Hi Zafer,

Along with what Denys have said, Eclipse studio tries to connect to sql port at 3<instance number>13. Ex 30013. Please check to see if the ports 30001, 30013, 30014 are open and listening on the host VM (netstat -a | grep 30013 would show this). If there is a firewall or ports are blocked, please fix this and retry.

Thanks,

Vidya Mandapudy

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Denys adn Vidya,

Unfortunately we dont have any proxy server and I have already watched video.

Also all my open port on my Azure VM;

I have only activated Hana Express on CAL as shown on youtube video. Is it possible that some settings are missing on CAL's image.

Thanks ,

Zafer

acfvq.png (400.4 kB)
0

Hello Zafer,

Could it be that you are behind a corporate firewall that would explain why you could not connect to ports 30001, 30013, 30014.

Best regards,

Stanimir

0
Former Member
Stanimir Eisner

Hello Stanimir,

After that I have tried to connet at home but result is same . Also I could't reach to http://<VM Public ID>:80.

am sure 80 port is open. I willl not try anymore because I coundt find any solution. I will use VM version on Azure.

Thanks,

Zafer,


0
avatar image
Former Member
Dec 15, 2016 at 07:14 PM
0

Hi Zafer,

Along with what Denys have said, Eclipse studio tries to connect to sql port at 3<instance number>13. Ex 30013. Please check to see if the ports 30001, 30013, 30014 are open and listening on the host VM (netstat -a | grep 30013 should show if listening). If there is a firewall or ports are blocked, please fix this and retry.

Thanks,

Vidya Mandapudy

Share
10 |10000 characters needed characters left characters exceeded
Shailendra Shankar Dec 21, 2016 at 04:47 AM
0

Hi Zafer,

Were you able to resolve the issue ? I have the same issue connecting to HANA Express Ed on CAL from SAP HANA Studio. It shows all ports as enabled though ..

Thanks

Shankar

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Shankar,

Unfortunately I couldn't resolve. Just I changed the method, I am using VM machine not CAL version. I just download from SAP than using with Virtual machine.

If you find any solution, please share with use.

Thanks,

Zafer,

0

Hi Shankar,

Did you select the Multiple Containers/System database Mode while you were adding the system to the SAP HANA Studio?

Another hint is to check the system status by executing the commands below:

su - hxeadm

sapcontrol -nr 00 -function GetProcessList

Best regards,
Stanimir

0
Former Member
Stanimir Eisner

Hi Stanimir,  
I have the same problem. Below you can find the output of your proposed commands.  
I also restarted the server, but this did not help neither. At the start of the HANA server, an SAP note 
was mentioned, but reading this note, it should not have an impact:

Impromptu CCC initialization by 'rscpCInit'. See SAP note 1266393.

Thanks in advance for your help Willem
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, GREEN, Running, 2016 12 21 08:22:26, 5:42:11, 3684
hdbcompileserver, HDB Compileserver, GREEN, Running, 2016 12 21 08:23:06, 5:41:31, 4071
hdbdiserver, HDB Deployment Infrastructure Server, GREEN, Running, 2016 12 21 08:23:13, 5:41:24, 4162
hdbnameserver, HDB Nameserver, GREEN, Running, 2016 12 21 08:22:28, 5:42:09, 3706
hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2016 12 21 08:23:06, 5:41:31, 4073
hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2016 12 21 08:23:13, 5:41:24, 4164
hdbxscontroller, HDB XS Controller, GREEN, Running, 2016 12 21 08:23:13, 5:41:24, 4166
hdbxsexecagent, HDB XS Execution Agent, GREEN, Running, 2016 12 21 08:23:13, 5:41:24, 4168
hdbxsuaaserver, HDB XS UAA Server, GREEN, Running, 2016 12 21 08:23:13, 5:41:24, 4170
hxeadm@sid-hxe:/usr/sap/HXE/HDB00> HDB start

StartService
Impromptu CCC initialization by 'rscpCInit'.
See SAP note 1266393.
OK
OK
Starting instance using: /usr/sap/HXE/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 00 -function StartWait 2700 2
21.12.2016 14:15:24
Start
OK
0

Hi Willem,

The next hint will be to check whether port 30013 and 50013 are open. See the expected result from the command below

sid-hxe:~ # netstat -a | grep 0013

tcp 0 0 *:30013 *:* LISTEN

tcp 0 0 *:50013 *:* LISTEN

If the two ports are open next check if you can open a connection from the OS where you run the HANA Studio:

telnet <IP address> 30013

telnet <IP address> 50013

If you can connect with telnet then double check that you choose the right options in the HANA Studio

Best regards,

Stanimir

capture.png (22.0 kB)
0
avatar image
Former Member Dec 23, 2016 at 03:39 PM
0

Hi Stanimir, thanks, now it works and HANA Studio can connect.

It is a pity that the port is not configured in CAL - Hana Express Template for Azure. This would have avoided a lot of time.

Kind Regards

Willem

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Willem,

Thanks for bringing our attention on the solution configuration for Azure. Indeed port 30013 was not configured by default. Now this is fixed.

Best regards,

Stanimir

0