RollupJob vs calculate errors

[wes1278]

Andrew,

We're running into a weird error with some scheduled jobs. This is on the financial force object model. We're trying to rollup parent milestones to phases and then phases to projects. When we run the RollupJob, we get an error that says :"Invalid Id for pse__Project_Phase__c"; However, when we run the RollupCalculateJob, it seems to work without any issues.

Any idea what might be going on?

Some other background info:

• We tried to have these all as realtime, but it says we were causing too many rollups or something related to the # of objects in the chain. Due to having timecard rollup to child milestone, rollup to parent milestone, rollup to phase, rollup to project. So, we tried to break out the last 2 levels into scheduled jobs.
• Clicking the calculate button seems to work.

[afawcett]

This is the Stack Trace I'm getting for this exception, it's from the job as well, are you seeing any failures when you look at Apex Jobs at your end...

Apex script unhandled exception by user/organization:

Failed to process batch for class 'dlrs.RollupJob' for job id '707a0000012LuaS'

caused by: System.SObjectException: Invalid Id for pse__Project_Phase__c

Class.dlrs.LREngine.rollUp: line 78, column 1
Class.dlrs.RollupService.processScheduleItems: line 282, column 1
Class.dlrs.RollupJob.execute: line 48, column 1

[afawcett]

Sorry I see what you mean, this only occurs in the RollupJob (the scheduled job) and not the RollupCalculateJob got it. I've not got a lot of time this weekend, well not any actually to focus on this, sorry, but hopefully the stack trace helps. Other thing, would be to deploy unmanaged into the sandbox (via the Deploy To Salesforce link) to reproduce and debug further that way. You can then call the RollupService.processScheduleItems directly from execute annonymous as well, make it easier.

[dnakov]

@afawcett Thanks. I'll try to figure it out. I was just going to call RollupCalculateJob from a batch job, but unfortunately it's not global. Probably going to end up in the pull request.

[afawcett]

Have you been able to make any progress on this? Do you want me to try and take a look, i may have some time next week if so.

[dnakov]

@afawcett I ended up creating a crappy little batch job that works off the LookupRollupSummary object using group by's. Had to move on to other things like usual. https://gist.github.com/dnakov/404afc2ced4f6683bc7f

[afawcett]

Ok @dnakov no worries i understand, thanks for sharing your workaround though! 👍

[afawcett]

FYI, i have now got a handle on this error here, fixing it now!