SAP CAP Error during OData GET request "504 Gateway Timeout" after 30 sec.

[subhm779]

Hi Team,

I am getting this 504 Gateway Timeout issue after 30 sec when sending a OData get request in my SAP CAP NodeJS Application.

How to make an OData GET request having huge data?
How can i increase the timeout beyond seconds to minutes?

FYI:-
1. I am using postgres database in my CAP Application.
2.i chunked down that OData request to smaller Odata request but still facing the same issue.
2. I have added parameter 'pool' to 'requires'->'db' configuration also but that didnt work.

Thanks in advance.

SAP Cloud Application Programming Model PostgreSQL on SAP BTP, hyperscaler option #SAP BTP

[gregorw]

Can you provide some insight how huge your data is?

[gregorw]

What happens when you apply $top=10?

[subhm779]

Hi @gregorw ,

We have some 5000 records in main Entity and 3 entity associated to main Entity having 10,000 records in each enitity. We are pulling via OData request from UI and we are facing this timeout issue.

We are also trying one alternative approach to pull all the records by formulating all the query at backend(CAP Service). for which we have raised this question.

Question:- How can we apply filters on navigation properties of associated entities in a SAP CAP OData service