cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to read huge amount (~2 Lakh Records)of data from ODATA Read Call

0 Kudos

Hi Experts,

I am trying to read data from a particular OData entity which is having approx~2 Lakh records. But I am not able to read the data. I have used $top and $skip parameters in the OData read call. I am getting the following error:

{"code":"BadRequestException","message":"The request count exceeds the maximum request count allowed : 180","persistent":false,"targets":["/$batch"],"type":"Error"}] sap.ui.model.odata.ODataMessageParser

I need to read the data in advance so that I can implement some logic as per my requirement. Can you please suggest some solution to overcome this error and read the data.


With Regards,

Partha.

Accepted Solutions (0)

Answers (1)

Answers (1)

gregorw
Active Contributor
0 Kudos

Interesting to learn about the unit of Lakh which seems to stand for 100.000.

This service is telling you that you can request a maximum of 180 records. So you should use $skip and $top to read all the records step by step.

0 Kudos

HI Gregor,

Thanks for the reply.

I have tried using $top and $skip in Url Parameters. I am using $skip=0 and $top= 180 and increasing $skip every time by 180 so as to fetch 180 records at a time by looping over entire records. . But still getting the same error. Is there something I am missing out? Please provide your inputs on this.

With Regards,

Partha.

gregorw
Active Contributor
0 Kudos

If it is a custom implementation I would suggest to check the code. If it is an SAP standard service you should file an incident.

0 Kudos

Hi Gregor,

Yes it is a standard OData service from Success Factors. Is there something to do from success factors end so as to avoid this error?

With Regards,

Partha.