I find myself in a quandary and wonder if the Community has any advice. We currently use Zuora Quotes for our CPQ solution, and everything has been running normally up until last Thursday. Then, out of the blue, my users started getting "Too many SOQL queries: 101" errors while building their quotes. That then caused other process builder automations to fail.
I've opened a case with Salesforce and spent a while on the phone with them today. But I feel like we did not get anywhere, and so I wanted to ask others:
1. When the Too many SOQL queries: 101 error kicks up, how can I get more information about what contributed to exceeding this limit? Something like this:
Process Builder automation #1 = 20 queries
Process Builder automation #2 = 20 queries
Zuora Quotes Trigger #1 = 30 queries
Zuora Quotes Trigger #2 = 32 queries
The key to solving this problem is determining where the excess queries are coming from. I have reviewed the 13 active process builder processes for opps and quotes and do not see any loops or recursion. I have reached out to Zuora to see if they've changed anything on their end. But I feel like I am flying blind so far.
2. One question I have is whether we have reached the natural limit of SOQL queries due to a combination of process builder automation combined with the queries that the Zuora Quotes triggers generate. It strikes me as unlikely though, as of the 13 active quote and opp process builder automations, only about 8-9 are actually invoked during quote building. Seems way too small to be triggering limits. But when I disabled just one PB process, the quotes no longer errored out which seems to indicate that it was enough to take us below the 100 query threshold. Which implies we were bumping up against the query limit quite closely.
Thanks for any insights to this thorny issue.
