Skip to Content
0

Google HANA Express Cockpit 404

Apr 19, 2017 at 11:32 PM

308

avatar image
Former Member

I am running the HANA Express in Google Cloud and get a 404 for the cockpit, <Public IP Address>:8090/sap/hana/admin/cockpit.

If I go to <Public IP Address>:8090/, I see that XSEngine is up and running..

From the Eclipse HANA Administration, I am able to connect to the database and see statistics. However, the General Information - Operational Status has "Some services not started."

I've tried stopping and starting the database from the SSH terminal, using the HDB stop and start command.

I've searched the forum and didn't come across a solution. Any suggestions? Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Florian Pfeffer
Apr 20, 2017 at 08:33 PM
1

Have you checked the answer of Lucia Subatin in question GCP SAP HANA EXPRESS - XSJS? As the HXE version on GCP is server-only, you get only the "XS (classic) Splash Screen", but no real XS classic functionality. For that you have to install the XS Classic tooling like described in tutorial https://www.sap.com/developer/how-tos/2016/10/hxe-xs-tooling.html.

Regards,
Florian

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Florian,

Thank you very much. This put me in right path and I am blocked at step 11 in the tutorial. After logging in to the web portal, I get the message "403 - Forbidden The server refused to fulfill the request. Possible solution More information about why the request was refused may be found in the server logs."

I have the Eclipse HANA Studio connected to the SYSTEMDB@HXE with the SYSTEM account. And followed the tutorial steps for this setup.

I've created a tenant DB (TESTDB) in the SQL console with: CREATE DATABASE TESTDB SYSTEM USER PASSWORD mypass123

However, I was not able to connect to the tenant DB with the Eclipse HANA Studio. I get the message "The system cannot be reached. The logon data could not be used. Do you want to add the system anyway?"

I do see it in the "SYS"."M_DATABASES" view and it does have ACTIVE_STATUS = YES.

I have also tried stopping and starting with HDB stop/start commands in the ssh terminal.

I've looked at the logs available from Google cloud console, but do not see anything thing relevant, or any error/warning entries.

Do you have further suggestions? Thank you and appreciate the help.

0

Can you show how you try to logon?

0
Former Member

I went to http://public.ip:8090/sap/hana/ide/, and used SYSTEM as the username and the HANA db master password created just after spinning up the vm.

Then I get redirected to http://public.ip:8090/sap/hana/ide/?x-sap-timestamp=1492751273716 with the 403 message. I do see "SYSTEM and Log Out" links on the top right of the page.

0

That means that your user does not have the privileges necessary to access the Web-based Dev workbench. Did you do the role assignment described in steps 8 and 9 of the tutorial. The roles have to be assigned to the user you wanna use (in your case the SYSTEM user). Please ensure also that you do that in the SYSTEMDB, cause the XS classic instance points to the SYSTEMDB.

0
Former Member

Thank you. That was it. I had added the privileges using the Eclipse studio but didn't save my changes. I did a Ctrl+S this time.

I'm able to log in to the web-based workbench which seems to have similar features as the Eclipse studio. However, I'm still getting 404 for http://<Public IP Address>:8090/sap/hana/admin/cockpit.

Is this available for XS classic?

0
avatar image
Former Member Apr 20, 2017 at 01:30 AM
-1

Hi Alex,

It seems like the xs engine, web dispatcher and network connection were both working fine, I'm not sure if this's the answer,

but with the HANA Express VM edition, you have to check the XSA app list to get the correct port + URL to access cockpit.

Logon as XSA admini user find the one with xsa-admin URL surffix

./xs-admin-login

xs apps

Regards,

Michael

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

Thanks Michael, but your suggestions did not work for my issue.

0