Troubleshoot Data Extension Failures

During the data extension sync process, different statuses appear. If for some reason the process fails, troubleshoot according to these guidelines.

Required Editions

Available in: Intelligence Reports Advanced

Note It’s recommended to not modify data extensions after they’re connected to avoid sync failures.

• Pending—The data extension is connecting. It can take up to 24 hours to populate data.
• Complete—The data extension is connected. Data is synced once a day.
• Failed—The data extension failed to sync. Here are some possible reasons:
  • A field was renamed or deleted from the data extension. Disconnect the data extension and then contact Salesforce Customer Support.
  • There were invalid column names in your data extension.
  • The data extension contained one of these column names: date_id, location_id, dat_account_currency, dat_exchange_rate, pacing_period, pacing_end_date, or row_count.
  • The data extension contained the same column name more than once.
    

    Note Data extensions aren’t case sensitive. For example: campaign name = campaign_name
  • A technical error occurred. It’s recommended to wait 24 hours.
  • If for some reason the connection to the data extension failed, try deleting the automation of the data extension in Automation Studio.