Symptom
The DWC system does not allow to reset the DB Analysis User password.
The action is aborted with following error message:
Correlation ID: xxxxx-xxx-xxxx-xxxx-xxxxxxx
HTTP Status: 500 Internal Server Error
Error Code: resetSchemaFailed
Technical Message: user-defined error: "DWC_TENANT_OWNER"."RESET_PASSWORD_CUSTOMER_SCHEMA": line 20 col 5 (at pos 889): Unexpected error: Invalid schema name, Code: 10002, SQL State: HY000
Environment
SAP Data Warehouse Cloud
Cause
The corresponding space should be redeployed after creating the DB Analysis User.
Resolution
Redeploy your space and then reset the password.
See Also
Similar is mentioned in SAP Help page Create a Database User, see step #4.
Keywords
DB Analysis User, reset password, DWC_TENANT_OWNER, RESET_PASSWORD_CUSTOMER_SCHEMA, Code: 10002, Invalid schema name , KBA , DS-SM , Space Management , DS-SEC , Security (Users, Roles) , Problem