Online Tutorials & Training Materials | STechies.com
Register Login

Error Reading the Data of Infoprovider, database error 258

|| || 0

Error Reading the Data of Infoprovider, database error 258
Stechies

Insufficient Privilege Query failure in BW

Following error message is coming When we run a BW query

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

Solution:

Above error you are getting because as SAP<sid of BW system> user has insufficient privilege to execute TREXVIADBSLWITHPARAMETER.

Kindly follow the below steps:

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


Related Articles

0.0126 seconds.