BUG: Dist Task Ignores Errors on Pre-creation Commands

ID: Q192488

The information in this article applies to:

Microsoft SQL Server version 6.5

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 : SSrvRep kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug