- Insufficient privileges on generatered BW external HANA view.
- Insufficient privileges on calculation views which are based on generated BW external HANA view.
- Insufficient privileges as the 'Classical Analytic Privileges' has been replaced by 'SQL Analytic Privileges' and therefore privilege '_SYS_BI_CP_ALL' does not work anymore.
- Query on BW generated external HANA view gives the error message :
SAP DBTech JDBC: : insufficient privilege: search table error:  exception 306003: Authorization failed in Calculation Engine. User is not authorized to add analytic privileges to runtime filters.
In the HANA Index server trace file you see an error message like the following:
w Authorization SqlAnalyticalPrivilegeFacade.cpp(00535) : No condition could be obtained from procedure _SYS_BIC.bw2hana/xxxx_xxxx_xxxx
e Authorization SqlAnalyticalPrivilegeFacade.cpp(00928) : Failed to obtain analytical privilege definition: ObjectId(24,7,oid=xxxxxxx)(convertToStatic: 1) due to error: Invalid SQL AP definition
e CalcEngine ceAuthorizationCheckImpl.cpp(03387) : AuthorizationCheckHandler::addAPsToRuntimeFilter: : Exception was thrown during getting AnalyticalPrivileges for UserID on _SYS_BIC:system-local.bw.bw2hana/XXXX (t -1)
„Error: SAP DBTech JDBC: : insufficient privilege: Could not obtain all relevant analytical privileges for user XXX accessing view ._SYS_BIC.system-local.XXXXX due to exception:
Invalid SQL AP definition.”
- SAP NetWeaver 7.4
- SAP NetWeaver 7.5
No records found in certain views after upgrading Hana DB; Invalid SQL AP definition , KBA , BW-WHM-MTD-HMOD , HANA Model Generation in BW , Problem
About this pageThis 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.