HANA Express Edition only VM, not able to reach from local host

[Former Member]

Hi,

I have hxe.ova imported, up and running in vmware player locally, with the network set to bridged and IP properly obtained. I have also turned off the firewall at SuSE level just to ensure smooth development, for starters.

Now, I am able to reach the IP of the guest VM from the host operating system (Windows 8.1) and vice versa.

However, the eclipse setup is not able to reach the HDB.

HDB info command on the server shows all servers to be up and running.

Please advise as to how I can get the connection working.

[Former Member]

I have followed this link to get the basic setup.

http://www.sap.com/developer/tutorials/hxe-ua-getting-started-vm.html

[pfefferf]

Are you using the HXE version with HANA 1.0 SPS12 or HANA 2.0 SPS00?

[Former Member]

Being a complete noob in this, I would request you to provide the steps as to how I can check this.

[pfefferf]

When you have started HANA in the VM and logged on with hxeadm (as described in the guide you probably downloaded) entere command "HDB version". Seen you see the version information.

[Former Member]

Thanks for the input.

HDB version reads

version: 1.00.122.01.1470046197

branch: fa/hana1sp12

Please advise further.

[pfefferf]

Ok, you are using HANA 1.0 SPS12. The documentation you linked is for 2.0.

What instance number you are using in Eclipse to connect?

[Former Member]

HDB info indicates HDB00, which I think means instance 00?

[pfefferf]

Ok, that is the right one. If you are connecting to the SystemDB then it should work if you are in the same network.

[Former Member]

Thank you for all your inputs.

The issue was resolved by creating Secure user store using hdbuserstore utility available in the client installation.

[dvankempen]

Hi,

Just downloaded the HXE vm (hxe.ova). Imported into VMware. Changed the passwords as instructed and queried the IP using /sbin/ipconfig.

Also downloaded Eclipse Neon from eclipse.org, installed studio from tools.hana.ondemand.com/neon.

Added the system database using the IP and instance number 90.

Proceeded to add the tenant database HXE, received an error.

SQL> select * from m_databases

Output informed me that HXE was not started.

SQL> alter system start database HXE;

Proceeded adding tenant HXE to studio.

[dvankempen]

Hi Satish,

FYI: there is a full playlist on the HANA Academy about the express edition, which covers most of the issues you might encounter.

https://www.youtube.com/playlist?list=PLkzo92owKnVy6nOZMFZIZxcvBCoRdshsR

If you cannot connect with Eclipse running on your host to express running on the guest (VM), it could be that a firewall is blocking the port access. Are you using a Windows PC with the Firewall on by any chance? Try stopping the Firewall service and see if you can connect. If so, you have to configure the Firewall to allow for port traffic from VMware.

[Former Member]

I have faced same issue, but tried as you said . perhaps no luck.

Any more suggestuons ?

[Former Member]

Hi Satish,

From the HDB information you have provided, it looks like you are using HANA 1.0 SPS12.

Were you able to successfully execute HDB sql?

hdbsql -i 00 -d SystemDB -u SYSTEM -p HXEHana1

Were you using the same instance number 00 to connect using eclipse or 90? Please make sure to use 00 as described in the documentation for SPS12. Revert back incase of any further issues.

Thanks,

Vidya Mandapudy

[Former Member]

Any pointers would be appreciated.

[Former Member]

Hello,

My local host has IP 192.168.1.102 and guest VM is running at 192.168.1.103.

I have followed the steps listed in that link till setting up of /etc/hosts files at both guest and host operating systems and ping works fine.

I have also installed a 64 bit SAP HANA client locally (since my OS is 64 bit). The ODBC administrator window lists the HDBODBC and allows configuration till the connect part. The exception on connect from HDB ODBC is

"SQLSTATE: 08S01

NATIVE ERROR: -10709

MESSAGE TEXT: [SAP AG][LIBODBCHDB.DLL][HDBODBC]

Communication link failure;-10709 Connected failed (RTE:[89006]

System call 'connect failed, rc=10061:No connection could be made because the target machine actively refused it (hxehost.localdomain.com:30015))"

The error I am getting from Eclipse is "The system could not be reached. The logon data could not be used."

Based on above messages, I have turned off the firewall at both machines. Thus, at least the ping works both ways.

Any pointers?