Apex Code Development You need to sign in to do that
Don't have an account?
sailer NullPointerException: Attempt to de-reference a null object
hello Everyine,
/*#################################
####################################
*/
global class RollUpSummaryMaps implements Database.Batchable<sObject>
{
public list<OpportunityLineItem> opporto { get; private set; }
List<Opportunity> OptyList=new List<Opportunity>();
Opportunity optyupdate= new Opportunity();
public Double curecy=0;
global Database.QueryLocator start(Database.BatchableContext BC)
{
// Access initialState here
String lineitem='SELECT id,ListPrice, OpportunityId, PricebookEntryId FROM OpportunityLineItem';
// Database.ge
System.debug('The Query@@@@@@@@'+lineitem);
return Database.getQueryLocator(lineitem);
}
global void execute(Database.BatchableContext BC,List<Sobject> batch)
{
Map<ID, OpportunityLineItem> iMap = new Map<ID, OpportunityLineItem>([SELECT id,UnitPrice, OpportunityId, PricebookEntryId FROM OpportunityLineItem]);
//List<OpportunityLineItem> lineitem= [SELECT id,UnitPrice, OpportunityId, PricebookEntryId FROM OpportunityLineItem];
system.debug('The LIne Item@@@@@@@@@@@@@@@@@@@@@@'+IMap);
List<Opportunity> optylist= new List<Opportunity>();
optylist=[select Id,testvantage__TrackingNumber__c From Opportunity where Id =:iMap.keySet()]; //Error at this Line like
System.debug('OptyList @@@@@@@@@@@@@@############'+optylist);
if(optylist!=null)
{
for(Id accId:iMap.keySet())
{
for(OpportunityLineItem lineitem:opporto)
{
curecy=lineitem.UnitPrice;
curecy++;
system.debug('TOTAL VALUES OF LIST PRICE@@@@@@@@@@@@@@@@@@'+curecy);
}
optyupdate.testvantage__TrackingNumber__c=+curecy;
OptyList.add(optyupdate);
}
if(OptyList.size()>0)
{
update OptyList;
}
}
}
global void finish(Database.BatchableContext BC){
}
}
Please help me out how to resolve this
Thanks in advance.
Regards
Sailer
Hi,
I suspect the line said by you is pain point. Could you also please paste debug log related to execute method and problem?
All Answers
Hi,
I suspect the line said by you is pain point. Could you also please paste debug log related to execute method and problem?
9.0 APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO 09:19:08.092 (92346000)|EXECUTION_STARTED 09:19:08.092 (92401000)|CODE_UNIT_STARTED|[EXTERNAL]|01p90000000FO3v|testvantage.RollUpSummaryMaps 09:19:08.093 (93574000)|METHOD_ENTRY|[8]|01p90000000FO3v|RollUpSummaryMaps.RollUpSummaryMaps() 09:19:08.093 (93592000)|METHOD_EXIT|[8]|RollUpSummaryMaps 09:19:08.094 (94005000)|SOQL_EXECUTE_BEGIN|[29]|Aggregations:0|select id, UnitPrice, OpportunityId, PricebookEntryId from OpportunityLineItem 09:19:08.095 (95539000)|SOQL_EXECUTE_END|[29]|Rows:2 09:19:08.095 (95691000)|SYSTEM_METHOD_ENTRY|[31]|String.valueOf(Object) 09:19:08.095 (95754000)|ENTERING_MANAGED_PKG| 09:19:08.095 (95840000)|SYSTEM_METHOD_EXIT|[31]|String.valueOf(Object) 09:19:08.095 (95868000)|SYSTEM_METHOD_ENTRY|[31]|System.debug(ANY) 09:19:08.095 (95874000)|ENTERING_MANAGED_PKG| 09:19:08.095 (95884000)|USER_DEBUG|[31]|DEBUG|The LIne Item@@@@@@@@@@@@@@@@@@@@@@{00k90000009rca7AAA=OpportunityLineItem:{OpportunityId=0069000000BGDzVAAX, PricebookEntryId=01u90000004CYIQAA4, Id=00k90000009rca7AAA, UnitPrice=100000.00}, 00k90000009rca8AAA=OpportunityLineItem:{OpportunityId=0069000000BGDzVAAX, PricebookEntryId=01u90000004CYIJAA4, Id=00k90000009rca8AAA, UnitPrice=5000.00}} 09:19:08.095 (95893000)|SYSTEM_METHOD_EXIT|[31]|System.debug(ANY) 09:19:08.095 (95967000)|SYSTEM_CONSTRUCTOR_ENTRY|[33]|<init>() 09:19:08.095 (95976000)|ENTERING_MANAGED_PKG| 09:19:08.096 (96004000)|SYSTEM_CONSTRUCTOR_EXIT|[33]|<init>() 09:19:08.096 (96038000)|SYSTEM_METHOD_ENTRY|[34]|MAP<Id,OpportunityLineItem>.keySet() 09:19:08.096 (96044000)|ENTERING_MANAGED_PKG| 09:19:08.096 (96113000)|SYSTEM_METHOD_EXIT|[34]|MAP<Id,OpportunityLineItem>.keySet() 09:19:08.098 (98262000)|SOQL_EXECUTE_BEGIN|[34]|Aggregations:0|select Id, testvantage__TrackingNumber__c from Opportunity where Id = :tmpVar1 09:19:08.129 (129250000)|SOQL_EXECUTE_END|[34]|Rows:0 09:19:08.129 (129365000)|SYSTEM_METHOD_ENTRY|[35]|String.valueOf(Object) 09:19:08.129 (129374000)|ENTERING_MANAGED_PKG| 09:19:08.129 (129414000)|SYSTEM_METHOD_EXIT|[35]|String.valueOf(Object) 09:19:08.129 (129438000)|SYSTEM_METHOD_ENTRY|[35]|System.debug(ANY) 09:19:08.129 (129444000)|ENTERING_MANAGED_PKG| 09:19:08.129 (129453000)|USER_DEBUG|[35]|DEBUG|OptyList @@@@@@@@@@@@@@############() 09:19:08.129 (129460000)|SYSTEM_METHOD_EXIT|[35]|System.debug(ANY) 09:19:08.129 (129486000)|SYSTEM_CONSTRUCTOR_ENTRY|[39]|<init>() 09:19:08.129 (129490000)|ENTERING_MANAGED_PKG| 09:19:08.129 (129516000)|SYSTEM_CONSTRUCTOR_EXIT|[39]|<init>() 09:19:08.129 (129532000)|SYSTEM_METHOD_ENTRY|[39]|MAP<Id,OpportunityLineItem>.keySet() 09:19:08.129 (129535000)|ENTERING_MANAGED_PKG| 09:19:08.129 (129559000)|SYSTEM_METHOD_EXIT|[39]|MAP<Id,OpportunityLineItem>.keySet() 09:19:08.129 (129581000)|SYSTEM_METHOD_ENTRY|[39]|LIST<Id>.addAll(Object) 09:19:08.129 (129586000)|ENTERING_MANAGED_PKG| 09:19:08.129 (129599000)|SYSTEM_METHOD_EXIT|[39]|LIST<Id>.addAll(Object) 09:19:08.129 (129610000)|SYSTEM_METHOD_ENTRY|[39]|LIST<Id>.iterator() 09:19:08.129 (129613000)|ENTERING_MANAGED_PKG| 09:19:08.129 (129692000)|SYSTEM_METHOD_EXIT|[39]|LIST<Id>.iterator() 09:19:08.129 (129708000)|SYSTEM_METHOD_ENTRY|[39]|system.ListIterator.hasNext() 09:19:08.129 (129736000)|SYSTEM_METHOD_EXIT|[39]|system.ListIterator.hasNext() 09:19:08.129 (129814000)|METHOD_ENTRY|[41]|01p90000000FO3v|testvantage.RollUpSummaryMaps.__sfdc_opporto() 09:19:08.129 (129856000)|METHOD_EXIT|[41]|01p90000000FO3v|testvantage.RollUpSummaryMaps.__sfdc_opporto() 09:19:08.129 (129972000)|FATAL_ERROR|System.NullPointerException: Attempt to de-reference a null object Class.testvantage.RollUpSummaryMaps.execute: line 41, column 1
pl help me out
Hi,
Could you please try below code and see if it runs for you or not.
global class RollUpSummaryMaps implements Database.Batchable<sObject> { public list<OpportunityLineItem> opporto { get; private set; } List<Opportunity> OptyList=new List<Opportunity>(); Opportunity optyupdate= new Opportunity(); public Double curecy=0; global Database.QueryLocator start(Database.BatchableContext BC) { // Access initialState here String lineitem='SELECT id,ListPrice, OpportunityId, PricebookEntryId FROM OpportunityLineItem'; // Database.ge System.debug('The Query@@@@@@@@'+lineitem); return Database.getQueryLocator(lineitem); } global void execute(Database.BatchableContext BC,List<Sobject> batch) { Map<ID, OpportunityLineItem> iMap = new Map<ID, OpportunityLineItem>([SELECT id,UnitPrice, OpportunityId, PricebookEntryId FROM OpportunityLineItem]); //List<OpportunityLineItem> lineitem= [SELECT id,UnitPrice, OpportunityId, PricebookEntryId FROM OpportunityLineItem]; system.debug('The LIne Item@@@@@@@@@@@@@@@@@@@@@@'+IMap); List<Opportunity> optylist= new List<Opportunity>(); //optylist=[select Id,testvantage__TrackingNumber__c From Opportunity where Id =:iMap.keySet()]; //Error at this Line like Map<Id, Opportunity> mapOppty = new Map<Id, Opportunity>([select Id,testvantage__TrackingNumber__c From Opportunity where Id =:iMap.keySet()]); System.debug('OptyList @@@@@@@@@@@@@@############'+optylist); if(mapOppty.size() != null) { for(Id accId:iMap.keySet()) { for(OpportunityLineItem lineitem:opporto) { curecy=lineitem.UnitPrice; curecy++; system.debug('TOTAL VALUES OF LIST PRICE@@@@@@@@@@@@@@@@@@'+curecy); } Id opptyId = iMap.get(accId).OpportunityId; optyupdate = mapOppty.get(opptyId); optyupdate.testvantage__TrackingNumber__c=+curecy; OptyList.add(optyupdate); } if(OptyList.size()>0) { update OptyList; } } } global void finish(Database.BatchableContext BC){ } }Let me know if you have any question.
Hi I am still getting the same error but its at different location at line 44
ot in the above code at these variabke optyupdate.testvantage__TrackingNumber__c=+curecy
Here is the Log ;
29.0 APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO 09:26:49.069 (69091000)|EXECUTION_STARTED 09:26:49.069 (69128000)|CODE_UNIT_STARTED|[EXTERNAL]|01p90000000FO3v|testvantage.RollUpSummaryMaps 09:26:49.070 (70586000)|METHOD_ENTRY|[1]|01p90000000FO3v|RollUpSummaryMaps.RollUpSummaryMaps() 09:26:49.070 (70604000)|METHOD_EXIT|[1]|RollUpSummaryMaps 09:26:49.071 (71067000)|SOQL_EXECUTE_BEGIN|[22]|Aggregations:0|select id, UnitPrice, OpportunityId, PricebookEntryId from OpportunityLineItem 09:26:49.072 (72815000)|SOQL_EXECUTE_END|[22]|Rows:3 09:26:49.072 (72996000)|SYSTEM_METHOD_ENTRY|[24]|String.valueOf(Object) 09:26:49.073 (73086000)|ENTERING_MANAGED_PKG| 09:26:49.073 (73237000)|SYSTEM_METHOD_EXIT|[24]|String.valueOf(Object) 09:26:49.073 (73270000)|SYSTEM_METHOD_ENTRY|[24]|System.debug(ANY) 09:26:49.073 (73278000)|ENTERING_MANAGED_PKG| 09:26:49.073 (73286000)|USER_DEBUG|[24]|DEBUG|The LIne Item@@@@@@@@@@@@@@@@@@@@@@{00k90000009rcajAAA=OpportunityLineItem:{OpportunityId=0069000000BGDzVAAX, PricebookEntryId=01u90000004CYIQAA4, Id=00k90000009rcajAAA, UnitPrice=100000.00}, 00k90000009rf8aAAA=OpportunityLineItem:{OpportunityId=0069000000BGDzVAAX, PricebookEntryId=01u90000004CYIJAA4, Id=00k90000009rf8aAAA, UnitPrice=5000.00}, 00k90000009rf8bAAA=OpportunityLineItem:{OpportunityId=0069000000BGDzVAAX, PricebookEntryId=01u90000004CYIIAA4, Id=00k90000009rf8bAAA, UnitPrice=25000.00}} 09:26:49.073 (73300000)|SYSTEM_METHOD_EXIT|[24]|System.debug(ANY) 09:26:49.073 (73389000)|SYSTEM_CONSTRUCTOR_ENTRY|[26]|<init>() 09:26:49.073 (73403000)|ENTERING_MANAGED_PKG| 09:26:49.073 (73436000)|SYSTEM_CONSTRUCTOR_EXIT|[26]|<init>() 09:26:49.073 (73511000)|SYSTEM_METHOD_ENTRY|[28]|MAP<Id,OpportunityLineItem>.keySet() 09:26:49.073 (73520000)|ENTERING_MANAGED_PKG| 09:26:49.073 (73605000)|SYSTEM_METHOD_EXIT|[28]|MAP<Id,OpportunityLineItem>.keySet() 09:26:49.076 (76193000)|SOQL_EXECUTE_BEGIN|[28]|Aggregations:0|select Id, testvantage__TrackingNumber__c from Opportunity where Id = :tmpVar1 09:26:49.098 (98385000)|SOQL_EXECUTE_END|[28]|Rows:0 09:26:49.098 (98528000)|SYSTEM_METHOD_ENTRY|[29]|String.valueOf(Object) 09:26:49.098 (98535000)|ENTERING_MANAGED_PKG| 09:26:49.098 (98567000)|SYSTEM_METHOD_EXIT|[29]|String.valueOf(Object) 09:26:49.098 (98588000)|SYSTEM_METHOD_ENTRY|[29]|System.debug(ANY) 09:26:49.098 (98593000)|ENTERING_MANAGED_PKG| 09:26:49.098 (98598000)|USER_DEBUG|[29]|DEBUG|OptyList @@@@@@@@@@@@@@############() 09:26:49.098 (98603000)|SYSTEM_METHOD_EXIT|[29]|System.debug(ANY) 09:26:49.098 (98628000)|SYSTEM_METHOD_ENTRY|[30]|MAP<Id,Opportunity>.size() 09:26:49.098 (98632000)|ENTERING_MANAGED_PKG| 09:26:49.098 (98657000)|SYSTEM_METHOD_EXIT|[30]|MAP<Id,Opportunity>.size() 09:26:49.098 (98681000)|SYSTEM_CONSTRUCTOR_ENTRY|[33]|<init>() 09:26:49.098 (98684000)|ENTERING_MANAGED_PKG| 09:26:49.098 (98705000)|SYSTEM_CONSTRUCTOR_EXIT|[33]|<init>() 09:26:49.098 (98717000)|SYSTEM_METHOD_ENTRY|[33]|MAP<Id,OpportunityLineItem>.keySet() 09:26:49.098 (98720000)|ENTERING_MANAGED_PKG| 09:26:49.098 (98742000)|SYSTEM_METHOD_EXIT|[33]|MAP<Id,OpportunityLineItem>.keySet() 09:26:49.098 (98761000)|SYSTEM_METHOD_ENTRY|[33]|LIST<Id>.addAll(Object) 09:26:49.098 (98765000)|ENTERING_MANAGED_PKG| 09:26:49.098 (98777000)|SYSTEM_METHOD_EXIT|[33]|LIST<Id>.addAll(Object) 09:26:49.098 (98787000)|SYSTEM_METHOD_ENTRY|[33]|LIST<Id>.iterator() 09:26:49.098 (98789000)|ENTERING_MANAGED_PKG| 09:26:49.098 (98883000)|SYSTEM_METHOD_EXIT|[33]|LIST<Id>.iterator() 09:26:49.098 (98907000)|SYSTEM_METHOD_ENTRY|[33]|system.ListIterator.hasNext() 09:26:49.098 (98939000)|SYSTEM_METHOD_EXIT|[33]|system.ListIterator.hasNext() 09:26:49.099 (99077000)|SYSTEM_METHOD_ENTRY|[35]|LIST<OpportunityLineItem>.iterator() 09:26:49.099 (99088000)|ENTERING_MANAGED_PKG| 09:26:49.099 (99367000)|SYSTEM_METHOD_EXIT|[35]|LIST<OpportunityLineItem>.iterator() 09:26:49.099 (99402000)|SYSTEM_METHOD_ENTRY|[35]|system.ListIterator.hasNext() 09:26:49.099 (99424000)|SYSTEM_METHOD_EXIT|[35]|system.ListIterator.hasNext() 09:26:49.099 (99455000)|SYSTEM_METHOD_ENTRY|[41]|MAP<Id,OpportunityLineItem>.get(Object) 09:26:49.099 (99460000)|ENTERING_MANAGED_PKG| 09:26:49.099 (99488000)|SYSTEM_METHOD_EXIT|[41]|MAP<Id,OpportunityLineItem>.get(Object) 09:26:49.099 (99541000)|SYSTEM_METHOD_ENTRY|[42]|MAP<Id,Opportunity>.get(Object) 09:26:49.099 (99546000)|ENTERING_MANAGED_PKG| 09:26:49.099 (99566000)|SYSTEM_METHOD_EXIT|[42]|MAP<Id,Opportunity>.get(Object) 09:26:49.099 (99712000)|FATAL_ERROR|System.NullPointerException: Attempt to de-reference a null object Class.testvantage.RollUpSummaryMaps.execute: line 44, column 1Hi,
Sorry was on Paternity Leave. :)
Is it fixed for you or not?
Could you please try:-
optyupdate.testvantage__TrackingNumber__c+=curecy;
Let me know if you still have problem.