Error on some Ultimate Parent Rollups

[fabm97]

Hey,

we recently discovered some of our rollups failing due to a query issue:

Failed to process batch for class 'RollupFullBatchRecalculator' for job id '7071v0000Ao1GcR'

caused by: System.QueryException:
SELECT Id,AdjustedCCId__c,Meter__c,Is_Valid__c,CurrencyIsoCode
                                ^
ERROR at Row:1:Column:33
No such column 'Parent_Meter__c' on entity 'Meter2GenerationUnitRelationship__c'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.

Class.RollupRelationshipFieldFinder.retrieveAdditionalCalcItems: line 540, column 1

The field Parent_Meter__c only exists on the Lookup Object "Meter" and as I understand it should normally also only be queried from Meter__c and not the Calc Item Object Meter2GenerationUnitRelationship__c.

The error only happens on our production system and not on any test system (all systems are on 1.4.7) although the Rollup Metadata Record is the same. I'd guess this may be an error happening only with specific data constellation, as it also only occurs in 2 of 70 batches of the Rollup Recalculation.
The metadata record looks like this:

I hope you can maybe help us figure this out, because I think this may be some general bug in Apex Rollup.
(Edit: Created as issue by accident, moved it now into discussion)

[jamessimone]

@fabm97 thanks for reporting this - I’m also ok with it being logged as an issue; even if it doesn’t happen every time, I’ve seen the error emails for this come through often enough to be convinced it’s some edge case worth tracking down. I will try to reproduce the issue.

[fabm97]

@jamessimone As you might have already seen from the Exception Emails, we are getting the error again on our Org. There haven't been any changes made to the Rollup Metadata or the Apex Rollup Version. So I am still clueless as to what may cause this, but I can say the Error doesn't seem to be fixed yet :)

[jamessimone]

@fabm97 good to know! And this is on the latest version?

[fabm97]

@jamessimone Oh no, we are still on 1.4.7, I will update to the newest version and let you know if the error persists :)

[fabm97]

@jamessimone It seems the Error is fixed with version 1.5.3 :) Thanks for your help!
However we now seem to have a new issue:
`Failed to process Queueable job for class RollupAsyncProcessor for job ID 7071v0000Az7nyY.

caused by: System.SObjectException: SObject row was retrieved via SOQL without querying the requested field: Meter2GenerationUnitRelationship__c.AdjustedCCId__c

Class.RollupCalculator.StringRollupCalculator.handleConcat: line 870, column 1
Class.RollupCalculator.performRollup: line 210, column 1
Class.RollupAsyncProcessor.getCalculator: line 1168, column 1
Class.RollupAsyncProcessor.getUpdatedLookupItemsByRollup: line 1048, column 1
Class.RollupAsyncProcessor.process: line 611, column 1
Class.RollupAsyncProcessor.QueueableProcessor.execute: line 455, column 1`

The metadata Type looks like this:

It is started from an Apex Trigger on the Meter2GenerationUnit Object

[jamessimone]

@fabm97 I've created #312 to track this issue for you!