SAP Knowledge Base Article - Preview

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

Symptom

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$1.run(SQLExecuteFormEditor.java:920);,......
e Row_Engine       qe_proc_call.cc(00559) : insufficient privilege [ptime/query/checker/query_check.cc:4799]


Read more...

Environment

  • HANA Platform 1.0
  • HANA Platform 2.0

Product

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

Keywords

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.