2 Replies Latest reply on Aug 26, 2015 3:42 PM by Matthew Mooney

    Salesforce Sync issue: Too many SOQL queries

    Matthew Mooney

      Hello,

       

      I have had many leads that were unable to sync with the following error message: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: ContactPrimaryFlag: System.LimitException: Too many SOQL queries: 101    I suspect this is an issue with Salesforce and I believe the issue is the high number of workflows and validation rules we have in our Salesforce instance.  I had the same problem using Data Loader and the solution was to change the batch size in the Data Loader settings.  This resulted in a slower process, but no issues with too many SOQL queries.  I have not been able to figure out how to limit the batch size for Salesforce sync.

       

      Has anyone had the same issue regarding the Lead sync from Marketo to Salesforce? Does anyone have a solution?

       

      Thank you,

       

      Matt

        • Re: Salesforce Sync issue: Too many SOQL queries
          Josh Hill

          Some questions you should ask:

          • Check Admin>API to see how many API calls you are making. This is not an SFDC issue, but if it is alot, that could be a symptom.
          • Admin>SFDC>Sync Activities - if this is on, you should consider turning this OFF and relying on Sales Insight or much narrower range of Tasks within workflows.
          • Are you syncing all leads to SFDC?
          • How many flows are controlling the sync? Are you syncing Programs-SFDC Campaigns? This could increase the volume that is hitting your SFDC triggers.
          • Yes, consider ways to throttle your SFDC triggers.
          • You may want to call Support or SFDC support to dig into this issue more.
          3 of 3 people found this helpful