SAP HANA Streaming Analytics on SAP HANA Express

[Former Member]

Hello,

I have downloaded SAP HANA Express and installed SAP HANA Streaming Analytics using this tutorial:
https://www.sap.com/developer/tutorials/hxe-ua-installing-streaming.html

The installation succeeded.

After that, I have installed the Streaming Studio Plugin with the help of this tutorial:

https://www.sap.com/developer/tutorials/hxe-ua-streaming-plugin.html

The installation also succeeded, but I can't connect to the Streaming Server. 2017-11-23-14-42-24-connect-server.png

I only the the error message attached, no further details provided. I also searched on the server for error logs, but could not find anything.

It would be very greatful, if anybody could help me with this problem.

Thank you very much

Andreas

[RobertWaywell · Accepted solution]

The 2 most likely causes of that particular connection error are either:

1) When setting up the server connection from the Streaming Run-Test perspective you forgot to check the Use SSL checkbox

or

2) The streaming server actually isn't running.

You would get different errors if the IP address/host name was wrong or if you had a typo in the Username or Password.

To check if the streaming server is running, you can go to the SAP HANA Administration Console and double click on the HANA tenant to open the System Overview screen. On the Overview tab you will be able to see if Streaming is both installed and whether or not it is running.

If the Streaming server isn't running then you will need to start it. If it isn't installed then the error will have happened earlier in the process.

If the Streaming server is running then you're most likely issue is that the server connection in the Run-Test perspective was created without checking the "Use SSL" checkbox. In that case you will need to remove the connection and recreate it.

[Gunter]

I had the same issue on my HXE server. I found out that on port 3<instance number>26 connections got rejected by server on TCP negotiation level already. Therefore I assumed the service is not provided on that port.

I recommend to look into the "Diagnosis Files" in Eclipse for the streaming server as it reveals the real ports in use:

...
Aug 16 2018 10:58:46.861 INFO - CODE_700061 | Web server starting
Aug 16 2018 10:58:46.863 INFO - jetty-9.2.17.v20160517
Aug 16 2018 10:58:46.926 INFO - Started o.e.j.s.ServletContextHandler@59429fac{/,null,AVAILABLE}
Aug 16 2018 10:58:46.947 INFO - Started ServerConnector@326c09f7{SSL-HTTP/1.1}{0.0.0.0:39055}
Aug 16 2018 10:58:46.947 INFO - Started @7096ms
Aug 16 2018 10:58:46.964 INFO - jetty-9.2.17.v20160517
Aug 16 2018 10:58:47.005 INFO - Started o.e.j.s.ServletContextHandler@7fc645e4{/,null,AVAILABLE}
Aug 16 2018 10:58:47.009 INFO - Started ServerConnector@6f642354{SSL-HTTP/1.1}{0.0.0.0:39050}
Aug 16 2018 10:58:47.014 INFO - Started ServerConnector@205b132e{SSL-HTTP/1.1}{0.0.0.0:39049}
Aug 16 2018 10:58:47.014 INFO - Started @7163ms
Aug 16 2018 10:58:47.014 INFO - CODE_700062 | Web server started
...

I was able to connect with port 3<instance number>50. ..49 will also work. Not sure which one is the internal and which one is the external. I picked the higher one. Maybe an expert can shed some light into that.

[RobertWaywell]

I thought we had update the tutorial already, but apparently not. The change in ports is due to the change in HANA Express from using a single container install prior to HANA 2.0 SPS 03 to now using a multi-container/multi-tenant install with the HANA 2.0 SPS03 version. The ports used in multi-tenant systems are documented here in the Help:

https://help.sap.com/viewer/e8755363bc104c3abb7bf073e67f1053/2.0.03/en-US/5f83ad40f7314dfa8085655566...

I will make sure we get the tutorial updated to reflect the current version of HXE.

[Former Member]

Hello Robert,

thank you very much for your detailed answer.

I checked both things:

1) SSL is activated for the connection

2) The Streaming Server is running. But as you can see on my screenshot, the server has another description.

Do you have another idea, how I could solve this problem?
Thank you very much?

[RobertWaywell]

One thing to double check is the IP address. A valid IP address that maps to a different machine would probably give you the Failed to Login Server error. In contrast an invalid IP address that didn't map to any machine on the network would give an error like "The host <my.bad.address> cannot be contacted on the network. Similarly an incorrect User ID or Password should give you an "Authentication failure: Invalid login credentials" error.

A smaller change to try - but that likely won't have an impact - is to specify port 39026. Port 3XX16 is actually intended for internal server communications and I need to get that fixed in the tutorial. Port 3XX26 is the port intended for external connections including the connection from Studio. Again, you should be able to get away with using the internal 3XX16 port but as a debug step it wouldn't hurt to change to 3XX26.

You can also try restarting the HANA server using HDB stop/HDB start. That can clean up any issues that might be caused by pausing and resuming the VM. The Processes list that you showed does indicate that the hdbstreamingserver process is running, so this would again be a debug step.

One other thing that looks a bit unusual is that the hdbstreamingserver process is showing as a process on the SYSTEMDB instead of on the HXE tenant. It should be provisioned to the tenant. Can you check the Landscape tab of the System Overview screen for the HXE tenant database?