cancel
Showing results for 
Search instead for 
Did you mean: 

XSODATA Too many records in result set on SAPUI5 Controller

former_member687142
Discoverer
0 Kudos
916

I am trying to consume a xsodata of a calculation view in my ui5 app.
When i try to call the service in the URL, i see this error message:
{"error":{"code":400,"message":{"lang":"en-US","value":"Too many records in result set. Use $top with to reduce the record count."}}}

When i add the $top option, i can see my data. I get the same error when i try to consume the xsodata service on my ui5 Controller:

return new Promise(function (resolve, reject) {
oTemplateModel.read(/myServiceParameters(param='value')/Results, {
success: function (oResult) { },
error: function (oError) { }

When i run my app, i see in debug that the oError var is filled with this error message:
{"error":{"code":400,"message":{"lang":"en-US","value":"Too many records in result set. Use $top with to reduce the record count."}}}

How can i solve this error?
Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

junwu
Active Contributor

settings { limits max_records = 9999;}

put this in your xsodata

former_member687142
Discoverer
0 Kudos

Hi Jun,

I changed to my maximum rows and it worked.

Thanks

Answers (0)