SAP Knowledge Base Article - Preview

2390443 - BW external HANA views and authorizations

Symptom

  • Insufficient privileges on generatered BW external HANA view.

    KBA_HMOD_1.PNG
     
  • Insufficient privileges on calculation views which are based on generated BW external HANA view.

    KBA_HMOD_2.PNG
     
  • 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.

    KBA_HMOD_3.PNG

 

  • Query on BW generated external HANA view gives the error message :

           SAP DBTech JDBC: [258]: insufficient privilege: search table error: [2950] 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: [258]: 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.”


Read more...

Environment

  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5

Product

SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

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 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.