2638045 - Error: insufficient privilege: Not authorized when generating planviz for 'call trexviadbsl' queries in HANA Studio | SAP Knowledge Base Article

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 NetWeaver 7.5

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

Search for additional results

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