Symptom
When previewing data for datasphere objects the following message appears:
Error - Found data at an index being read from the back end
Environment
SAP Datasphere
Reproducing the Issue
Attempt to use Data Preview on related datasphere dimension, model, related object.
Cause
This error occurs when the data set (view/table/dimension) has key constraints applied on it but contains multiple entities with the same key value and hence violating the applying key constraints.
Resolution
In order to resolve issue there needs to be either a key adjustment, or in case it is not possible, deletion of duplicate records.
In order to find duplicate records please adapt and use statements similar to one below in HDB Explorer via DBAnalysis user:
SELECT a.*
FROM SPACE.DIMENSION a
JOIN (SELECT KEYCOLUMN, COUNT(*)
FROM SPACE.DIMENSION b
GROUP BY KEYCOLUMN
HAVING count(*) > 1 ) b
ON a.KEYCOLUMN = b.KEYCOLUMN
ORDER BY KEYCOLUMN
See Also
SAP Note 3587468 - SAP Datasphere Preview Error: Found data at an index being read from the back end
Keywords