You need to sign in to do that
Don't have an account?
Case Age In Business Hours
Hello,
Anyone using Case Age In Business Hours package from appexchange is having problems with Email2Case?
We're getting a lot of errors because of too many SQL queries...
Thank you for any help!
2009-09-23 13:45:36,770 145373 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:0: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:1: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:2: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:3: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:4: CalculateBusinessHoursAges: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] INFO com.sforce.mail.GenericClient - Copying 5 messages to error mailbox
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:0 ID=02s20000002VbynAAC Success=true
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:1 ID=02s20000002VbyoAAC Success=true
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:2 ID=02s20000002Vc2DAAS Success=true
Error is in this line:
for (CaseStatus status:[Select MasterLabel From CaseStatus where IsClosed=true]) { closedStatusSet.add(status.MasterLabel); }
Anyone found a solution for this? It also appears to happen when you have a trigger set up on the Email Message object. My error is similar...
Developer script exception : LastEmailDateTime : LastEmailDateTime: execution of AfterInsert caused by: System.Exception: Too many SOQL queries: 22 Trigger.LastEmailDateTime: line 7, column 23