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
- Open the remote table of imported HCPR in Data Builder of SAP Datasphere
- 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