SAP Knowledge Base Article - Preview

2762943 - ERROR [SQL-485] invalid definition of structured privilege: Condition 1 = 1 cannot be used for <viewname>

Symptom

On a BW on HANA system, one of the HANA calculation views suddenly becomes in-active. The error message related to activation appears as follows:

"Cannot convert the filter expression to a valid query"

The related indexserver trace shows as follows:

--------------------------------------------------------------
The scenario '_SYS_BIC:<calc view name> (t -1)' includes a cyclic dependency to itself(scenario -> cyclicDependencyCheck)
The following errors occurred: Inconsistent calculation model due to cyclic dependency. (34109)
Details (Errors):
- scenario -> cyclicDependencyCheck: The scenario '_SYS_BIC:<view name> (t -1)' includes a cyclic dependency to itself.
 
............WHERE 1 = 1
Reason: ERROR [SQL-485] invalid definition of structured privilege: Condition 1 = 1 cannot be used for <another viewname> at/sapmnt/ld7272/a/HDB/jenkins_prod/workspace/HANA__FA_CO_LIN64GCC48HAPPY_rel_fa~hana1sp12/s/ptime/query/checker/check_priv.cc:3408
exception 1: no.71000485 (ptime/query/checker/check_priv.cc:3408)
Condition 1 = 1 cannot be used for <viewname>
------------------------------------------------------------------------------------


Read more...

Environment

  • HANA 1.0

Product

SAP NetWeaver 7.5

Keywords

Condition 1=1, external view, BW composite provider, SQL-485 , KBA , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.