Cannot create Hana XS database

[Former Member]

I am following instructions on this page:

SAP HANA Cloud Platform

When I get to step 1. "Create a SAP HANA Database", then procedure step 4., where I'm creating a new database schema and selecting the system type, I do not have an option to create "HANA XS (shared)".  I do have an option to create a normal "HANA (shared)" database, but when I create this it seems to be impossible to create a subpackage in eclipse.  Am I doing something wrong?

[anton_levin · Accepted solution]

Hello Moses,

HANA XS <shared> trial system/schema was recently retired on Trial. See release notes [1] from 16th of June. It has been replaced with HANA MDC [2]

[1]

[2] SAP HANA Cloud Platform

Regards,

Anton

[Former Member · Accepted solution]

Thanks.  When I create the MDC database I enter a database ID and password.  When I try to access that database in eclipse it asks for a "Database user", and when I use my 'ID' I get "invalid credentials".  Can you explain?

[anton_levin · Accepted solution]

You have ro enter "SYSTEM" as the user name.

[Former Member · Accepted solution]

Thanks.  That worked.  Would never have guessed. 

I have two more questions:

1.) Now that I connected, the tutorial says:

In the Systems view, select the Content/p1234567890trial/myhanaxs node.

But my system has a different structure under Conect.  It looks like this:

Content

public

sap

system-local

with many other subpackages.  Where am I supposed to create a package?

2.) I was also trying to create an HTML5 project and was watching a video on how to do it, but in the WEB IDE when I go to the home screen and choose New project from Template => SAP Fiori Worklist Application I am not able to select a "system" -- there are no options.  In general, how am I supposed to create database systems?

Thanks again.

[anton_levin · Accepted solution]

1. In SAP HANA Web-based Development Workbench you create your package(s) under Content folder. Right click on it -> New -> Package

2. Didn't really get your question. You have created your DB system now (MDC), default DB user (SYSTEM) and a DB schema (also SYSTEM same to user name). Do you want to consume the data from HTML5 app now? SAP WebIDE is not the same to SAP HANA Web-based Development Workbench, you cannot simply open XS packages/schemas from there.

Usually you implement and expose your service (i.e. XSODATA one) in SAP HANA Web-based Development Workbench; configure a HTTP destination in your HCP account; implement a HTML5 app in SAP WebIDE and consume the service via destination there. (one possible setup)

Regards,

Anton

P.S. Please, familiarise yourself with the and especially #14 Don't hijack threads.

[OliverGoetz · Accepted solution]

Hi Mosel.

Moses Blumenstiel wrote:

Thanks.  That worked.  Would never have guessed.  

When I saw your statement I was wondering if we were missing something in the UI or documentation regarding the information that the password you specify when creating the database is the one of the SYSTEM user.

I checked this, and the UI looks like this:

And in the official documentation, there is this:

I'm not sure what we could change there to make things clearer. If you have any suggestion, please let me know, and I will pass it on.

Best regards,

Oliver

[Former Member · Accepted solution]

Oliver, I see what you mean, but I think that can be interpreted as "Enter a password for a user which is within the system".  Why not just add a note, something like "Username will be set as 'SYSTEM'", or "When connecting to database enter 'SYSTEM' as the username"

[Former Member · Accepted solution]

1.) Unfortunately, I'm back to my original problem.  Using "SYSTEM" as the username I can no longer access the database in Eclipse.  I went so far as to create a whole new HANA MDC database.  Could I have made too many authentication Attempts?

2.) I'm sorry I hijacked.  I'll look at your response and if I can't make sense of it I'll start a new thread.

[anton_levin · Accepted solution]

Hi Moses,

did you also try to access it from Web UI (Development Workbench)? In HCP Cockpit you can also check if your instance (MDC) is still "running". Maybe it is stopped and you cannot connect because of that.

Regards,

Anton

[Former Member · Accepted solution]

It is running.  I can access it in the cockpit by following either one of these links and using the "SYSTEM" account with the password I specified when creating the database (if that's what you mean):

Administration Tools

SAP HANA Cockpit

Development Tools

SAP HANA Web-based Development Workbench

Thanks

[anton_levin · Accepted solution]

Ah, wait. This screenshot is for the first step (connect to your account). You provide your Account ID pXXXtrial, user pXXX and HCP pass. Only then  you connect to DB. Check here SAP HANA Cloud Platform

[Former Member · Accepted solution]

Ah, you're right.  Duh.  Sorry, got confused with all the username/password sets.

[Former Member · Accepted solution]

Well, sadly I am still stuck.  I finished this entire tutorial and everything seemed to work:

SAP HANA Cloud Platform

But when I go into cockpit and click on "Hanna XS Applications" there are none listed...

[Former Member · Accepted solution]

Also, how can I open the "Web Based Development Workbench"?

[anton_levin · Accepted solution]

See your screenshot above (with "Administration Tools and Development Tools"), second link will bring you to the Workbench.

Regarding missing XS apps. Are you sure you have all necessary files .xsapp, .xsaccess, etc activated and app is marked as "exposed"?

[Former Member · Accepted solution]

I see what you mean about the development workbench.  Problem is that if I click on "Editor" or "Catalog" I get http 403.

I think I have all the files in place and have exposed.  See for yourself:

[anton_levin · Accepted solution]

403 would mean you miss necessary roles. Did you grant the ones for the Workbench described here SAP HANA Cloud Platform ? (Use Administration Tools for that -> select a tile Manage Roles and Users -> Select your SYSTEM user -> select Granted Roles tab -> press + button)

Hard to say why your app is missing (workspace looks ok to me). Maybe it will become more clear if you see your workspace and app in the Web Workbench. From there it is also easier to run the app.

[Former Member · Accepted solution]

I was able to open the workbench, thanks.  I'll see if I can get the app running in the workbench as you suggested.