Symptom
- During an installation or upgrade to sFIN 2.0 SP2 there is an error in phase MAIN_TRANSEXEC/MVNTAB_TRANS:
SQL-error "391-invalidated view: cannot create synonym for invalidate 2EETP345 d view: line 1 col 46 (at pos 45)" in DDL statement for "FCLM_CP_PDVIEW
- The full error is:
2 ETP301 ----------------------------------------------------------------------
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/09/14 15:11:56")
2 ETP301 ----------------------------------------------------------------------
2 ETP000 processing modeflag 'V'
2 ETP301 ----------------------------------------------------------------------
2 ETP330XActivation of Shadownametabs with DDL
2 ETP301 ----------------------------------------------------------------------
3 ETP379X15:11:56: activating Nametab "FCLM_CP_PDVIEW":
2 ETP000 >> Name of inactive nametab to read : DDXTT
2 ETP000 >> Format of inactive nametab to read: 5.0
3 ETP355Xstatements:
3 ETP000 CREATE SYNONYM "FCLM_CP_PDVIEW" FOR
3 ETP000 _SYS_BIC."sap.erp.sfin.fi.fclm/CashPaymentDetailDocumentListQuery"
3 ETP000
2WETP000 15:11:56: Retcode 1: error in DDL statement for "FCLM_CP_PDVIEW " - repeat
2EETP345 15:12:08: Retcode 1: SQL-error "391-invalidated view: cannot create synonym for invalidate
2EETP345 d view: line 1 col 46 (at pos 45)" in DDL statement for "FCLM_CP_PDVIEW "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 15:12:08: error in DDL, nametab for "FCLM_CP_PDVIEW" not activated
2 ETP301 ----------------------------------------------------------------------
3 ETP361 "0" Shadow-Nametabs activated, DDL executed
2 ETP362 "1" Shadow-Nametab activations failed
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/09/14 15:11:56")
2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2015/09/14 15:12:08")
2 ETP301 ----------------------------------------------------------------------
Read more...
Environment
SAP Hana Database 1.0.
Product
SAP HANA, platform edition all versions
Keywords
KBA , HAN-LM-INS-SAP , Installation of SAP Systems on HANA , HAN-LM-UPG-SAP , Upgrade of SAP Systems on HANA , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview