SAP Knowledge Base Article - Public

2889713 - Rows are being rejected during data import from SAP GTT via generic OData into SAP Analytics Cloud

Symptom

  • Import data using OData connection to SAP Global Track & Trace (GTT) fails.
  • After certain amount of data rows data cannot be imported anymore and error appears:
    The following error message comes from the external data service: status:500 body:{"error":{"code":"200000001","message":{"lang":"en","value":"Internal errors occurred while searching data on a remote server. Please contact SAP Support."}}}
  • Based on our tests this amount limit seems to be around 10000 rows.

Environment

  • SAP Analytics Cloud (Enterprise) 2020
  • SAP GTT via OData

Reproducing the Issue

  1. Connect to a SAP GTT table via native OData connection.
  2. Attempt to import dataset from "Delivery Process" as an example.
  3. Rows are rejected and the above error appears.
  4. In case lowering the amount of rows being imported by adding a date filter, rows are getting imported successfully.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

Workaround

Define a date filter to reduce the amount of rows to import, lower than 10000.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0