SAP Knowledge Base Article - Public

3286932 - Password for DB Analysis User cannot be reset

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

Product

SAP Datasphere all versions