Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
Former Member replied

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question