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 for Me (Login required).

Search for additional results

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