Review the rules and guidelines for the components of a synchronization task.
Synchronization task errors
The synchronization task fails.
A synchronization task might fail for the following reasons:
•You tried to run a synchronization task that was already running. You can run one instance of a synchronization task at a time.
•You tried to run a synchronization task, but the corresponding Secure Agent is not running. Verify that the Secure Agent is running.
•You tried to run a 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 synchronization task that contains an invalid field mapping.
If the source or target changed after you created the field mapping for a synchronization task and you try to run the synchronization task, the following error appears:
The 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 synchronization task. You must edit the synchronization task and include all required fields before you can successfully run the synchronization task. For more information about required fields in field mappings of synchronization tasks, see Tasks.
- 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 synchronization task. Resolve the field mappings in the synchronization task that point to nonexistent fields.
•You tried to run a 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 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 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 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 synchronization task.
The synchronization task wizard caches the dataset for connections when you configure the task. The 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 Tasks.
The 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 synchronization task that includes a saved query, the synchronization task ignores the configured target option for the task and tries to insert data to the target.