cancel
Showing results for 
Search instead for 
Did you mean: 

8MAIN_SHDIMP/SUBMOD_SHDALIASCRE/SCEXEC_ALIAS

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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 Kudos

Update.   I had this error when upgrading to S/4HANA 1605 on a system that was ERP6 EHP7.     Dropping the synonym and then clicking retry in SUM resolved the issue.   I did not need to use SE14 to regenerate the table.

error in DDL statement for "CECOEJ" - repeat

SQL-error 330 cannot use duplicate synonym name: CECOEJ: line 1 Col 21

Thank you!

Former Member
0 Kudos

Hi Michael!

Thanks! That's brilliant!

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Mariel,

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

Regards,

Madhuranjani