Apex Code Development You need to sign in to do that
Don't have an account?
KMK91 Too many SOQL queries: 101
Hi,
when we trying to open the opportunity we are getting below error . can you please suggest here
Too many SOQL queries: 101
An unexpected error has occurred. Your development organization has been notified.
Thanks
KMK
when we trying to open the opportunity we are getting below error . can you please suggest here
Too many SOQL queries: 101
An unexpected error has occurred. Your development organization has been notified.
Thanks
KMK
Greetings to you!
The following error appears when you exceed the Execution Governors Limit (you can run up to a total 100 SOQL queries in a single call or context): https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm
To fix the issue, change your code so that the number of SOQL fired is less than 100.
If you need to change the context, you can use @future annotation which will run the code asynchronously.
Best practices to avoid exceeding the Governors Limit:
Since Apex runs on a multi-tenant platform, the Apex runtime engine strictly enforces limits to ensure code doesn't monopolize shared resources.
Reference: https://help.salesforce.com/articleView?id=000181404&type=1
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.
Thanks and Regards,
Khan Anas
All Answers
Greetings to you!
The following error appears when you exceed the Execution Governors Limit (you can run up to a total 100 SOQL queries in a single call or context): https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm
To fix the issue, change your code so that the number of SOQL fired is less than 100.
If you need to change the context, you can use @future annotation which will run the code asynchronously.
Best practices to avoid exceeding the Governors Limit:
Since Apex runs on a multi-tenant platform, the Apex runtime engine strictly enforces limits to ensure code doesn't monopolize shared resources.
Reference: https://help.salesforce.com/articleView?id=000181404&type=1
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.
Thanks and Regards,
Khan Anas
If this error is occurring for the whole page then most probably the view action on the opportunity has been overridden with a visualforce page that is returning this error. If this a production issue. I would recommend removing the override for now and debug the visualforce page.
If this error is occurring for a part of the page, then check the opportunity page layout. For the inline visualforce page on which this error is occurring.
As for the error(Too many SOQL queries: 101), it is a standard error that occurs when you exceed the Governor limits imposed by Salesforce. You can find the details by googling. Most probably you have a SOQL query inside a for loop.