You’re offline. This is a read only version of the page.
496
I'm asking because we had a Bulk Delete Job set up that would delete certain types of accounts but ONLY if Opportunity Count = 0.
For years it ran fine but last Friday, it went rogue and deleted 5 accounts that had opportunities (and Opportunity Count clearly shows numbers greater than 0 when looked at in a form). Of course, that resulted in 30+ opportunities being deleted as well, and all this on our production system.
I'm looking at the Bulk Delete query and I can clearly see Opportunity Count is Equal to 0 in the definition.
I'm wondering if this is something funky with roll-up fields.
Microsoft is RCA'ing it and we're restoring the data manually by recreating these opportunities from a backup system but I mostly want to prevent this from ever happening again.
I can see that being possible, except in this case, the Opportunities had been created up to 2 years in the past. And if I restore to 30 minutes prior to the delete, the Opportunity Count rollup field is already rolled up to more than 0.
I guess I will have to wait and see what Microsoft says in their telemetry investigation. I think this could be a bug - just need it confirmed.
I will still mark your answer as correct as it will probably help others.
Hi,
Thank you for your query.
Roll-up fields are refreshed (calculated) every 12 hours (by default). However, you can change this configuration.
It is possible in your scenario, that opportunities are created but roll-up field is not refreshed when bulk delete job executes.
To fix this, you have to make sure Rollup fields are refreshed before Bulk Delete executes.
You can do this in following ways:
http://www.msdynamicsblog.com/programatically-recalculating-rollup-fields-through-a-plugin-in-crm/
https://pradipwebmaster.wordpress.com/tag/calculaterollupfieldrequest-in-crm/
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (