1967412 - BW on HANA Query failure due to Insufficient Privilege

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 ( ? , ? , ? )'

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.

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