Question

Max number of database table row records reached in Creatio system for customer

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

Like

0 comments
Show all comments