Question
Max number of database table row records reached in Creatio system for customer
14:49 Nov 22, 2022
Hello,
We have a customer that has a table in their database called “Calls” which corresponds to calls they have had to prospective clients. We recently started receiving error messages in the process logs:
It seems there is a 40k row limit when processing records through a business process in the database.
I would like to adjust the EntitySchemaQuery in the picture to only fetch the latest created 10000 records instead so as bypass the 40000 record problem so I added this change to the ESQ:
//esq.AddColumn("CreatedOn").OrderByDesc();
//esq.RowCount = 10000;
Do you think this change is sufficient to achieve what I described above?
Best regards,
Per
Like
0 comments