PRB: REPL: "Last Distributor Job ID and Last Subscriber Job ID Do Not Match" Error

ID: Q217384


The information in this article applies to:
  • Microsoft SQL Server version 6.5


SYMPTOMS

The distribution task reports the following error:

Last distributor job ID and last subscriber job ID do not match. No jobs were available with job ID > %.d
This problem occurs when the MSlast_job_info table at the subscriber is not synchronized with the MSsubscriber_status table at the distributor. This problem may also happen if the publisher is unpublished and then published again.


WORKAROUND

To work around this problem, synchronize the MSlast_job_info table with the MSsubscriber_status table. To do this, do the following:

  1. On the distribution database, run the following:
    
       declare @dist_job_id int
       select @dist_job_id=max (job_id) from MSsubscriber_status where
       publisher_id=<pub_id> and publisher_db=<publishing_db_name>
       and subscriber_id=<sub_id> and subsriber_db=<subscribing_db_name> 


  2. On the subscriber database, run the following:
    
       use <subscribing_db_name>
       go
       update MSlast_job_info set job_id=<@dist_job_id> where publisher=<publ_server_name>
       and publisher_db=<publishing_db_name>
       go 


If you encounter this error after subscribing to a publication from a subscriber, you can set the job_id to 0. If all the subscriptions come from the same server, you can drop the MSlast_jobs_info table at the subscriber and then re-run the distribution task.

Additional query words: repl jobid job_id err error msg message dist sync synch

Keywords : kbSQLServ650
Version : winnt:6.5
Platform : winnt
Issue type : kbprb


Last Reviewed: July 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.