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
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
1EETQ003 exit code: "20"
4 ETQ399 Rollback.
4 EPU202XEND OF SECTION BEING ANALYZED END OF SCEXEC_ALIAS =================================================
Kindly help advice please. thank you.
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.