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,

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

[andrzej_kucharczyk]

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.

[andrzej_kucharczyk]

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.

[klausfreyburger]

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

[andrzej_kucharczyk]

Let it finish please.

[klausfreyburger]

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

[andrzej_kucharczyk]

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.