Microsoft Dynamics 365 | Integration, Dataverse...

Roll up columns not recalculating and status stuck on "Waiting for a timer"

(5) Share

Report

Posted on by HFG

Hi all,

I have an issue that I have seen other posts about but have not yet found an explanation or resolution. Here is the situation :

We have 3 tables with roll up columns

There are 56 columns in total in the solution (17, 24 and 15 in the tables) - I have seen conflicting information about what the limit is, one MS Learn page says 10 per table, another more recent page says 50.

Recently we noticed that the roll up columns were no longer calculating automatically

The lines which have had a record created in a child table seemed to calculate but the other lines show a null value

Yesterday we modified all of the roll up columns to add a filter and this forced the calculation. However, the lines which were created today do not have any information - see screenshot.

The lines in the parent tables are created by a dataflow connected to an SQL view. The lines in the child tables are created by the users and dataflows.

When checking the system jobs, we see that the status of the calculation is stuck on "Waiting for a timer".

If we relaunch the system job, the status changes to "Waiting for resources" and then returns to "Waiting for a timer".

Can anyone help ?

Thanks

Capture d’écran 2...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Dynamics 365 general

Power Platform integration

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Asmaa Bouhmidi 173 on at

Like (1)

Report

Hello, You can create up to 50 rollup columns per table and up to 200 per environment, so you should be fine on that front.

Rollup columns are calculated automatically every hour. If they are stuck, it may be because there are too many system jobs in the queue, which can delay the calculations. There might be a platform limit, although I haven't found anything specific about this in the documentation—except for a note about using time-bound functions like Now() and IsUTCToday().

In your case, I would suggest creating a Power Automate flow to refresh the calculation for the columns that are failing to recalculate automatically.

check this article on how to create the Power Automate flow https://mytrial365.com/2022/09/02/force-rollup-field-calculation-using-power-automate/

Was this reply helpful? Yes No
HFG 34 on at

Like (1)

Report

Hi @Asmaa Bouhmidi,

Thanks for your reply and the information on forcing re-calculation. Ideally we would like to understand what is going on and what is meant by "waiting for timer" to see if we can unblock the automatic calculation.

Thanks for confirming the limits, as you say, it seems this shouldn't be the reason it's blocking.

Was this reply helpful? Yes No