Rollup Helper

The support knowledge base says "max number of records to process each batch with RollupHelper is 20,000".  

Because we are super paranoid, before we move forward with the purchase, we want to get full confirmation on:  

Is this 20,000 in any one batch or as a whole for roll-ups in the same object, even if they are broken up into separate batches?

We have a field on opportunity called "Active__c" which is defined as 

NOT( IsClosed ) || 

(IsClosed && IsWon && Campaign_End_Date__c <= ADDMONTHS(TODAY(), 12) && Campaign_End_Date__c>TODAY()) 

We can't use a standard rollup summary field since active__c is defined in terms of a dynamic date 

We use rollup helper to count the number of active opportunities, but it's currently taking an estimated 1 week and 6 days to run the job over about 200,000 accounts, which makes ROS basically useless. 

Any suggestions?

Hi Community,  

I'm creating a new rollup that's based on another rollup field.  

Has anyone had this use case before? Any limitations you have faced? or inconsistent results? 

Thank you for your feedback! 

Best, 

Gonçalo 

I am having all sorts of issues trying to access the Rollup helper tabs. The page keeps giving me the following error. 

SObject row was retrieved via SOQL without querying the requested field: rh2__HS_Filter__c.rh2__Condition__c 

Has anyone seen this error before?

I want to delete 30 inactive rollups.  I thought they were stored in the rh2__PS_Rollup_Audit__c object and I deleted them, but in the UI when I go to All Rollups, the inactive rollups are still there.  How can I mass delete them completely?

trigger RHX_Investments on Investments__c 

    (after delete, after insert, after undelete, after update, before delete) { 

         Type rollClass = System.Type.forName('rh2', 'ParentUtil'); 

        if(rollClass != null) { 

              rh2.ParentUtil pu = (rh2.ParentUtil) rollClass.newInstance(); 

         if (trigger.isAfter) { 

                        pu.performTriggerRollups(trigger.oldMap, trigger.newMap, new String[]{'Investments__c'}, null); 

     } 

    } 

}

Failed to process Queueable job for class rh2.PS_QueueableRollup for job ID 707P100001GgrsB.
caused by: System.LimitException: rh2:Too many query rows: 50001
Class.rh2.PS_SOQL_Aggregate_Functions.rollUp: line 131, column 1
Class.rh2.PS_Rollup_Context.runThroughSOQLAFIfNecessary: line 597, column 1
Class.rh2.PS_Rollup_Context.processSOQLAggregateFunctionRollups: line 562, column 1
Class.rh2.PS_Rollup_Context.run: line 483, column 1
Class.rh2.PS_Rollup_Helper.rollupToParent: line 76, column 1
Class.rh2.PS_Rollup_Helper.<init>: line 55, column 1
Class.rh2.PS_Rollup_Helper.<init>: line 45, column 1
Class.rh2.PS_Asynchronous_Job_Handler.executeQueueableOrFuture: line 242, column 1
Class.rh2.PS_QueueableRollup.execute: line 23, column 1

I have:

• Selected  the checkbox Enable Validation Rule Helper
• Added ‘ &&   $Setup.rh2__PS_Settings__c.rh2__Run_Validation_Rule__c’  to all of my Validation Rule

We still are getting many validation rule errors that are "breaking' our rollups. Are there any next steps that I can take? 

Is anyone using Rollup Helper's 'Enable Validation Rule Helper' flag?

Great to see this feature exists... but I can't get it to work.

The idea is that Rollup Helper should be able to update records without triggering your standard validation rules. To enable the feature, I have ticked 'Enabled Validation Rule Helper' checkbox in the custom setting and, as instructed, added the criteria '$Setup.rh2__PS_Settings__c.rh2__Run_Validation_Rule__c' to my validation rules on Account. (Just to add, I have also left 'Run Validation Rule' ticked in the custom setting as this is what the helptext says to do.)

But I can see from the Exceptions that Rollup Helper is still triggering validation rules.

Any tips on what I need to tweak to get this feature to work?

Edit: I am using the free version of RH in case this is relevant.

Hi All, 

I'm receiving this error when trying to deploy the RHX_Opportunity and RHX_TEST_Opportunity apex triggers, and I am skipping run all other tests other than the test for the trigger. Here is the error: 

"Methods defined as TestMethod do not support Web service callouts Stack Trace: null" 

This error is stemming from the RHX_TEST_Opportunity class. 

Any help here would be appreciated.