Skip to Content
avatar image
Former Member

8MAIN_SHDIMP/SUBMOD_SHDALIASCRE/SCEXEC_ALIAS

Encountered below error on phase MAIN_SHDIMP/SUBMOD_SHDALIASCRE/SCEXEC_ALIAS during upgrade.

Activity: ERP 6.0 EHP 7 upgrade from stack 8  to 9

DB:       Hana

OS:       Linux

Error message:

3 ETQ398 SQL: DROP SYNONYM "CECOEJ"

3 ETQ398 SQL: CREATE SYNONYM "CECOEJ" FOR SAPABAP1."CECOEJ"

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20151023072831

1EETQ008 Error message: DBSL error 99 (db code 7):

1EETQ009Xfeature not supported: cannot create synonym for synonym: line 1 col 38 (at

1EETQ009Xpos 37)

1EETQ003 exit code: "20"

4 ETQ399 Rollback.

4 EPU202XEND OF SECTION BEING ANALYZED END OF SCEXEC_ALIAS =================================================

Kindly help advice please. thank you.

screenshot3.jpg (140.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 17, 2015 at 03:27 PM

    Upon checking, creating synonym for a synonym is not supported by SAP HANA, therefore we had to remove the existing synonym.  My error happened because it is creating synonym for the synonym.

    1. Check if the synonym belongs to schema or shadow instance schema.

    select * from synonyms where synonym_name='<synonym_name>'; (the synonym SUM is trying to create, in my case CECOEP)

    example: select * from synonyms where synonym_name='CECOEP';

    If it returns a result, meaning, it is already existing.

    2. Check if the table exists.  (in my case, SAPABAP1.CECOEP)

    select table_name from m_cs_tables where schema_name = '<schema_name>' and table_name='synonym_name'

    example: select table_name from m_cs_tables where schema_name = 'SAPABAP1' and table_name='CECOEP'

    3. If the table DOES NOT exist from above query, it should be created.

    3.1 Drop the synonym. Make sure it is really a synonym, not the actual table. (you can check the column "OBJECT_NAME" for the table it is referring to)

           drop synonym "<SCHEMA_NAME>"."<SYNONYM_NAME>"

           example:    drop synonym "SAPABAP1"."CECOEP"

    3.2 Create the table (use the synonym name, eg CECOEP) in SE14.

    Repeat the phase.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 07:39 AM

    Hi Mariel,

    Analyzing this issue through logs in SCN is difficult, so please raise an incident under BC-UPG-TLS-TLA component.

    Regards,

    Madhuranjani

    Add comment
    10|10000 characters needed characters exceeded