1967412 - BW on HANA Query failure due to Insufficient Privilege | SAP Knowledge Base Article

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

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 SPS 5 (= Revision 45) or later.
  • ABAP kernel version is on 721 or later. Refer to the attached note 1716826.

Product

SAP HANA 1.0, platform edition

Keywords

Error 258, Insufficient Privilege, HANA, RSRT, BW report, authorization, TREXVIADBSLWITHPARAMETER , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.