Once you've set up a sync in Smart Ingest, you can monitor its progress and view its run history. This article explains how to view sync history, understand sync statuses, and locate sync errors.
NOTE
To learn about sync errors, read Troubleshooting Smart Ingest.
In this article
Viewing sync history
To view your sync’s run history:
Log in to Iterable as a user with the Manage Integrations project permission and open the project you’re working on.
Go to Integrations > Smart Ingest, and find the sync you’re checking on.
-
Click on the overflow menu (three dots) and click on View History.
Next, a new window pops up with the sync details.
In the Runs tab, you can view the sync run history and the status for each run.
-
If there are sync errors, you can click on View Error to see more details.
-
To view the row-level operations for a particular sync run, click on the row for the sync run you want to view. Here, you can view the success or error for each row-level operation.
Sync status
At a given time, a sync can be in any of these statuses.
| Status | Description |
|---|---|
| Healthy | A recent run has completed. |
| Pending | No runs scheduled. For example, syncs that run on a manual schedule. (This does not mean a sync job is pending processing.) |
| Disabled | The sync has been turned off. |
| Querying | The sync is querying its associated data model. |
| Preparing | The sync is preparing data to send to Iterable. |
| Queued | The sync is scheduled to begin writing data to Iterable. |
| In Progress | The sync is writing data to Iterable. |
| Incomplete | The sync had a temporary interruption and will resume in a new run. |
| Warning | The sync had some errors with specific row operations. To learn more, read Sync errors. |
| Error | There was an error in the sync progress—check the errors on the sync to see why the sync failed. To learn more, read Sync errors. |
Sync errors
There are two sync statuses that indicate errors: failed and warning. A failed sync status comes from an error that prevents data from syncing (such as a connection or credential error). A warning sync status occurs when there are row-level errors that prevent some data from syncing.
Errors can come from your data source, or from Iterable. The source of the error is highlighted in the detail view. This is helpful when troubleshooting.
Example error from Snowflake:
Failed syncs
Failed syncs indicate that a connection failed and the entire sync was unable to complete. When a sync error prevents Smart Ingest from importing data, the sync shows a status of Error in the Smart Ingest page.
To view the error message, go to the overflow menu (three dots) and click View Run History, then click View Error to see the message that came from the sync source.
Warnings
When a sync has rejected operations that result in warnings, this means that there are rows of data that Smart Ingest couldn't sync. This often occurs due to validation errors between the data you're trying to sync and the fields inside of Iterable (such as incorrectly formatted email addresses).
Under Operations, you can see what types of operations were attempted (add row, change row, and/or remove row).
IMPORTANT
Smart Ingest may return a warning status even if all rows fail. This indicates that a connection between your data warehouse and Iterable was successful, and the errors pertain to the row level operations in the sync.
Troubleshooting sync errors
When investigating sync errors, it's important to understand where the error is coming from. Errors can come from your data source, or from Iterable.
Iterable errors
Errors coming form Iterable are typically due to issues with the data you're trying to sync. For example, if you're trying to sync a column of boolean values to a column in Iterable that only accepts integers, you'll see an error.
To troubleshoot Iterable errors, review Troubleshooting Smart Ingest.
Data source errors
To view the most common errors coming from each data source and their solutions, view the troubleshooting section in the connection guide for your data source.