3423882 - Data Preview is not working on imported HCPR in SAP Datasphere

The HCPR is imported via SAP BW/4HANA Model Transfer from BW/4HANA system into SAP Datasphere. The Data Preview shows the following error message:

internal error: Error opening the cursor for the remote database Failed to execute query [SELECT "Remote.xyz....

The LISTCUBE tcode shows the HCPR data in BW/4HANA system. However the basic SQL statement is failing in SQL Editor of DB02 tcode:

SELECT * from "[schema]"."/BIC/V[HCPR name]8"

Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT  
      Kernel Error ID:      UNCAUGHT_EXCEPTION 
      DB Error:           Yes 
      SQL Code:           2048  
      SQL Message:      column store error: search table error:  [2957] undefined index attribute;undefined index attribute;object=XXX::XXXXXX:_SYS_CE__SYS_CE_SORT_AND_FILTER_TABLE__U10BW:BIA:XXXXXX:QO_5784BB0C2A879C46B7E612BB452E494B_5067871en 

SAP Datasphere
BW/4HANA 

KBA , DS-DI-RT , Remote Tables , BW4-DM-HCPR , Composite Provider , Known Error