Skip to Content
0

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

Dec 10, 2016 at 06:32 AM

1.2k

avatar image

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.

10 |10000 characters needed characters left characters exceeded

I have followed this link to get the basic setup.

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

0

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

0

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

0

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.

0

Thanks for the input.

HDB version reads

version: 1.00.122.01.1470046197

branch: fa/hana1sp12

Please advise further.

0

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?

0
Show more comments

Thank you for all your inputs.

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

0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Satish Kandi Dec 10, 2016 at 07:45 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Satish Kandi Dec 11, 2016 at 06:46 AM
0

Any pointers would be appreciated.

Share
10 |10000 characters needed characters left characters exceeded
Vidya Mandapudy
Dec 14, 2016 at 11:36 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Denys van Kempen
Dec 15, 2016 at 03:27 PM
0

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.

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

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

Any more suggestuons ?

0
Denys van Kempen
Jun 19, 2017 at 02:13 PM
0

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.


Share
10 |10000 characters needed characters left characters exceeded