web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Too Many Records in Ro...
Microsoft Dynamics CRM (Archived)

Too Many Records in RollupJobBase Table

(0) ShareShare
ReportReport
Posted on by woodtool 35

We are running into performance issues and noticed that we have 6.5 million records in the RollupJobBase table going back to early 2017. We are on CRM 2015 Update 1.1 onprem which looks like was supposed to fix this issue. It does seem to be increasing. Just one day it increased by 85K records. We only have 6 rollup fields in the org and the data in the fields doesn't get updated often. The system jobs to update counts are scheduled with the default of 1 hr. Are these records we can just delete? Should we try to remove the rollup fields first, then delete the data and then add the fields back in? Thanks for any advice we could get on this.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Hi,

    Take a look at System Jobs and see if you can find these records there. Basically Rollup field create a system job for each execution. If these records are in completed state then you can simply create a bulk delete job and delete these records. You can also schedule the job to do this periodically.

    crmtipoftheday.com/.../scheduling-daily-bulk-delete-jobs

    Also, as you mentioned that the data in these fields doesn't changed that frequently, you can change the frequency of these jobs as well.

    dynamicscrmpros.com/changing-rollup-calculation-frequency-microsoft-dynamics-crm-2015

    Hope this helps.

  • woodtool Profile Picture
    woodtool 35 on at

    We are currently removing the system jobs so they are not there. The issue is that the RollupJobBase table still has 6.5 million rows and it seems to be running an update on all of those records when the rollup job runs. We would like to get rid of those but not sure if we can just delete the older records or all of them from the table.

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    I think something went wrong with the roll-up field conditions . This is strange in a day 85 k records created and the table you mentioned , seems you can not delete data from there  using bulk deletion functionality , so I would suggest identify the Rollup field which causes data creation and go for some alternate options like workflow or plugin.

  • woodtool Profile Picture
    woodtool 35 on at

    The thing is it's all of our rollup fields. My thought is to delete the fields, delete the data, and then re-add the fields. Or go to the alternate option as you suggested. This issue was supposed to be fixed it 2015 1.1.

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Yes , if the rollup fields create that much records so you should not go with the rollup fields for your current requirement .Make your rollup fields as much as simple and if it's needed hourly basis then I would recommend go with the custom code.

    BTW , is it possible to share the condition of rollup fields here to understand what it contains.

    You may raise ticket to MS if you feel as this is OOB  functionality and you don't have any control for those record creation.

  • woodtool Profile Picture
    woodtool 35 on at

    They're just a count of records in related tables. The count only changes when there's an election so I've turned off the rollup jobs for now but we really need it during election time and that's when we need the system performance too. If my first idea doesn't work I'll put in a ticket.

  • woodtool Profile Picture
    woodtool 35 on at

    So I did drop all of the rollup fields. That automatically cleared out the RollupJobBase table. I added the fields back, same conditions. The mass update ran as well as some incremental rollups. We currently have 0 records in the RollupJobBase table. It seems something was amiss with our current fields. Maybe since they were created prior to the 2015 1.1 update. Thanks for the input.

  • gdas Profile Picture
    gdas 50,091 Moderator on at

    Glad to hear that ! Please don't forget to close the thread verifying any of above useful answers.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans