SAP Knowledge Base Article - Public

3752448 - Imports Models Pointing to OData Services on SAP HANA Cloud Fail in SAC

Symptom

One or more of the following behaviors occur when acquiring data from an OData service exposed through SAP HANA Cloud into SAP Analytics Cloud:

  • Model creation fails.
  • Data import fails.
  • Data preview fails.
  • Refreshes fail.
  • HTTP errors are returned by the OData service.
  • PLUGIN_ERROR or other acquisition-related errors are reported.
  • The issue occurs only for large result sets or during pagination.

Environment

  • SAP Analytics Cloud 2026.2.16
  • SAP HANA Cloud

Cause

Data acquisition from OData services involves communication between SAP Analytics Cloud and the OData provider.

Failures can originate from multiple layers, including:

  • OData service implementation.
  • OData query syntax.
  • Pagination handling.
  • Authentication or authorization.
  • Service configuration.
  • Network connectivity.
  • Known product issues.

Additional investigation is therefore required to identify the source of the behavior.

Resolution

1. Validate the OData Service Outside SAP Analytics Cloud

To determine whether the behavior originates from SAP Analytics Cloud or from the OData service itself, test the OData endpoint independently using a browser or API client such as:

  • Postman

  • Bruno

It is recommended to execute the same OData query used by SAP Analytics Cloud and verify whether the service returns the expected results.

For example, if pagination is involved, a request similar to the following can be tested:

https://<service-url>?$top=50000

This is only an example. The exact query parameters should be adjusted according to the OData service being used and the scenario being investigated.

If the same error or behavior can be reproduced outside SAP Analytics Cloud, the issue is likely related to the OData service implementation and should be investigated by components BC-XS-CDX-NJS or BC-XS-CDX-JAV.

2. Capture and Test the OData Request Generated by SAP Analytics Cloud

It is recommended to capture the exact OData request generated by SAP Analytics Cloud and execute it independently against the OData endpoint.

To capture the OData request, refer to: 

  • KBA 3745411  - [Best Practice] How to capture the OData query when trying to acquire data from CAP OData Service exposed in SAP HANA Cloud into SAP Analytics Cloud (SAC) 

Compare the request generated by SAP Analytics Cloud with the request executed directly against the service and verify whether the same behavior occurs.

3. Check for Known Issues

If the OData service works correctly when tested independently, review existing KBA for known issues related to OData acquisition to HANA Cloud and pagination behavior: KBA 3764919  - Data acquisition from CAP OData service fails when result set exceeds configured page size - SAP for Me

See Also

Keywords

odata, hana cloud, sac import, pagination, batch size, plugin_error, status code 400, parsing url failed, odata pagination, import model failure, data acquisition, odata service, sac agent, cloud connector , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions