Symptom
Getting the error below or similar while deploying a HDI container:
The deployment of <Space_name> was unsuccessful. Failed to execute a database statement for Artifact #HDI_CONTAINERS_<Space_name>_xxx of type user-defined error: "DWC_TENANT_OWNER"."UPDATE_HDI_CONTAINERS_SPACE": line 130 col 7 (at pos 5477): "<HDI Container ID>"."DWC_CONSUMPTION_ROLE", "<HDI Container ID>"."DWC_CONSUMPTION_ROLE#": \{2\} Correlation ID: xxx-xxx-xxx-xxx-xxx
Environment
- SAP Datasphere
Cause
DWC_CONSUMPTION_ROLE and DWC_CONSUMPTION_ROLE# security roles are not configured correctly.
Resolution
Add the roles and re-deploy the HDI container as per the official documentation instructions:
Prepare Your HDI Project for Exchanging Data with Your Space
See Also
Keywords