3752448 - OData import from HANA Cloud database fails when batch size over 1000 with status 400 plugin_error - SAP Analytics Cloud

• Imports on models pointing to OData services on a HANA Cloud database fail when the pagination batch size is greater than 1000.
• The same imports succeed when the batch size is set to 1000.
• Error code: PLUGIN_ERROR.
• Error details HAR logs: 
  •  "PLUGIN_ERROR",
          "rawError": "Response from external server has status code of 400. ",
          "errorDefinition": "{\"code\":\"\",\"rawError\":\"Response from external server has status code of 400. \",\"params\":[\"status: 400 body: {\\\"error\\\":{\\\"message\\\":\\\"Parsing URL failed at position 62: Expected \\\\\\\"\\u0026\\\\\\\", [a-zA-Z0-9\\\\\\\\-\\\\\\\".\\\\\\\"_~!$\\u0027()*+,;\\u003d:@\\\\\\\"/\\\\\\\"\\\\\\\"?\\\\\\\"], or end of input but \\\\\\\"[\\\\\\\" found.\\\",\\\"code\\\":\\\"400\\\",\\\"@Common.numericSeverity\\\":4}}\"]}", 

SAP Analytics Cloud 2026.2.16

1. Create a model.
2. Choose OData Services.
3. Choose the connection to the HANA Cloud OData service.
4. Choose a query.
5. Select Entire table.
6. Set Batch Size to a value greater than 1000 (for example, 50000).
7. Attempt to create the model and it fails.

At the moment, OData-based data acquisition from HANA Cloud is not officially supported in SAP Analytics Cloud. While it may work in certain scenarios (such as with smaller batch sizes), it is not a fully supported or stable integration.

This explains the behavior being faced:

• When the batch size is set to 1000, the import works because the system is able to process a single batch successfully.
• When the batch size exceeds 1000, SAC attempts to retrieve additional batches, but the OData service implementation in HANA Cloud does not respond as expected for pagination, causing the import to fail.

In short, the success with 1000 records is incidental and not guaranteed, as different OData services may behave differently depending on their implementation.

1. Currently, a Live Connection can be created to HANA Cloud: Live Data Connection to SAP HANA Cloud Using an "SAP HANA Cloud" Connection | SAP Help Portal. To move from import to live, the model needs to be recreated using a live connection, and any transformations currently done in SAC should be implemented in HANA Cloud instead. This approach also avoids the OData batching limitations.
2. SAP is also working on a native HANA Cloud integration for SAC, which will simplify this architecture and remove the need for Cloud Connector and Agent in the future.

• KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

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