SAP Knowledge Base Article - Preview

1967412 - BW on HANA Query failure due to Insufficient Privilege

Symptom

When you run a BW query, the following error message is shown.

insufficient privilege: Not authorized 
Error 258 has occurred in the BWA/SAP HANA server 
Error reading the data of InfoProvider XXXXXX 
Error while reading data; navigation is possible 
>> Row: 59 Inc: MAP_TREX_EXCEPTION Prog: CL_RSDRH_TREX_STORAGE 

In dev log, you could find information as below:


C  SQLCODE    : 258C  SQLERRTEXT : insufficient privilege: Not authorized
C  sc_p=1147cab88,no=201,idc_p=(nil),con=0,act=0,slen=108,smax=256,#vars=3,stmt=116b7bdd0,table=
C  CALL SYS.TREXviaDBSLWithParameter(  ? ,  ? ,  ? , 'ROUTE_BY_TABLES("SAP<sid>"."0BW:BIA:<sid>:XXXXXX\
C  D" )' ) ; 

Or in HANA indexserver trace, you could find below information:

[00000]{00000}[00/-1] YYYY-MM-DD HH:MM:SS.ss i Authorization SQLFacade.cpp(02528) : User <schema owner user> is missing privilege EXECUTE for PROCEDURE/FUNCTION SYS.TREXVIADBSL
[00000]{00000}[00/-1] YYYY-MM-DD HH:MM:SS.ss i Authorization query_check.cc(03728) : User <schema owner user> tried to execute 'CALL SYS.TREXviaDBSL ( ? , ? , ? )'


Read more...

Environment

The issue occurs in a system with all the following patches and fixes applied.

  • Corrections mentioned in note 1776186 have been implemented.
  • SAP HANA 2.0 SPS04 (= Revision 45) or later.
  • ABAP kernel version is on 721 or later. Refer to the attached note 1716826.

Product

SAP HANA, platform edition 2.0

Keywords

Error 258, Insufficient Privilege, HANA, RSRT, BW report, authorization, TREXVIADBSLWITHPARAMETER, permission, TREXviaDBSL , KBA , HAN-DB-SEC , SAP HANA Security & User Management , BW-BEX-OT , OLAP Technology , BW-BEX-OT-DBIF , Interface to Database , How To

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.