Replication Isues After upgrading subscriber to 2005

Hi There

A while ago i migrated a 2000 database to a new instance of sql server 2005 and succesffully setup replication from a 2000 publisher.

However to experiment i took an existing 2000 instance with a subscriber databases and upgraded the default instance to 2005. (Upgraded from 2000 Enterprise to 2005 Enterprise)

After the upgrade the setup logs were all successful, i also run upgrade advisor before and made sure there were no issues.

To see what happens i did not drop the subscription before upgrade (is this an absolute neccessity ?)

All i did was stop the distribution agent before upgrade, to see what would happen, i did not expect it to work.

But since the upgrade i cannot delete the subscription on the subscriber after upgrade, i also cannot create a new subscriptions on the upgraded subscriber.

I get the following error:

Sql Server error 207: column job_step_uid not found.

I found the following link :

http://support.microsoft.com/kb/914781/en-us

but it only refers to desktop editions and express, they refer to the msdb database not upgrading, but the upgrades logs are clear i see no evidence of an issue when upgrading msdb.

What exactly is going on? How can i delete the old subsciption and start creating new ones in the upgraded subscriber ?

I have read the Upgrading replicated DB's topic in BOL, no mention of having to drop subscription before upgrade although i suspect so, all it mentions scripting out the replication , changing the scripts , dropping the subscription (no mention of before or after upgrade), and re-creating them. (all of these i am unable to do due to the above error.)

Please assist, thanx

Hi

Ok i have since ound out that job_step_uid is a new column on the MSdistribution_agents table in the distribution database.

But i have not upgraded the distributor and i dont have to, as mentioned i have setup replication successfully with a 2005 database to a 2000 publicationa nd distributor without any issues, i have no idea why this time is seem to think the distributor is 2005 ?

So i am still stumped i know where it thinks this column should be, but no idea why i am getting this error all of a sudden, no where during subscription setup is the publisher or distributor required to be 2005?

ANyone ?

|||I lost track - what version is your publisher, distributor and subscriber? The supported option is that the version of the distributor has to be greater than or equal to the version of the publisher. For Merge replication, it goes one step further, where the version of the publisher has to be greater than or equal to the subscriber. There's more information about this in Books Online.|||

Hi Greg

I have consequently found out through a microsoft case that sp_vupgrade_replication and sp_vupgrade_repl_metadata procs may have to be run after upgrade.

Will postback if this resolves the issue.

Thanx

|||Running these 2 procs resolved the issue.|||

greetings.

i am having the same problem you were facing. i am trying to re-setup a publication, but it will fail with an error 207, invalid column name 'job_step_uid'.

i have installed service pack 2, and it didn't solve anything. i was able to run the first proc mentioned, the second proc however, didn't seem to work (the text was black, as opposed to the other proc which was highlighted in crimson).

any ideas, guys?

thanks.