Troubleshooting a Data Synchronization Task
Review the rules and guidelines for the components of a Data Synchronization task.
Data Synchronization Task Errors
- The Data Synchronization task fails.
A Data Synchronization task might fail for the following reasons:
- •You tried to run aData Synchronization task that was already running. You can run one instance of a Data Synchronization task at a time.
- •You tried to run a Data Synchronization task, but the corresponding Secure Agent is not running. Verify that the Secure Agent is running.
- •You tried to run a Data Synchronization task that reads data from or writes data to a database, but the corresponding database server is not running. Verify that the database server is running.
- •You tried to run a Data Synchronization task that contains an invalid field mapping.
If the source or target changed after you created the field mapping for a Data Synchronization task and you try to run the Data Synchronization task, the following error appears:
TE_7002 Transformation Parse Fatal Error; transformation stopped...
The Data Synchronization task fails in the following cases:
- - A required field is not mapped in the field mapping. You may have changed the default field mappings or a required field may have been added to the source or target after you created the Data Synchronization task. You must edit the Data Synchronization task and include all required fields before you can successfully run the Data Synchronization task. For more information about required fields in field mappings of Data Synchronization tasks, see Deploy.
- - A field in a field mapping no longer exists in the source or target. The structure of the source or target can change after you create the field mapping in the Data Synchronization task. Resolve the field mappings in the Data Synchronization task that point to nonexistent fields.
- •You tried to run a Data Synchronization task that contains an invalid field name. When a field name is invalid, the task fails with the following error:
[DTM_10004] The DTM process terminated unexpectedly.
- •You tried to run a Data Synchronization task and the field in the data filter changed in one of the following ways:
- - The field no longer exists in the source.
- - The datatype of the field changed.
Edit the data filters in the Data Synchronization task definition based on the latest version of the source.
- My flat file target contains data from the latest job, but not from previous jobs.
The Data Synchronization task truncates a flat file target before writing target data to the file.
To avoid overwriting existing target data, you might use a post-session command to merge target data with a master target file in a different location.
- The data preview does not show the latest changes to the dataset for the Data Synchronization task.
- The Data Synchronization task wizard caches the dataset for connections when you configure the task. The Data Synchronization task wizard deletes the cache after you save the task and refreshes the cache each time you configure the task. To refresh the cache, save or cancel the task, and then edit the task.
For FTP/SFTP connections, data preview shows the latest changes for the dataset when you update the local file to match the remote file.
- I do not see the target when creating the task.
- The list of targets are based on the task operation. For more information, see Deploy.
- The Data Synchronization task inserted all data into the target, instead of performing the update/upsert/delete task operation configured for the task.
When you use an active mapplet with a Data Synchronization task that includes a saved query, the Data Synchronization task ignores the configured target option for the task and tries to insert data to the target.