The error could be related to resource limitations, particularly memory or execution time. This might happen if the batch size is too large or if the database query takes too long to execute.
Solution:
- Reduce batch size: Try decreasing the number of records being processed in each batch. This can help alleviate memory or resource constraints.
- Optimize queries: Ensure that the database queries are efficient. Index the table properly and make sure there are no unnecessary joins or operations that can slow down the query.
- Increase timeout limits: Check the timeout settings for your database or the Mendix platform. If the query takes longer than the allowed time, it might be killed. You can increase the timeout setting for database queries or on the server if applicable.
You can follow these Solution:
- Commit in smaller batches: Ensure that each batch is properly committed after the deletion to avoid large, uncommitted transactions. Commit every few thousand records if necessary.
- Use microflows with limited records: In a microflow, retrieve only the necessary records to avoid pulling large data sets into memory.
By optimizing the deletion process, reducing the size of each batch, reviewing server and database settings, and ensuring that proper indexing is in place, you should be able to resolve the problem.