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