Microsoft KB Archive/217384

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

Article ID: 217384

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q217384



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:   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= and publisher_db= and subscriber_id= and subsriber_db=   On the subscriber database, run the following: use  go  update MSlast_job_info set job_id=<@dist_job_id> where publisher= and publisher_db= 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: kbprb kbpending KB217384

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.