**Issue with Intermittent Execution of Lookup Rollup Scheduler**

[nagasharmila-cg]

Description:

We have a field in the Opportunity object that performs a rollup action based on specific criteria from child records and populates the field. This rollup process is scheduled to run daily. Similar rollup actions exist for other fields as well.

The issue is that the scheduler does not always execute as expected and stops running intermittently. However, when we manually delete the Lookup Rollup Calculate job record associated with the rollup action and re-execute it, it works perfectly for the same record. This behavior occurs randomly across different Lookup Rollup items and intervals. Additionally, no errors are logged for this issue.

I noticed that the Lookup Rollup Scheduled Full Calculate Next Date is set to 2/2/2025 12:00 AM for a Lookup Rollup item, which is in the past.

Expected Behavior:
The job should run daily as scheduled and accurately calculate values based on the given criteria.

[aheber]

@nagasharmila-cg this isn't much to work with.

What version of DLRS are you using?

Does the scheduled job execute multiple batches?

Does the scheduled job have any criteria to limit the scope of parent records?

Are any Log entries created on the Lookup Rollup Summary Logs object?

How often do you see it failing to rollup? Does it happen after a consistent number of days?

Does the job ever recover on it's own when it gets in this perpetual failure state?

If you look at the scheduled job using the Setup menu do you see the job and does it have a future next run date?

I'm not aware of any issues with long running scheduled jobs failing to process and being recovered by rescheduling.

[nagasharmila-cg]

Hi @aheber

#1 Current Version: 2.17
#2 Yes, it is currently executing around 300+ jobs.
#3 No logs have been created recently, and we don't find any errors in the Apex jobs either.
#4 & #5 We couldn't track the frequency. Previously, we faced this issue with another field, and we executed the full calculation to fix it. Currently, we don't have detailed information about it.
#6 Yes, the next scheduled run is next month. It runs during the 1st week of every month to recalculate the values. However, for the current month, although it showed as executed, the values were not calculated. When I deleted the lookup calculate job record for the formula and executed the full calculation manually, it worked again without making any changes to the records.