SAP Knowledge Base Article - Preview

2758186 - [Error] Could not obtain all relevant analytical privileges: Invalid SQL AP definition

Symptom

Implemented dynamic analytic privilege and give the privilege to an appropriate user. However, when a user tried to access a view gets the following error message:

[13622]{200737}[88/-1] 2019-02-21 23:27:17.291251 e Authorization SqlAnalyticalPrivilegeFacade.cpp(00924) : Failed to obtain analytical privilege definition: ObjectId(28,7,oid=3850)(convertToStatic: 1) due to error: Error while parsing injection query: SELECT * FROM "_SYS_BIC"."temp/CV_TEMP" WHERE CITY="Walldorf" with default schema: HK1: invalid column name

[13622]{200737}[88/-1] 2019-02-21 23:27:17.291385 e Authorization qo_rewrite_rules.cc(00437) : Could not obtain all relevant analytical privileges for user ADAMS accessing view ._SYS_BIC.temp/CV_TEMP due to exception: Invalid SQL AP definition


Read more...

Environment

HANA 1.0 and 2.0

Keywords

Dynamic analytic privilege, Could not obtain all relevant analytical privileges for user,  Invalid SQL AP definition, Error while parsing injection query , 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.