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.