SAP Knowledge Base Article - Public

3617223 - Data Preview Error - Found data at an index being read from the back end

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

 SAPUI5, UI5, ODataV4, OData V4, "Duplicate key predicate", "Failed to get contexts", "Found data at an index being read from the back end"
, KBA , DS-DI-DM , Data Maintenance , Problem

Product

SAP Datasphere all versions