Question

Error MxDbConnector

0

Good morning everyone, I'm trying to run a processing in mendix that takes a considerable time, but I'm getting the following error:

asked 2021-10-19

Josimar José Nepomuceno

3 answers

Robert Price · Answer 1 · 2021-10-20

Can you break down the processing into smaller batches?

There is an old (but still good) blog post on how to do this using the Limit and Offset options of a Retrieve action. The principle is still the same.
https://www.mendix.com/blog/limits-and-offsets/

Hope this helps.

Josimar José Nepomuceno · Answer 2 · 2021-10-20

I'm already using batch processing, but it keeps causing this issue.

Josimar José Nepomuceno · Answer 3 · 2021-10-20

in the project I'm using connector database in this case querying data in external database the connection pool restricts the number of connections too?