3509915 - Error: "foreign key constraint violation: TrexColumnUpdate failed on table" in Datasphere

Symptom

When deploying Consumption Model in Perspectives, the error occurs:

An internal error occurred. If this issue keeps happening, reach out to customer support and attach the correlation ID: ff671cbb-3601-443f-6110-13a17b816d10

We can provide the following information to assist either you or an SAP engineer to solve the issue:

Correlation ID: xxx-xxx-xxx-xxx-xxx
HTTP Status: 500 error
Error Code: internalServerError
Technical Message: {"message":"foreign key constraint violation: TrexColumnUpdate failed on table 'XXX:dependency' with error: Only found 0 of 1 rows from XXX:dependency(target_object_id) in XXX:object(id), rc=1535, Code: 461, SQL State: HY000"}

Environment

SAP Datasphere

Cause

At deployment time, Datasphere takes into account the dimension names (“aliases”) defined in the consumption model and requires Latin letters as part of the alias in order to correctly generate the deployable model.Datasphere does not prevent users from using special characters, but aliases that contain only special characters will not work properly.

Resolution

Verify whether the alias being used is in English. If it is not, substitute it with an English alias or at least provide the English term in parentheses. For security purposes, it is advised to use aliases that are composed solely of Latin letters, with minimal inclusion of special characters.

Keywords

DWC, DS , KBA , DS-BB , Business Builder , Problem

Product

SAP Datasphere all versions