You can translate the question and the replies:

Large post request returns error code 500

I am trying to make a post request via Postman to insert rows into a data base table that we have connected trough a Denodo API. When trying to insert aprox. 300 000 rows (in one post request), status code 201 is returned and the rows are succesfully inserted into the table. The size of the body is in this case about 100 MB. However, when trying to insert about 1 000 000 rows error code 500 is returned within 10 seconds. For this case the body is about 250 MB. We have tried to increase the memory query size to 1 GB, with the same results. Any idea on how to fix this issue?
user
24-10-2022 07:41:53 -0400
code

1 Answer

Hi, In order to overcome this issue, I would check the following, * whether the view has been deployed properly as a web service. * If the [**Connection timeout**](https://community.denodo.com/kb/en/view/document/Read%20timed%20out%20creating%20data%20source%20with%20HTTP%20data%20route) has been configured for the data source. Also, the reason for receiving an error 500 is "the server encountered an unexpected condition which prevented it from fulfilling the request". so, I would also check if the web server is working properly. In addition, as a test, I would validate the same query execution from any other API client Tools. If the issue still persists and you have a valid Support account, then please raise a Support case at the [**Denodo Support Site**](https://support.denodo.com/) so that the Denodo Support Team will help you further. Hope this helps!
Denodo Team
26-10-2022 02:43:27 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here