SAP Knowledge Base Article - Preview

2250455 - SAP DBTech JDBC 485 - Invalid definition of structured privilege: Invalid filter condition

Symptom

  1. When reading Table Data Preview from a calculation view in a BW on HANA scenario you see the following error:

Capture.PNG 

  1. Running a trace in HANA Studio by the means of  Trace Configuration > DEBUG > reproduce the issue > turn off trace. You can see the following in the indexserver trace file:
[27065]{338858} w Authorization    SqlAnalyticalPrivilegeFacade.cpp(00356) : No condition could be obtained from procedure _SYS_BIC.bw2hana/<Schema>_CZZCV04_REPORTING
[27065]{338858} i TraceContext     TraceContext.cpp(00827) : UserName=S1234, ApplicationUserName=<app name>, 
                                    ApplicationName=HDBStudio, ApplicationSource=csns.modeler.datapreview.providers.ResultSetDelegationDataProvider
[27065]{338858} e Authorization    SqlApChecker.cpp(00069) : Retrieving referenced objects from sql ap filter condition 1 failed. Reason is: Invalid filter condition


Read more...

Environment

HANA Database 1.0

Product

SAP HANA 1.0, platform edition

Keywords

 analytical privilege, EXECUTE, Authorizations, , KBA , HAN-DB-SEC , SAP HANA Security & User Management , 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.