SAP Knowledge Base Article - Public

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

Symptom

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 

Environment

SAP Datasphere
BW/4HANA 

Reproducing the Issue

  1. Open the remote table of imported HCPR in Data Builder of SAP Datasphere
  2. Use Data Preview mode

Cause

Missing code correction

Resolution

Please implement the following code correction in SNOTE tcode of BW/4HANA system:
SAP Note 3423151 - column store error: search table error: undefined index attribute;undefined index attribute

Keywords

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

Product

SAP Datasphere all versions