The apex class E2CP.ProcessMessage failed due to: System.LimitException: Too many SOQL queries: 101
You are using Email to Case Premium and have received an error email similar to the following:
An error occured while trying to deliver the attached email. You may wish to report the following information to the owner of email@example.com. The apex class E2CP.ProcessMessage failed due to: System.LimitException: Too many SOQL queries: 101 The attached email could not be processed because the Apex class E2CP.ProcessMessage failed. System.LimitException: Too many SOQL queries: 101 Class.XXXXXXXXXX Trigger.XXXXXXXXXX
Salesforce governor limits currently allow up to 100 SOQL queries per transaction per namespace. Additional documentation on governor limits can be found here.
As the first step in troubleshooting this error, check the stack trace at the bottom of the error email to see which Apex Classes / Triggers were last executed when the SOQL query limit was exceeded.
Apex Classes and Triggers can be located via Setup > Develop. After locating the Apex Classes / Triggers which match the error message, first check to see if they are associated with a managed package by looking for the envelope symbol with the blue arrow pointing down next to the Class / Trigger name. Once they are located, check the Last Modified By field to see when the code was last modified and by whom.
Note: Internet Creations support cannot assist with governor limit errors caused by code running outside of what comes packaged with Email to Case Premium. However if you require further assistance with updating the SOQL query logic within your local code, please contact your Internet Creations Account Executive to inquire about professional services.