Salesforce Troubleshooting
Learn how to troubleshoot common issues with Salesforce connections.
Billing and MAR
Data Integrity
- Custom Field Values are Missing From the Destination
- Fields With Data Show
nullValues in the Destination - Formula Field Values in the Destination Don't Match Salesforce
- Manually Updated Values Aren't Reflected in the Destination
- Updates to OPPORTUNITY_LINE_ITEM Fields Aren't Reflected in the Destination
- Where Can I Find Activity Object Data?
- Why Are Date Time Fields Different Between Salesforce and My Destination?
- Why Are Deletes Missing From the Salesforce OPPORTUNITY_LINE_ITEM Table?
- Why Are Some Tables Empty in My Destination?
- Why Can't I See the FIVETRAN_FORMULA Table While Adjusting My Salesforce Schema?
- Why Do Salesforce Formula Models Return Fewer Records Than the Corresponding Source Table?
- Why Do Record IDs Contain 15 Characters in Salesforce and 18 in the Destination?
- Why Do Some Formula Fields Translate to
nullValues? - Why Do Some Records Sync Later Than Expected?
- Why Does the
modelColumn in the FIVETRAN_FORMULA_MODEL Table HavenullValues? - Why Doesn’t My Destination Reflect an Updated Salesforce Data Type?
Errors, Warnings, and Alerts
- Alert: Table Excluded By System
- Error: 90% of the API Limit Is Reached
- Error: Authentication Failed. Unable to Request Access Information!
- Error: Reconnect the Connection With the Latest Credentials
- Error: The Rest API Is Not Enabled for This Organization
- Error: This App Is Blocked by Admin
- Warning: Cannot Select – Doesn't Support LIMIT
- Warning: MALFORMED_QUERY: Implementation Restriction
FAQ
- Can I Sync Salesforce Unified Objects Using Fivetran?
- Does Fivetran Automatically Delete System Table Data?
- Does Fivetran Sync the List of Salesforce Country and Territory Picklist Options?
- For Salesforce Picklist Values, Does Fivetran Sync the Label or API Name?
- How Do Salesforce Field and Object Edits Affect My Formula Models?
- How Does Fivetran Capture Deletes From Salesforce?
- What Happens to Salesforce Records That Are Created and Quickly Deleted?
- Which Salesforce Objects Don't Support History Mode?
- Which Version of the Salesforce API Does Fivetran Use?
- Why Am I Seeing
DeleteAPI Calls in the Connector Logs?
How To
- Check Whether
nullValues Were Caused by a Connection or Permissions Issue - Check if the Authorizing User Has Access to Missing Salesforce Data
- Connect a Salesforce Sandbox Environment to Fivetran
- Determine Whether Fivetran Used the Salesforce REST or Bulk API
- Get the SQL Translation of a Salesforce Formula Field
- Identify Deleted Rows
- Query Points in Time in Salesforce History Mode
- Stop a Table-Level Historical Sync
- Use the Fivetran REST API To Enable the Syncing of Formula Fields
Setup and Configuration
- Can an API-only Salesforce User Authenticate a Connection?
- Error: Unable to Request Access Information
- Error: This App Is Blocked by Admin
- Fields Are Missing or Grayed Out in the Schema Tab
- How Can I Change a Salesforce Connection's Authorizing User
- How Do I Configure My Salesforce Schema to Support Formula Fields and Models?
- Warning: Cannot Select – Doesn't Support LIMIT
Syncs
- Does Fivetran Sync Digital Salesforce Files?
- Error: 90% of the API Limit Is Reached
- Why Does_fivetran_synced Update for Salesforce Connections When Source Data Hasn't Changed?
- Why Are Salesforce Deletes Not Captured After Pausing the Connection?
- Why Is My Sync Taking Too Long After Adding a New Table?
- Why Is the Connector Taking Longer Than Usual to Sync My Data?