Skip to Content
0
Former Member
May 25, 2016 at 07:36 PM

Error to get schema name of Hana MDC in Cloud

324 Views

I am trying to create play around with HANA XS by following the blog by @SIMMACO FERRIERO at How to create a new OData service using the Web-Based Workbench (v2.0) and facing a road block at the step to get the schema name with below SQL commands

  1. SELECT SCHEMA_NAME FROM "HCP"."HCP_DEV_METADATA";


What i have done earlier :

Created a HCP account and created MDC with name dev as below.

Assigned the roles as in here for SYSTEM user. Link for Roles : SAP HANA Cloud Platform



Type: Database

Database SystemHANA MDC (<trial>)

Database Version1.00.102.05.1455873859

Bindings0 available

Parameters

XS EngineEMBEDDED

Web Access ENABLED

Script ServerDISABLED

DP ServerDISABLED

Executing the above SQL statement is throwing the below error that schema is not available. Did the process of getting schema name change in MDC? .

Could not execute 'SELECT SCHEMA_NAME FROM "HCP"."HCP_DEV_METADATA"' Error: (dberror) 362 - invalid schema name: HCP: line 1 col 24 (at pos 24)