SAP Knowledge Base Article - Preview

2218549 - Error during installation or upgrade to sFIN 2.0 SP2

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.

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.