SAP Knowledge Base Article - Preview

3007904 - Errors related to obsolete authorizations

Symptom

  1. When loading/reading from a HCPR, the following error messages are visible:
    • "Instantiation of calculation model failed/[Request Info: Object Name = <object_name>, FM Name = TREX_DBS_AGGREGATE"
    • "Error 34.023 has occurred in the BWA/SAP HANA server"
    • "Error reading the data of InfoProvider <hcpr_technical_name>"
    • "Error in BW: _HCPR_PROCESS-3-"
    • In the indexserver traces, further messages may be visible:
      • "Failed to obtain analytical privilege definition"
      • "No Procedure found with schema name _SYS_BIC and procedure name <procedure_name>"

  2. DBMS user appears to be authorized on an External SAP HANA view on which they'd be not supposed to, or vice versa. In this context trying to generate authorization through RS2HANA_GEN, the following error messages are visible:
    • >> Error in program CL_RS2HANA_AUTH_UTIL==========CP (Include CL_RS2HANA_AUTH_UTIL==========CM003, source position 39)
    • A database error occured. The error message in the  database was: "insufficient privilege: Detailed info for this error can be found with guid <'GUID'>".
    • >> Error in program CL_SQL_STATEMENT==============CP (Include CL_SQL_STATEMENT==============CM00M, source position 3)

  3. Error/warning during authorization check/replication: "Privilege is outdated"


Read more...

Environment

  • SAP NetWeaver 7.5
  • SAP BW/4HANA 1.0 and higher

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP BW/4HANA 2021 ; SAP BW/4HANA 2023 ; SAP NetWeaver 7.5

Keywords

"privilege", "obsolete privilege", "34.023", "34023", "HCPR", "load", "read", "_HCPR_PROCESS-3-", "Instantiation of calculation model failed", "Instantiation of calculation model failed/", "TREX_DBS_AGGREGATE", "RS2HANA_GEN", "DBMAN099", "DBMS", "not supposed", Hana view authorization issue, HANA view authorization issue , HANA SQL Privileges Misisng, HANA SQL Privileges Missing HANA Analytic Privileges, query external hana view, hana external view, insufficient privilege: Detailed i nfo for this error can be found with guid , KBA , BW4-ME-HMOD-AUT , BW2HANA authorization generation , BW-WHM-MTD-HMOD-AUT , BW2HANA authorization generation , 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.