Knowledge Base

BUG: Dist Task Ignores Errors on Pre-creation Commands

Article ID: 192488

Article Last Modified on 10/3/2003

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.

Additional query words: prodsql schema err ignored dist replication

Keywords: kbbug kbpending KB192488


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.