Skip to main content

I am unable to update all the records using the below xml for mass update. Some of the records are not getting updated  if I am doing a bulk update. It is working fine up to 99 records. Is there any alternative method by which I can make it work for a large number of records? 

<perform_exec_db_edit>
<parameters>
<sql_command>update person_skill set user_def4=null,user_def5=null where person_id='@expressionoperson_skill.person_id]' and 
user_def5 is not null and user_def4='AD'</sql_command>
</parameters>
</perform_exec_db_edit>

The server log is giving exception: Exception Message : Cannot exceed more than 100 nested business rules, check for recursive business process.

Hi @TDCANJANA ,

Could you share the entire mass update xml here if possible? The shared mpm message is a exec_db_edit message.

Hi @SAMLK , 

I have created 3 rules in one Business Rule. In one I am doing mass delete, in the other mass insert for new records and in another this update is happening. This is the xml for the insert. 

<perform_batch>

<sequential_dependent>

<update_person_skill>

<person_skill>

<person_id>@person_id</person_id>

<skill>@user_def5</skill>

<insert />

</person_skill>

</update_person_skill>

</sequential_dependent>

</perform_batch>

Hi @TDCANJANA ,

The requirement and the context that you shared is still not clear. Where are you pointing towards the mass update/delete/insert operations here? Could you at least share some screenshots please?

Hi @TDCANJANA,

 

this could also be caused by the default recursive occurrence in SQL Server which is 100.

 

Cheers,

~Juni

Reply


Terms & ConditionsCookie settings