1967412 - BW on HANA Query failure due to Insufficient Privilege

Symptom

When you run a BW query, 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 listed.

*********
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" )' ) ; 
*********

Environment

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

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

Cause

The issue is caused as SAP<sid of BW system> user has insufficient privilege to execute TREXVIADBSLWITHPARAMETER.

Resolution

Goto HANA studio, add the following SQL object on the tab "SQL Privileges":
           TREXVIADBSLWITHPARAMETER (SYS)
and select "EXECUTE" with "No" for grantable to others

See Also

1776186 SAP HANA BW - Scale out: routing to right indexserver
1716826 Usage of the downward compatible kernel 721 (EXT)

Keywords

Error 258, Insufficient Privilege, HANA, RSRT, BW report, authorization

Header Data

Released On	21.01.2014 01:29:24
Release Status	Released to Customer
Component	HAN-DB-ENG-BW SAP HANA BW Engine
Other Components	BW-BEX-OT OLAP Technology BW-BEX-OT-DBIF Interface to Database
Priority	Normal
Category	How To
Database	HDB 1.0