SAP Knowledge Base Article - Preview

2985592 - Database returned the SQL code 391. Error text: invalidated view

Symptom

  • You encounter the following error(s):

Database returned the SQL code 391. Error text:
invalidated view: <viewname>

[570]{213679}[91/-1] 2022-07-25 11:27:00.792826 e mds Message.cpp(00590) : /data/jenkins_prod/workspace/<>/s/mds/base/ce/ExecutionPlanCE.cpp(484) exception 1: no.70034011 (/data/jenkins_prod/workspace/9hgys8hn72/s/mds/base/ce/ExecutionPlanCE.cpp:458) TID: 570
Inconsistent calculation model;calculationNode (<>): Invalidated View: 'SID::_SYS_BIC:<>/<> (t -1)'
exception throw location:

[453]{234961}[111/-1] 2022-07-29 09:55:14.270930 e CalcEngine ceCalcScenarioModelerInternal.cpp(00230) : The following errors occurred: Inconsistent calculation model (34011)
Details (Errors):
- calculationNode (<>): Invalidated View: 'SID::_SYS_BIC:<>/<> (t -1)'.
[453]{234961}[111/-1] 2022-07-29 09:55:14.271186 e ceOptimizerInfo ceCalcScenarioModelerInternal.cpp(00959) : Scenario 'SID::_SYS_BIC:MDS_CS_<> (t -1)' consistencyCheck:

[704]{213093}[94/-1] 2022-07-25 10:08:27.214485 e mds_caches       CubeCacheReadManager.cpp(00066) : Errors reading cube from Cache: exception  1: no.75000006  (hierarchies/external_api/MetadataAPIPTime.cpp:492) TID: 704
    Source format error; $[1]$=invalidated database object:; $[2]$=view "_SYS_BIC"."<>/<>" CS
exception throw location:

  • When executing a view via transaction SE11 or SE14.
  • In data preview in HANA Studio or transaction SE16.
  • When querying against a view or in select statements.
  • When executing the view in HANA Studio.


Read more...

Environment

  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0 

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

 invalid, '' , KBA , HAN-DB , SAP HANA Database , 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.