Data Integration Troubleshooting

Use these tips to resolve problems with data integration issues in CRM Analytics.

• Why am I receiving recipe errors?
  These suggestions can help resolve recipe errors in CRM Analytics.
• Why are my data sync and recipe runs getting canceled?
  Tightly scheduled recipe or data sync jobs can result in canceled data sync and recipe runs because too many runs are queued. You can usually avoid this situation by extending the time between a recipe’s or data sync’s scheduled runs.
• Have I exceeded my dataset row limit, and what can I do about it?
  All orgs have a dataset row limit. When you exceed this limit or create a recipe that can exceed this limit, you must reduce the number of dataset rows used or increase your limit.
• Why can some jobs exceed the output connector limit?
  CRM Analytics always completes output connector jobs even if the result exceeds the rolling 24-hour limit.
• Why is my recipe or data sync job running out of time or being killed?
  A recipe or data sync job can fail because the integration user can’t authenticate.
• Why was a recipe unscheduled?
  When a user is deactivated, the recipes in which they made the most recent modification are unscheduled to prevent unnecessary runs.
• Why am I receiving a syntax error in the formula node?
  You can perform several types of transformations on fields in Data Prep. However, some field API names are unavailable for these transformations.
• Why is my scheduled recipe not running as expected?
  When recipes are chained together using event-based scheduling, unscheduling or manually running an upstream recipe or connection can result in unexpected outcomes.
• Why does my dataflow run after a data sync failure?
  When a data sync job fails for an object that is used by a downstream dataflow, the system is designed so that the dataflow execution is deferred until the failed object is successfully reprocessed. This behavior ensures that dataflows work with up-to-date and complete data, and is consistent in the vast majority of cases.
• Why is my data sync job failing with “string is too long” errors?
  Data sync updates can fail with field length errors that occur when the size of the data defined in the Salesforce object doesn’t match the size of the data in data sync.