Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Dec 10, 2016 at 07:45 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 11, 2016 at 06:46 AM

    Any pointers would be appreciated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2016 at 11:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 15, 2016 at 03:27 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 19, 2017 at 02:13 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded