Apex Code Development You need to sign in to do that
Don't have an account?
Avinash Nelluri Weird Too many SOQL queries exception
Hello All,
I came across a very weird issue. In my test method, I'm running into a too many soql queries exception before even setting up my test data for a use case. So, I've moved Test.startTest() little bit upwards before the line causing 101th query hoping startTest() method will reset the limits. Surprisingly, it was still running into the same too many soql exceptions. So, I put a debug log to get total soql queries before the line that's causing the error. This time, with the debug, it doesn't throw any error. If I remove the debug, then it will run into too many soql queries.
My code:
insert somList;//This is the point I hit my 100th query. So the next query will be 101th.
System.debug(logginglevel.error, '***SOQL Count 1***'+limits.getQueries());//The debug prints 100.
Test.startTest();
System.debug(logginglevel.error, '***SOQL Count 2***'+limits.getQueries());// This debug is doing magic. If I put the debug, queries count resets. Otherwise it doesn't
List<Account> listAcnts= [SELECT ID, Name FROM Account WHERE xxxxx];//This would be the 101th query if there is no startTest() above.
Any thoughts?
Thanks,
Avinash.
I came across a very weird issue. In my test method, I'm running into a too many soql queries exception before even setting up my test data for a use case. So, I've moved Test.startTest() little bit upwards before the line causing 101th query hoping startTest() method will reset the limits. Surprisingly, it was still running into the same too many soql exceptions. So, I put a debug log to get total soql queries before the line that's causing the error. This time, with the debug, it doesn't throw any error. If I remove the debug, then it will run into too many soql queries.
My code:
insert somList;//This is the point I hit my 100th query. So the next query will be 101th.
System.debug(logginglevel.error, '***SOQL Count 1***'+limits.getQueries());//The debug prints 100.
Test.startTest();
System.debug(logginglevel.error, '***SOQL Count 2***'+limits.getQueries());// This debug is doing magic. If I put the debug, queries count resets. Otherwise it doesn't
List<Account> listAcnts= [SELECT ID, Name FROM Account WHERE xxxxx];//This would be the 101th query if there is no startTest() above.
Any thoughts?
Thanks,
Avinash.
https://success.salesforce.com/issues_view?id=a1p30000000T5R5AAK
All Answers
https://success.salesforce.com/issues_view?id=a1p30000000T5R5AAK