Replication Problem. 1

[Andel]

I have a problem with my replication from 6.5 to 7. I keep getting this error message:

"The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 287332."

Any ideas? Thanks you.

Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[JNC73]

Hi Andel,

This kind of problem occurs when you stopped the replication and later started it again.

Have you checked the MSjob_commands (it can be that between MS and Job also an _ sign must be placed) in the subscribing database. Was that table empty when you installed the replication or was it filled.

If it wasn't empty you must delete the record which corresponds with the publishing database. WARNING YOU CAN ONLY DO THIS IF YOU RECENTLY INSTALLED THE REPLICATION.
If not Deinstall the replication, delete the record in the MSJOB_Commands table and install the replication again.
Then your problem must be solved.

Hope this helps
JNC73

 

[Andel]

Hi JNC73... thanks for your response.
In the subscribing database, there's no MSjob_Command table but there's a MSlast_job_info table. This table has one entry but the job_id is 0.

I deleted those entries on the MSsubscriber_jobs table and re-sync again but I get the same error.

I know that there should be some entries in the "MSsubscriber_status" table in the distribution database but there's none. Could this be the problem?

Thanks for you guys help!



Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[Andel]

Thanks JNC73. I got it.
Andel
andelbarroga@hotmail.com

http://andyb.8m.com