SAP Knowledge Base Article - Public

2541606 - SQL Error : "insufficient privilege" when connecting to HANA system in Analysis for Office

Symptom

The error below is occurring in Analysis for Office when trying to connect to HANA system:

"Caught exception : exception 42111: SQL Error : insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:3389 (42014)"

The HANA revision is lower than 102.06.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Resolution

Refer to SAP note 2339729 for the solution, which is an upgrade in HANA side, or use the workaround mentioned in the note.

Keywords

privilege, authorization, role, user, logon, login, access, unable, error, exception, authorized , KBA , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions