Too Many SOQL Queries error

Question

I am coming into this problem in my debug logs. But when I'm reviewing the logs I am only seeing individual reads of SOQL query counts from various apps such as :

Number of SOQL queries: 5 out of 100

And I have Flows running - but I don't see a cumulative count on the SOQL query limits - just all of the sudden this :

EXCEPTION_THROWN|[EXTERNAL]|System.LimitException: Too many SOQL queries: 101

I would like to determine what is running up the query count, but I don't see where it's building up.

Also - are Workflow Rules and Validation Rules capable of running up a query count ? I see tons of those kicking off in my debugs. I didn't know if certain commands within a WF Rule or Validation Rule were capable of being regarded as a "query" call.

FURTHER TROUBLESHOOTING SOQL QUERIES COUNT BUILDUP :

16:29:59.677 (2685985805)|WF_FLOW_ACTION_DETAIL|09L5A0000000EPa|[CM Account: CM_ACCT-000153 a7d170000004EtD]|Id=09L5A0000000EPa|CurrentRule:CM_Agreement_Acct_Post_Edit3015A0000006yjd (Id=01Q5A000000iV4m)
16:29:59.677 (2686286560)|WF_FLOW_ACTION_DETAIL|Param Name: myVariable_current, Param Value: ENCODED:{![treatNullAsNull]{!ID:this}}, Evaluated Param Value: {Entity type: Service_Account__c, id: a7d170000004EtDAAU}|Param Name: myVariable_old, Param Value: {!old}, Evaluated Param Value: {Entity type: Service_Account__c, id: a7d170000004EtDAAU}
16:29:59.805 (2805328508)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|17|100
16:29:59.805 (2805507521)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|18|100
16:29:59.805 (2807466011)|LIMIT_USAGE|[EXTERNAL]|SOQL_ROWS|9|50000
16:29:59.805 (2807491103)|LIMIT_USAGE|[EXTERNAL]|SOQL|8|100
16:29:59.805 (2807499967)|LIMIT_USAGE|[EXTERNAL]|AGGS|8|300
16:29:59.805 (2851683030)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|19|100
16:29:59.805 (2851745535)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|20|100
16:29:59.805 (2860995931)|LIMIT_USAGE|[EXTERNAL]|SOQL_ROWS|10|50000
16:29:59.805 (2861038255)|LIMIT_USAGE|[EXTERNAL]|SOQL|9|100
16:29:59.805 (2861047441)|LIMIT_USAGE|[EXTERNAL]|AGGS|9|300
16:29:59.805 (2928997185)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|21|100
16:29:59.805 (2929164971)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|22|100
16:29:59.805 (2935428203)|LIMIT_USAGE|[EXTERNAL]|SOQL_ROWS|11|50000
16:29:59.805 (2935455068)|LIMIT_USAGE|[EXTERNAL]|SOQL|10|100
16:29:59.805 (2935464855)|LIMIT_USAGE|[EXTERNAL]|AGGS|10|300
16:29:59.805 (2962331811)|LIMIT_USAGE|[EXTERNAL]|DML|5|150
16:29:59.805 (2962370715)|LIMIT_USAGE|[EXTERNAL]|DML_ROWS|5|10000
16:29:59.970 (2970476238)|CODE_UNIT_STARTED|[EXTERNAL]|Validation:Service_Account:a7d170000004EtD
16:29:59.970 (2970504812)|VALIDATION_RULE|03d5A000000Jjlm|CannotHaveBothDepositAndLoanEntered
16:29:59.970 (2970609336)|VALIDATION_FORMULA|AND(ISBLANK(Account__c) = FALSE,ISBLANK(Loan_Account__c) = FALSE)|Account__c=a0J3100000MWhmM , Loan_Account__c=null
16:29:59.970 (2970618759)|VALIDATION_PASS
16:29:59.970 (2970623209)|VALIDATION_RULE|03d5A0000007vjh|RDC_Nickname_Required
16:29:59.970 (2970693403)|VALIDATION_FORMULA|AND(To_be_used_with_RDC__c = TRUE,  ISBLANK( Account_Nickname__c ) = TRUE)|Account_Nickname__c=null , To_be_used_with_RDC__c=0
16:29:59.970 (2970700220)|VALIDATION_PASS
16:29:59.970 (2970709214)|CODE_UNIT_FINISHED|Validation:Service_Account:a7d170000004EtD
16:29:59.805 (3025055647)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|23|100
16:29:59.805 (3025121258)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|24|100
16:29:59.805 (3032758764)|LIMIT_USAGE|[EXTERNAL]|SOQL_ROWS|12|50000
16:29:59.805 (3032788476)|LIMIT_USAGE|[EXTERNAL]|SOQL|11|100
16:29:59.805 (3032798893)|LIMIT_USAGE|[EXTERNAL]|AGGS|11|300
16:29:59.805 (3076818737)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|25|100
16:29:59.805 (3076882049)|LIMIT_USAGE|[EXTERNAL]|FIELDSETS_DESCRIBES|26|100
16:29:59.805 (3081120031)|LIMIT_USAGE|[EXTERNAL]|SOQL_ROWS|17|50000
16:29:59.805 (3081148655)|LIMIT_USAGE|[EXTERNAL]|SOQL|12|100
16:29:59.805 (3081158401)|LIMIT_USAGE|[EXTERNAL]|AGGS|12|300
16:29:59.805 (3116645211)|LIMIT_USAGE|[EXTERNAL]|DML|6|150
16:29:59.805 (3116678432)|LIMIT_USAGE|[EXTERNAL]|DML_ROWS|6|10000

Thank you.

Answer 1

I am coming into this problem in my debug logs. But when I'm reviewing the logs I am only seeing individual reads of SOQL query counts from various apps such as...

I would like to determine what is running up the query count, but I don't see where it's building up.

Set Profiling to FINEST in your debug logs, and you will get specific queries, where they are located, and how many times they executed. In the Developer Console, go to Debug > Change Log Levels... and set your active trace flags so that Profiling is FINEST.

And I have Flows running - but I don't see a cumulative count on the SOQL query limits - just all of the sudden this

You likely have a query inside a loop or something. Without seeing the flow, it'd be kind of hard to tell, but you should be able to find it.

Also - are Workflow Rules and Validation Rules capable of running up a query count ? I see tons of those kicking off in my debugs. I didn't know if certain commands within a WF Rule or Validation Rule were capable of being regarded as a "query" call.

No, those are "for free," they do not count against CPU time, heap, DML, or query limits. Only Process Builder/Flows and Apex Code count against the limits.