Skip to Content
avatar image
Former Member

HANA XSA Deployment - HDI schema name

Hi,

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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 02 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 comment
    10|10000 characters needed characters exceeded

    • Former Member Thomas Jung

      Thanks Thomas for the explanation.

      The mta.yaml file changes - i.e setting schema name resolved the issue.

      Thanks,

      Srikanth

  • avatar image
    Former Member
    May 02 at 04:56 PM

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

    resources:

    - name: container

    properties:

    container-name: ${service-name}

    type: com.sap.xs.hdi-container

    parameters:

    config:

    schema: ZXS_MTA

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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 27 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,

    Thanks,

    BR,

    Chandra.

    Add comment
    10|10000 characters needed characters exceeded