August 10, 2006 at 2:59 pm
I am trying to setup transactional replication on a sql server 2000 sp3 database but after I go through the Pull Subscription wizard it fails on the step "Updating the Publisher" and I get the following error:
Error 20027: The article '(null)' does not exist.
Could not update the distribution database subscription table. The subscription status could not be changed.
The subscription could not be created.
I have tried to push the subscription with the same error. Any help would be apreciated
August 10, 2006 at 6:24 pm
Its possible that you may not have set up the publication properly, or that all articles have been dropped from the publication. Can you confirm that there are articles present by running this SP in the publisher database:
sp_helparticle
<Publication Name>
If it returns a list of articles, execute this sp (also in the publisher database):
exec
sp_addsubscription
@publication = N'Pub1', --change to your publication
= N'all' ,
= N'Sub1', -- Change to your subscriber name
@destination_db
= N'Pub1', -- Change to your subscription database name
@sync_type
= N'none',
@update_mode
= N'read only' ,
@subscription_type
= 'PULL'
August 14, 2006 at 12:59 pm
Thanks for the reply.
what it looks like to me is there are articles in the publication but no tables, only views. I went through the publication setup again and I cannot select any of the tables in my database as articles for replication (they all have and X and a key beside them). Could this be the reason for my error?
August 14, 2006 at 3:00 pm
When you are setting up the replication, you need to select the list of objects you want to be replicated. By default only views are selected. Perhaps you overlooked that screen of the wizard and clicked next. You could add the tables individually if you have only a few tables with not much data but if its a big DB and lot of tables you might need to set up the replication again.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply