---
schema_version: "1"
id: 5d381836108847fb9d57fcb4e7fb3a4b7481fd8fbc2baf8bc8934806eb64d6c5
title: Troubleshoot Salesforce Connector Sync Issues in Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_connector_salesforce_troubleshoot.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_connector_salesforce_troubleshoot.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 65141e6af95b4b6b50b2f9f630201d3855f9c9d920800abac126e358baa4b056
description: If you're experiencing issues synchronizing data with the Salesforce connector in Salesforce Spiff, follow recommended steps to troubleshoot the issues.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Troubleshoot Salesforce Connector Sync Issues in Salesforce Spiff

If you're experiencing issues synchronizing data with the Salesforce connector in Salesforce Spiff, follow recommended steps to troubleshoot the issues.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
          <colgroup>
            <col style="width:50%">
            <col style="width:50%">
          </colgroup>
          <thead class="slds-text-title_caps ">
            <tr class="">
              <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d94633e81">User Permissions Needed</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e81 ">To troubleshoot a Salesforce connector:</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e81 ">
                <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with these permissions turned on.</p>
                <ul>
                  <li>Connectors: Edit</li>

                  <li>Data Sources: Sync</li>

                </ul>
              </td>

            </tr>
          </tbody>
        </table>

- Double-check the data in your source system to make sure that the data is stored as expected.
- Verify that the user connected to the data source has access to the data.
- Check the Sync Logs page for recent sync errors. From the Admin menu, select Connectors and then click **Sync Logs**.
- From the Syncable Objects page, check the object mapping and connector fields.
    1. Resync the errored object mapping.
        
        See [Add a Salesforce Connector](https://help.salesforce.com/s/articleView?id=sales.spiff_connector_add.htm&release=264.0.0&type=5 "To sync data from Salesforce with Salesforce Spiff, add a connector. You can set up connectors for up to five Salesforce orgs.").
    2. Look for the object mapping that failed and verify that the connector fields have Sync turned on.
    3. Verify that unused fields are turned off.
        
        If every connector field is turned on, Spiff requests data for every field in a record. For better performance, sync only the fields that you need for commission calculations.

For more support, contact Salesforce Customer Support.

If you're troubleshooting a third-party connector, contact your Salesforce account executive, who can help you identify the appropriate support channel.

If you're troubleshooting a Snowflake connector, verify whether any changes occurred in your Snowflake environment before you noticed the sync issues.

## Resolve Salesforce Connector Sync Errors in Salesforce Spiff

Troubleshoot common sync issues in Salesforce Spiff.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_note.png)

Note Where possible, we changed noninclusive terms to align with our company value of Equality. We maintained certain terms to avoid any effect on customer implementations.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:20%">
              <col style="width:40%">
              <col style="width:40%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d94633e234">Error Name</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d94633e237">Explanation</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d94633e240">Troubleshooting Steps</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">ClientNeedsToReAuth</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">Reauthenticate the Salesforce connector and run a global re-sync.</td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 ">See <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_connector_salesforce_maintain.htm&amp;release=264.0.0&amp;type=5" title="After you connect a Salesforce environment to Salesforce spiff, you can swap the connected environment for a different one, such as switching between production or sandbox. Or if you're a new Spiff admin who inherited a Salesforce connector that a different admin previously authenticated, reauthenticate the connector with the same credentials.">Updating a Salesforce Connector in Salesforce Spiff</a>.</td>

              </tr>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">MissingObjectsInS</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">A mapping in Spiff expects an object in Salesforce. Either someone deleted the object or you no longer have access to it.</td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 ">Verify that the object still exists in Salesforce and that you have access to it. If the object has been deleted, turn off sync for the object. See <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_connector_salesforce_maintain.htm&amp;release=264.0.0&amp;type=5" title="After you connect a Salesforce environment to Salesforce spiff, you can swap the connected environment for a different one, such as switching between production or sandbox. Or if you're a new Spiff admin who inherited a Salesforce connector that a different admin previously authenticated, reauthenticate the connector with the same credentials.">Updating a Salesforce Connector in Salesforce Spiff</a>.</td>

              </tr>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">InvalidWhereString</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">The SOQL <code>WHERE</code> expression for limiting the number of records that Spiff syncs from a connected Salesforce object is invalid. </td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 ">Spiff performs safety validation of your <code>WHERE</code> clause, but doesn’t validate that the clause returns any data. To test whether your clause returns the results you expect, enter a clause, sync data, check your sync logs for errors, and iterate if necessary. We recommend that only developers with SOQL experience implement this filter.</td>

              </tr>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">SalesforceAPIError</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">Spiff tried to sync data with Salesforce, but a timeout occurred before a response was received.</td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 "> Check the <a href="https://status.salesforce.com/" target="_blank">Salesforce Trust Status</a> website for outages or scheduled maintenance. Then, re-sync individual objects with errors, or try a global re-sync. If errors persist, go to the Syncable Objects page and verify that unused fields are turned off for an with errors object.</td>

              </tr>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">TooManyConnectorFields</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">If every connector field is turned on for an object, Spiff requests data for every field in a record, which takes longer and limits performance. If too many fields are requested, the query can't complete.</td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 ">Go to the Syncable Objects page and verify that unused fields are turned off for an with errors object. Then, re-sync individual objects that with errors, or try a global re-sync.</td>

              </tr>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">TooManyDeletes</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">Salesforce REST API limits the number of delete operations in a single request. Spiff shows an error when the linked Salesforce environment exceeds this limit.</td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 ">Contact your Salesforce account executive for help with identifying deleted records that the sync operation missed.</td>

              </tr>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">BadSpiffOverwrite</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">A required external_id was overwritten with an invalid value.</td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 ">Go to the record where the overwrite occurred and replace it with a valid external_id. Then, re-sync.</td>

              </tr>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">ClientNeedsToWhitelistIP</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">Spiff is outside of your Salesforce connected app allowed IP range.</td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 ">
                  <p>Try relaxing your connected app's IP restrictions. See <a href="https://help.salesforce.com/s/articleView?id=xcloud.connected_app_manage_oauth.htm&amp;type=5&amp;language=en_US" target="_blank">Manage OAuth Access Policies for a Connected App</a>.
                  </p>
                  <p style="margin-bottom:0;">If you don't want to change the connect app's IP restrictions, set a trusted IP range for Spiff. See <a href="https://help.salesforce.com/s/articleView?id=xcloud.connected_app_edit_ip_ranges.htm&amp;type=5&amp;language=en_US" target="_blank">Configure Trusted IP Ranges for a Connected App</a>.</p>
                </td>

              </tr>
              <tr class="">
                <td data-label="Error Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e234 ">Unknown</td>

                <td data-label="Explanation" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e237 ">An unidentified error occurred and there's no specific remediation.</td>

                <td data-label="Troubleshooting Steps" class="slds-cell-wrap" style="vertical-align:top;" headers="d94633e240 ">Try syncing again. If the issue persists, contact your Salesforce account executive.</td>

              </tr>
            </tbody>
          </table>