I receive the error message "duplicate field selected: npsp__Batch_Number__c" every day and I believe it is affecting my orgs rollup field calculations. (Full error message below.)
Support identified a similarly named field in the Opp object which they believe to be the culprit; it's API name is Batch_Number__c. I tried, unsuccessfully, to reproduce this error in a sandbox for the purpose of testing Support's solution (renaming the custom field API name.)
Do you have any recommendations for how I can proceed to resolve this?
Error message:
Failed to invoke future method 'public static void runFuture(Set<Id>, Set<Id>, String, String, String)' on class 'npsp.TDTM_Runnable' for job id '7077V0000D3d7WO'
caused by: System.QueryException: duplicate field selected: npsp__Batch_Number__c
Class.npsp.TDTM_Runnable.runFuture: line 98, column 1
Hi @Matthew Hach, based on the error message which you have shared, you might be using the same field twice in the SOQL query. Can you cross check the query once?
As a reference you can refer the below links it might help you.
https://help.salesforce.com/s/articleView?id=000383173&type=1
https://help.salesforce.com/s/articleView?id=000393144&type=1
