Symptom
Getting the error below or similar while deploying a HDI container:
- The space <Space_name> couldn’t be deployed. Execution of a database statement for artifact '#HDI_CONTAINERS_<Space_name>_xxx ' failed with error: user-defined error: "DWC_TENANT_OWNER"."UPDATE_HDI_CONTAINERS_SPACE": line 130 col 7 (at pos 5519): "<HDI Container ID>"."DWC_CONSUMPTION_ROLE", "<HDI Container ID>"."DWC_CONSUMPTION_ROLE#" Correlation ID: xxx-xxx-xxx-xxx-xxx
or
- 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
Define Datasphere's roles in HDI container as per the official documentation instructions.
Support Content: Defining Datasphere's roles in HDI container
See Also
Keywords
HDI, container, mapping, map, space, bind, Datasphere, DWC_CONSUMPTION_ROLE, DWC_CONSUMPTION_ROLE, failed, execute, unsuccessful, deploy, deployment, privileges, write, read
, KBA , DS-SM , Space Management , Problem
Product
SAP Datasphere 1.0
SAP Knowledge Base Article - Public