Skip to main content

We're currently updating and deleting records in bulk using a business rule. It works fine with around 100 records, but we encounter problems when processing larger batches, such as 400 records. Not all records are updated or deleted correctly.

The error message we’re seeing in the log is:

"Error: Cannot exceed more than 100 nested business rules. Check for recursive business processes."

Is there a way to adjust the business rule so it can handle larger batches of records?

 

@TDCANJANA 

Hi,

could you provide the xml that is in the business rule?

 

Thank you,

Morris

@TDCANJANA ,

are you using SQL Server as your database?

 

SQL Server defaults recursion to 100. 

 

You can extend it by giving the MAXRECURSION option

 Source:

WITH common_table_expression (Transact-SQL) - SQL Server | Microsoft Learn

 

Let me know if it helps you to solve  your issue.

 

Cheers,

~Juni

Reply


Terms & ConditionsCookie settings