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

When previewing data for datasphere objects the following message appears:

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

SAP Datasphere

Attempt to use Data Preview on related datasphere dimension, model, related object.

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.

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

SAP Note 3587468 - SAP Datasphere Preview Error: Found data at an index being read from the back end