Skip to Content
author's profile photo Former Member
Former Member

HANA XSA Deployment - HDI schema name


Please help us on this. We are facing issue with reports based on HDI Container objects after deploying MTA project from DEV space to QA space.

In DEV space we have cloned our MTA project(ZMTA_XS) from git and built it.It created three schemas ZMTA_XS, ZMTA_XS#DI, ZMTA_XS#OO and we have created BO reports based on the column views in ZMTA_XS.

Now we have deployed the MTA project from DEV to QA using CLI tool and also moved BO reports. In QA space the project is creating schemas with technical names for ex:

9ABA7DDAF8304D5EA7A8D291AEBCC88B, 9ABA7DDAF8304D5EA7A8D291AEBCC88B#DI, 9ABA7DDAF8304D5EA7A8D291AEBCC88B#OO. beacause of this our reports are not working.

My question is when we cloned the project why the schemas are created with proper name(ZMTA_XS*) and when the same project is deployed to another space using CLI it is generating schemas with different GUID kind of name. Can't we retain same schema name as in DEV after the deployment to target space . How can we acheive it.

Thankyou in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on May 02, 2018 at 04:44 AM

    I assume that you have cloned your project to SAP Web IDE for SAP HANA, built it here and deployed it from there to the DEV environment. And I assume that in your development descriptor file (mta.yaml) the specific schema names are defined as parameters for your HDI resources. In that case, when the MTA is deployed to the DEV environment, the SAP Web IDE creates a deployment descriptor (mtad.yaml) containing the schema names defined as parameters, and that schema names are used.

    When you deploy the MTA using the CLI (what command you have used, xs push?) and you have not defined the schema names in a deployment descriptor or deployment descriptor extension, it is not known which schema names should be used.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2018 at 04:56 PM

    I found solution. You can standardize the generated schema name across landscape using following setting in mta.yaml file.


    - name: container


    container-name: ${service-name}




    schema: ZXS_MTA

    With above setting the schema ZXS_MTA will be created for your MTA project after deployment.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 27, 2018 at 12:52 PM

    Hello SAP EXPERTS,

    Will you please help me with migrating the development from DEV space to Quality and Prod, please...

    we have 3 spaces, one is DEV, Quality and Prod,

    Now we are doing all our development in DEV space, My question is

    1. How can i migrate my development in DEV space to QUALITY space and then to Prod space,

    2. Once migration is done, how can i access the content in Quality and Prod in WEBIDE and in my Reporting tool SAP BO.

    Thanks in advance for spending your valuable time in answering my questions,




    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.