Question Re: Installing SAP HANA Smart Data Streaming in Technology Q&A

Installing SAP HANA Smart Data Streaming

klausfreyburger — Tue, 25 Apr 2017 12:14:07 GMT

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

Re: Installing SAP HANA Smart Data Streaming

Former Member — Tue, 25 Apr 2017 16:15:24 GMT

Can you login to the tenant database with "hdbsql -i <instance> -d <db>"?

Example:

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

Re: Installing SAP HANA Smart Data Streaming

andrzej_kucharczyk — Tue, 25 Apr 2017 17:15:51 GMT

Hello Klaus,

Could you please attach installer trace output? Also, is this issue repeatable i.e. have you try running install again?

Regards,

Andrzej.

Re: Installing SAP HANA Smart Data Streaming

andrzej_kucharczyk — Tue, 25 Apr 2017 17:19:51 GMT

Also Klaus could you show console output from the install script so that we can see at what point it failed?

Thanks again.

Re: Installing SAP HANA Smart Data Streaming

klausfreyburger — Tue, 25 Apr 2017 19:12:15 GMT

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

Re: Installing SAP HANA Smart Data Streaming

Former Member — Tue, 25 Apr 2017 20:57:17 GMT

Can you login to SYSTEMDB and run:

ALTER SYSTEM START DATABASE HXE

then try "install_sds.sh" again?

Re: Installing SAP HANA Smart Data Streaming

klausfreyburger — Wed, 26 Apr 2017 04:40:39 GMT

This solves the first issue. Thanks a lot!

However now I am stuck during the installation process (VMWare 12 GB on an Windows 16GB host). It now hangs about an hour at this step (see screenshot below). System monitoring in HANA studio is not possible (timeout when trying to connect to server) I have to leave now and let this running. I will keep you informed.

Re: Installing SAP HANA Smart Data Streaming

klausfreyburger — Wed, 26 Apr 2017 14:02:11 GMT

Hi all,

just to inform how this story went on.

The answer of Tai Le solved the issue and then installation started. After installing some packages it seemed to hang at step "Installing Streaming Server".

After 2 hours the output of the installer script resumed.

Again it took a while in step "Startimg Streaming Server". Now everything seems to be o.k. At least I could do "8.4 Configure the Streaming Studio Plugin" without any problems.

HDB info shows hdbstremingserver.

Best regards, Klaus

Re: Installing SAP HANA Smart Data Streaming

andrzej_kucharczyk — Wed, 26 Apr 2017 15:12:34 GMT

Hi Klaus,

Did the install finish successfully? Usually when done there is a location of installer trace file printed out. Could you please attach that trace file as well as any other trace files it refers to as well.

Thank you,

Andrzej.

Re: Installing SAP HANA Smart Data Streaming

andrzej_kucharczyk — Wed, 26 Apr 2017 15:19:52 GMT

Also, Klaus did you manually stop HXE tenant database after installing HANA but before installing SDS? Not sure why else it would need to be manually started.

Regards,

Andrzej.

Re: Installing SAP HANA Smart Data Streaming

klausfreyburger — Wed, 26 Apr 2017 15:25:44 GMT

Hi Andrzej,

still working. It is now about an hour at step "Add HXE database streaming --> Initialize streaming service".

> Usually when done there is a location of installer trace file printed out.

Correct. However I can't access this file at the moment (FileZilla is getting timeout). Or should I stop the system and upload the logfile?

Thanks

Klaus

Re: Installing SAP HANA Smart Data Streaming

andrzej_kucharczyk — Wed, 26 Apr 2017 15:31:53 GMT

Let it finish please.

Re: Installing SAP HANA Smart Data Streaming

klausfreyburger — Wed, 26 Apr 2017 15:34:41 GMT

No. Tenant database was running. Access in HANA Studio was possible. Also access via hdbsql with option -n hxehost:39013 was possible.

And to be honest: I did not really understand what this really did "Can you login to SYSTEMDB and run: ALTER SYSTEM START DATABASE HXE".

Regards, Klaus

Re: Installing SAP HANA Smart Data Streaming

andrzej_kucharczyk — Wed, 26 Apr 2017 15:43:31 GMT

I am confused as well exactly what step allowed SDS install to proceed. If tenant database HXE was already running then the SQL to start it doesn't do anything. My guess is that your VM is so slow that tenant database wasn't fully started yet when you tried running SDS installer for the first time. Then the 2nd time it was ready. I haven't seen that before thou.

Re: Installing SAP HANA Smart Data Streaming

Former Member — Wed, 26 Apr 2017 15:46:40 GMT

Can you check/post the log files /var/tmp/sdsinst.log and /var/tmp/hdblcm.log?

Re: Installing SAP HANA Smart Data Streaming

klausfreyburger — Wed, 26 Apr 2017 16:11:53 GMT

So far there is no /var/tmp/sdsinst.log.

I posted /var/tmp/sdsinst.log and a logfile in a subfolder hdb_HXE_hdblcm_update_...

var-tmp-hdblcm.txt

var-tmp-hdb-hxe-hdblcm-update-hdblcm.txt

Thanks Klaus

Re: Installing SAP HANA Smart Data Streaming

Former Member — Wed, 26 Apr 2017 21:23:06 GMT

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

Re: Installing SAP HANA Smart Data Streaming

klausfreyburger — Thu, 27 Apr 2017 05:23:56 GMT

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