SAP Knowledge Base Article - Preview

2638045 - Error: insufficient privilege: Not authorized when generating planviz for 'call trexviadbsl' queries in HANA Studio


When you try to generate planviz for a 'call trexviadbsl' query, below error shows:

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized.

The query usually has below format:

Call trexviadbsl ('olapSearch' , to_blob(hextobin ('xxxLong HEX codexxx'), ?);

KBA planviz.png

And you found below error in the indexserver trace:

i TraceContext     TraceContext.cpp(01114) : UserName=<user name>, ApplicationUserName=<user name>, ApplicationName=HDBStudio, ApplicationSource=csns.sql.editor.SQLExecuteFormEditor$2$;,......
e Row_Engine : insufficient privilege [ptime/query/checker/]



  • HANA Platform 1.0
  • HANA Platform 2.0


SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0


insufficient privilege; Not authorized; call trexviadbsl; call TrexViaDbslWithParameter; planviz; HANA Studio; Visualize Plan; , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , HAN-DB-SEC , SAP HANA Security & User Management , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

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