When you enable data sync for a record type, the record type caches your source data in Appian. To keep your synced data up-to-date with the source, an immediate sync occurs whenever Appian writes to the source of your data. You can also schedule daily syncs so your data is synced at least once a day.
However, sometimes record types fail to sync to the source. When this happens, you can use the information in this article and in the error messages found in the monitoring view to resolve issues with sync.
This article provides troubleshooting steps for sync failures due to:
When you enable data sync for your record type and configure your record fields, Appian automatically creates a mapping between the source schema and record type schema. The source schema includes the names, types, and uniqueness constraints of all the fields in your source. This schema must match the record type's schema in order for Appian to sync the source data.
If a change is made to the source schema without making a corresponding change to the record type, the record type will fail to sync. There are three common causes for a mismatch between the two schemas.
To update the mappings for any of these scenarios, follow these steps:
You can also use this mapping tool if you need to change the database table or Salesforce object that backs your record.
When you set up your Salesforce object as the source for your record type, you have to provide login credentials in order to access Salesforce. If the Salesforce object's credentials are determined to be invalid at the time of the sync, your sync will fail. It could simply be that the password has expired or that the credentials have changed. In order to successfully sync, you need to verify the credentials and re-sync the record type.
To check the credentials and re-sync:
For more information on authentication, credentials, and configuring a Salesforce object, see Connected Systems.
With data sync, a record type object can sync up to 500,000 rows of data from a selected source. This limit applies to new rows of data introduced by an immediate sync.
If your source exceeds 500,000 rows, the sync will fail and the record type will be unavailable. Sources within 10% of the limit (475,000 to 500,000 rows) will sync successfully, but a warning will let you know that the source is approaching or has reached the row limit.
To keep your source from exceeding the row limit, apply one or more source filters to limit the number of rows cached in Appian from the source. If the source is expected to regularly exceed 500,000 rows, you may choose to disable data sync.
To disable data sync, you will need to change the data source from the record type's Data Model and update all references to the original record fields throughout your application.
To find specific field references in your environment:
/* and */.In the OBJECTS View, paste the string into the search box under DESIGN OBJECTS.
You can search for multiple strings at once by separating each string with a space.
Every object that references the string will appear in your search results. Once you have located all the references in your objects, update the field references. For updating field references in interfaces, we recommend updating the references in Expression Mode.
If you're performing a full sync (all syncs other than an immediate sync) that takes longer than 4 hours, it's possible that the sync will time out and fail. When the sync fails, the record type will become unavailable and you'll see an error in your stack trace.
A sync timeout can occur on any record type with data sync enabled, but may be more common on synced record types that use a web service as the source.
To prevent a sync from timing out, consider:
If you cannot modify the above configurations, or your record type uses a database table as the source, you may choose to disable data sync on your record types that take longer than 4 hours to sync.
To disable data sync, you will need to change the data source from the record type's Data Model and update all references to the original record fields throughout your application.
To find specific field references in your environment:
/* and */.In the OBJECTS View, paste the string into the search box under DESIGN OBJECTS.
You can search for multiple strings at once by separating each string with a space.
Every object that references the string will appear in your search results. Once you have located all the references in your objects, update the field references. For updating field references in interfaces, we recommend updating the references in Expression Mode.
Sometimes record types fail to sync to the source because of issues that require troubleshooting outside of Appian. When this happens, check the error message for information to help you troubleshoot the issue or contact your system administrator for further assistance. Here are a few brief explanations of these issues and their possible causes:
| Issue | Error Message | Possible Cause |
|---|---|---|
| Problem connecting to the source. | Unable to sync because the data source did not respond. |
The source didn't respond, VPN failed, or the API limit has been reached. |
| Problem with the sync server. | Unable to sync due to a system issue. or Not enough disk space to complete sync. |
The disk is full or the sync server is down. |
| Problem with row size. | Unable to sync because a source row exceeds the size limit. |
A source row exceeds 1 MB. |
| Problem with resource use. | Generic error: Unable to sync due to an error with the data source. |
Too much competition for resources between syncs and other processes. |
