SAP Knowledge Base Article - Public

3420288 - Failed to import job via Odata connection in SAP Analytics Cloud (SAC)

Symptom

Failed to import data from Odata connection in SAP Analytics Cloud due to error:

  • Query has failed to upload because of an error in the plugin service.

Checking Har log and find the following error:

  • Response from external server has status code of 400\",\"params\":[\"status: 400 body: {\\\"error\\\":{\\\"code\\\":\\\"\\\",\\\"message\\\":\\\
    The query specified in the URI is not valid. The limit of \\u002710000\\u0027 for Top query has been exceeded. The value from the incoming request is \\u002750000\\u0027.\\\

Environment

  • SAP Analytics Cloud (Enterprise) 2024

Reproducing the Issue

  1. Logon to SAC tenant and create a new model via Odata connection.
  2. Select any entity and drag some objects to create the model.
  3. Importing data failed with error:
    Query has failed to upload because of an error in the plugin service.

Cause

  • While importing the model, Query Batch Size is set as default value 50,000.
  • Checking from the Har error:
    The limit of \\u002710000\\u0027 for Top query has been exceeded. The value from the incoming request is \\u002750000\\u0027.\\\

    MaxTop() parameter in the Odata API is set as 10000, while 50000 is out of MaxTop() parameter limitation.

Resolution

  • Set Query Batch Size to a smaller value (e.g. 9000) while importing the data from Odata connection.

See Also

https://learn.microsoft.com/en-us/odata/webapi/pagesize-top-maxtop

Keywords

SAP Cloud, 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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions