BUG: Dist Task Ignores Errors on Pre-creation Commands (192488)
The information in this article applies to:
This article was previously published under Q192488 SYMPTOMS
The distribution task ignores any errors on pre-creation commands and
attempts to proceed further with the sync operation, without reporting this
error in the task history. Depending on the error on the pre-creation
command, this may result in failures on the sync command, such as duplicate
key errors or bcp-related errors.
WORKAROUND
Verify that the pre-creation command completes successfully if the
distribution task fails on sync command. You can identify the last
successful job based on job_id in the MSlast_job_info table at the
subscriber. Manually run the pre-creation command and rectify any error
causing condition before restarting the distribution task.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbpending KB192488 |
|---|
|