Skip to Content

Transport HANA procedure + SCHEMA error

Hi,

I am trying to transport a Procedure from HANA DEV to HANA QA.

In DEV, the schema is "ECC_SLT_HBD".

In QA, the schema is "ECC_SLT_HBQ".

In the DEV, i need to use the below line to activate my "Procedure"

PROCEDURE "ECC_SLT_HBD".".Procedure_SWWLOGHIST::UPDATE_LOGHIST"

when i transport the same to QA HANA via change list, i get error that "schema

"ECC_SLT_HBD" is not active" in the QA system

If i put the QA schema in DEV, it will never get activated as the QA schema is not available in the "DEV" system.

Can you guide me to transport the Procedure ??

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 20, 2017 at 11:07 AM

    As you cannot define the schema name at that place in a dynamic or mapped way (e.g. via schema mapping), you cannot solve the issue with two different schema names. You have to create a schema (as recommended by a repository object) which will then have the same name on DEV and QA. Calling that repository defined procedure is possible w/o using the schema name by using the automatically generated public synonym.

    Regards,
    Florian

    PS: In the "XS Advanced" world you will not have such issues anymore, because you define your objects not related to a schema. The schema handling will be done for you automatically (at least for the basic stuff).

    Add comment
    10|10000 characters needed characters exceeded