SAP Knowledge Base Article - Preview

2390443 - BW External SAP HANA Views and Analytic Privileges

Symptom

You are using the BW feature External SAP HANA Views and face one of the following errors:

  • Insufficient privileges when accessing a External HANA view.
    • Error executing the query: „Error: SAP DBTech JDBC: [258]: insufficient privilege.
  • Insufficient privileges when running a query on a Hana calculation views which are based on External HANA views.
    • Error executing the query: „Error: SAP DBTech JDBC: [258]: insufficient privilege:[2950]user is not authorized.
  • In the HANA Index server trace file you see an error message like the following:
    • Authorization SqlAnalyticalPrivilegeFacade.cpp(00535) : No condition could be obtained from procedure _SYS_BIC.bw2hana/....
    • Authorization SqlAnalyticalPrivilegeFacade.cpp(00928) : Failed to obtain analytical privilege definition: ObjectId(24,7,oid=...)(convertToStatic: 1) due to error: Invalid SQL AP definition.
    • 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: [258]: insufficient privilege: Could not obtain all relevant analytical privileges for user XXX accessing view ._SYS_BIC.system-local... due to exception: Invalid SQL AP definition.”
  • Incorrect/unexpected data displayed when accessing an External HANA view with SQL(Data Preview).


Read more...

Environment

  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5
  • SAP BW/4HANA

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

No records found in certain views after upgrading Hana DB; Invalid SQL AP definition; RS2HANA_AUTH 27, "DBMS User not maintained" , KBA , BW-WHM-MTD-HMOD-AUT , BW2HANA authorization generation , BW4-ME-HMOD , HANA Model Generation , BW-WHM-MTD-HMOD , HANA Model Generation in BW , BW4-ME-HMOD-AUT , BW2HANA authorization generation , How To

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.