Installing SAP HANA Smart Data Streaming

[klausfreyburger]

Hi, I am following "Installing SAP HANA Smart Data Streaming". While running install_sds.sh I am getting "database 'HXE' is unavailable SQLSTATE: HY000".

Database ist up and running. Connection in HANA studio works fine.

I suspect it has something to do with tenant. When doing /usr/sap/HXE/HDB90/exe/hdbsql it works with option -n hxehost:39013 or 39041 (ports according to note 2316463).

It is not clear to me how this can be achieved in the parameters of the install_sds.sh

Thanks Klaus

[klausfreyburger]

Hi all,

Thanks for your answers.

> hdbsql -i 90 -d HXE -u SYSTEM -p <password>

Does not work. Same errormessage as from the installer.

However this works: hdbsql -i 90 -n hxehost:39013 -u SYSTEM -p <password>. This connects to SYSTEMDB.

hdbsql -i 90 -n hxehost:39041 -u SYSTEM -p <password>. This connects to Tenant DB.

Screenshot of installer below. And yes: this is repeatable. Thanks Klaus

[Former Member]

Hi Klaus,

When you said:

hdbsql -i 90 -n hxehost:39041 -u SYSTEM -p <password>. This connects to Tenant DB.

Which tenant DB is this? Is it "HXE" tenant DB that came with the installation? Or did you create this DB?

-Tai

[klausfreyburger]

Hi Tai,

I created this (following this: https://github.com/saphanaacademy/Live5/blob/master/create%20tenant%20database.sql )

Currently situation is as follows:

hdbsql -i 90 -n hxehost:39041 -u SYSTEM -p <password> connects to Tenant DB I created (works now and worked before)

hdbsql -i 90 -d MYTENANT -u SYSTEM -p <password> connects to Tenant DB I created (did not work before).

hdbsql -i 90 -d HXE -u SYSTEM -p <password> connects to HXE tenant that came with installation (did not work before).

hdbsql -i 90 -n hxehost:39013 -u SYSTEM -p <password> does not work any more (worked before and connected to HXE tenant)

Anyway: Connection from HANA studio works fine to both (tenant HXE and MYTENANT). Data Streaming works from Eclipse plugin. So I am all set for the moment 🙂

Best regards, Klaus