SAP Knowledge Base Article - Preview

3667804 - [CloudDataIntegrationAdapter] "Aggregation is not supported for current entityset [FactData]" when using Analytic Model with Remote Table in Datasphere - SAP HANA Smart Data Integration

Symptom

  • Federated request towards CloudDataIntegratonAdapter-based remote table throws an error via Analytic Model but works in other scenarios such as Data Builder preview and snapshot or real-time replication.
  • Error message:
    "Caught exception : exception 70000403: internal error: Error opening the cursor for the remote database Error occurred when reading data from entitySet [/sac/<GUID>/FactData]: Aggregation is not supported for current entitySet [FactData]. please check the configuration and $metadata in CDI provider."


Read more...

Environment

  • SAP Datasphere
  • SAP HANA smart data integration 2.0

Product

SAP Datasphere all versions ; SAP HANA smart data integration 2.0

Keywords

aggregation not supported, analytic model, remote table, sap datasphere, data builder preview, snapshot replication, real-time replication, poll period, CloudDataIntegrationAdapter, SDI , KBA , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.