SAP Knowledge Base Article - Public

3456011 - Deploy a view ends with "Failed to execute a statement due to insufficient privilege" message

Symptom

A view is deployed and it ends with:

Failed to Deploy "VIEW_NAME" in "SPACE_NAME"
Review the following errors: "VIEW_NAME" - Failed to execute a statement due to insufficient privilege, Correlation ID: xxxxx-xxx-xxxx-xxx-xxxxxxx

Environment

SAP Datasphere

Reproducing the Issue

Deploy a view

Cause

A bug was fixed, however, views created prior to the resolution require redeployment.

Resolution

  • If the resources in the view are shared by the other spaces, proceed with redeploying all shared views that are utilized by the view encountering deployment issues. Once all of these have been activated, then reactivate the view that initially triggered the error.
  • Follow the steps in KBA 3479368 to find out the missing privileges and grant them to the user.

See Also

KBA 3479368 How to parse the GUID string in insufficient privilege error message in SAP Dataphere

Keywords

GUID, missing privilege , KBA , DS-MD-VIW , Views , Problem

Product

SAP Datasphere all versions