BUG: Dist Task Ignores Errors on Pre-creation Commands

ID: Q192488

The information in this article applies to:

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

Last Reviewed: April 22, 1999