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 ONE Support launchpad (Login required).

Search for additional results

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