Apex Code Development You need to sign in to do that
Don't have an account?
BdavisBOKF AccountID not available on Event during delete trigger Winter 13
I have a trigger that is updating a field to track the last event date. This code currently works in Summer 12 and worked last week in Winter 13.We only have basic support so the help desk was not helpful. This is in spite of the fact that this is clearly a Winter 13 release issue.
Next post has the debug log.
trigger EventInsertUpdate on Event (before insert, before update, after insert, after update, after delete) {
if(! trigger.isDelete && trigger.IsBefore){
for(Event e : Trigger.new) {
// If the Event Type (Reporting) field does not contain
// the picklist value of the field Type, populate it with that
// picklist value from Type.
if(e.Event_Type_Reporting__c != e.Type && Trigger.IsBefore) {
e.Event_Type_Reporting__c = e.Type;
}
}
}
// Before triggers can just get out. The rest is after only.
if(trigger.IsBefore) return;
// Put account ids for deleted records in array.
List <Id> acctsIDList = new List<Id>();
if(trigger.isDelete){
for(Event e : Trigger.old){
System.Debug('This is the event in delete' + [Select AccountID, ID, ActivityDateTime From Event Where ID = :e.ID ALL ROWS]);
if(e.AccountId != null){
acctsIDList.add(e.AccountId);
}
}
} else {
for(Event e : Trigger.new){
if(e.AccountId != null){
acctsIDList.add(e.AccountId);
}
}
}
System.Debug('The acctsIDList size is:' + acctsIDList.size());
if(acctsIDList.isEmpty()) return;
// Now update the LastEventDate for all accounts if necessary
Map<Id, Account> acctsMap = new Map<Id, Account>([SELECT Id, OwnerId, LastEventDate__c,
Owner_Last_Activity_Date__c
FROM Account
WHERE Id in :acctsIdList]);
System.Debug('The acctsMap size is:' + acctsMap.size());
if(acctsMap.values().size() > 0) AccountUtil.UpdateActivityDates(acctsMap);
}
Her is the debug log
18.0 APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO
15:05:18.372 (372132000)|EXECUTION_STARTED
15:05:18.372 (372179000)|CODE_UNIT_STARTED|[EXTERNAL]|01q70000000L0Cg|EventInsertUpdate on Event trigger event AfterDelete for [00UV00000019BzN]
15:05:18.373 (373564000)|SYSTEM_CONSTRUCTOR_ENTRY|[26]|<init>()
15:05:18.373 (373610000)|SYSTEM_CONSTRUCTOR_EXIT|[26]|<init>()
15:05:18.373 (373768000)|SYSTEM_METHOD_ENTRY|[29]|LIST<Event>.iterator()
15:05:18.374 (374145000)|SYSTEM_METHOD_EXIT|[29]|LIST<Event>.iterator()
15:05:18.374 (374173000)|SYSTEM_METHOD_ENTRY|[29]|system.ListIterator.hasNext()
15:05:18.374 (374202000)|SYSTEM_METHOD_EXIT|[29]|system.ListIterator.hasNext()
15:05:18.374 (374523000)|SOQL_EXECUTE_BEGIN|[30]|Aggregations:0|select AccountID, ID, ActivityDateTime from Event where ID = :tmpVar1 all rows
15:05:18.378 (378563000)|SOQL_EXECUTE_END|[30]|Rows:1
15:05:18.378 (378690000)|SYSTEM_METHOD_ENTRY|[30]|String.valueOf(Object)
15:05:18.378 (378762000)|SYSTEM_METHOD_EXIT|[30]|String.valueOf(Object)
15:05:18.378 (378795000)|SYSTEM_METHOD_ENTRY|[30]|System.debug(ANY)
15:05:18.378 (378802000)|USER_DEBUG|[30]|DEBUG|This is the event in delete(Event:{ActivityDateTime=2012-11-29 21:00:00, Id=00UV00000019BzNMAU})
15:05:18.378 (378808000)|SYSTEM_METHOD_EXIT|[30]|System.debug(ANY)
15:05:18.378 (378873000)|SYSTEM_METHOD_ENTRY|[29]|system.ListIterator.hasNext()
15:05:18.378 (378898000)|SYSTEM_METHOD_EXIT|[29]|system.ListIterator.hasNext()
15:05:18.378 (378942000)|SYSTEM_METHOD_ENTRY|[42]|LIST<Id>.size()
15:05:18.379 (379001000)|SYSTEM_METHOD_EXIT|[42]|LIST<Id>.size()
15:05:18.379 (379014000)|SYSTEM_METHOD_ENTRY|[42]|String.valueOf(Object)
15:05:18.379 (379023000)|SYSTEM_METHOD_EXIT|[42]|String.valueOf(Object)
15:05:18.379 (379032000)|SYSTEM_METHOD_ENTRY|[42]|System.debug(ANY)
15:05:18.379 (379036000)|USER_DEBUG|[42]|DEBUG|The acctsIDList size is:0
15:05:18.379 (379041000)|SYSTEM_METHOD_EXIT|[42]|System.debug(ANY)
15:05:18.379 (379055000)|SYSTEM_METHOD_ENTRY|[43]|LIST<Id>.isEmpty()
15:05:18.379 (379083000)|SYSTEM_METHOD_EXIT|[43]|LIST<Id>.isEmpty()
15:05:18.967 (379117000)|CUMULATIVE_LIMIT_USAGE
15:05:18.967|LIMIT_USAGE_FOR_NS|(default)|
Number of SOQL queries: 1 out of 100
Number of query rows: 1 out of 50000
Number of SOSL queries: 0 out of 20
Number of DML statements: 0 out of 150
Number of DML rows: 0 out of 10000
Number of script statements: 7 out of 200000
Maximum heap size: 0 out of 6000000
Number of callouts: 0 out of 10
Number of Email Invocations: 0 out of 10
Number of fields describes: 0 out of 100
Number of record type describes: 0 out of 100
Number of child relationships describes: 0 out of 100
Number of picklist describes: 0 out of 100
Number of future calls: 0 out of 10
15:05:18.967|CUMULATIVE_LIMIT_USAGE_END
15:05:18.379 (379166000)|CODE_UNIT_FINISHED|EventInsertUpdate on Event trigger event AfterDelete for [00UV00000019BzN]
15:05:18.379 (379174000)|EXECUTION_FINISHED