SAP Analytics Cloud "Request Entity Too Large"

[former_member681503]

Hi, community!
I have a problem with a big data in SAP Analytics Cloud.

I try to create a model in SAC. I get data from our OData Service. This service provides data with batch processing, batch size equals 40 thousands. Data amount is 400 thousands entries, each contains 50 fields.

But I get the error "Request Entity Too Large".

I tried to reduce batch size, but it didnt help. I dont have an possibility to reduce amount of data.

What can I do to load all this data to SAC?

[former_member681503 · Accepted solution]

That was an error from Apache, not from SAC.

[jhodel18]

Hi Inna,

OData service is meant low volume data transfer that is commonly consumed by web applications. It is not meant for transferring loads of huge data that's why you are getting that error.

You probably have to switch consuming HANA calculation views, but if HANA db is not there, reduce the amount of data you consume by summarizing the data from the backend source.

[ThomasK]

Hi Jhodel,

it´s interesting you say "OData service is meant for low volume data transfer". SAP itself has decided to realize the standard import interface from S/4 HANA ACDOCA (Actuals) and the export interface to S/4 HANA ACDOCP (Plan, Budget, Forecast) based on OData services. In this case we´re talking about a really huge amount of data. I can´t believe they have chosen the wrong technology.

BR Thomas

[jhodel18]

Hi Thomas,

OData service can actually work if used within it's means or limitation. Because it is not like SOAP where it is meant for asynchronous operations. For using OData service with huge data, then you will probably better of managing the query of data in smaller chunks using middleware software like PI/PO/CPI. That example you mentioned perhaps is being used with a middleware software that helps to manage the huge volume of data being transfered.

[former_member681503]

Hi Jhodel! Hi Thomas!

In our project we use data packets.

Specification of the problem is that we should import all the data to SAP Analytics Cloud with only one query.

As I found out, if I try to get more than 25 columns in one query, I get this error. We suppose that SAC probably gets and displays this error from our server (Apache).

How does SAC state the error to display?

[jhodel18]

Hi Inna,

Unfortunately, I'm also new to SAC. I would suggest raising a support ticket to SAP for that SAC specific question.