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.
Product
SAP HANA, platform edition 2.0
Keywords
Error 258, Insufficient Privilege, HANA, RSRT, BW report, authorization, TREXVIADBSLWITHPARAMETER, permission , 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.