Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

The subscription to publication Null has expired or does not

 
   Database Forums (Home) -> Replication RSS
Next:  Don't convert from ASA to ASE  
Author Message
SNA2




Joined: Jun 20, 2005
Posts: 7



(Msg. 1) Posted: Wed Jul 13, 2005 10:02 am
Post subject: The subscription to publication Null has expired or does not

When I create a pull subscription from my main database, I go through all the steps and successfully create a the subscription.

However, when I drill down in the replication monitor on the publisher down to the database thats being published, the snapshot agent says it has succeded but has not generated a snapshot because no subscriptions needed initialization. Also, the distribution agent listed says it has never started. No matter what I do I cant get it to start.

I do believe the problem resides on the Pull subscription, as when I drop over to the remote database in Enterprise Manager and look at the pull subscription agent, it gives the following error:

The subscription to publication '(Null)' has expired or does not exist.

I have looked up this error, and the following article describes how to alleviate this problem for SQL 7.0 but I'm using SQL 2000, and I cannot figure out how to follow steps 2,3,4 as the distribution agent has never started yet anyway, and there is no obvious way to change the subscriber name.

http://support.microsoft.com/kb/q290054/

The script runs great, and returns an uppercase subscriber name, but I cannot figure out how to follow the next steps, any further detail would certainly be appreciated on steps 2,3,4.

 >> Stay informed about: The subscription to publication Null has expired or does not 
Back to top
Login to vote
SNA2




Joined: Jun 20, 2005
Posts: 7



(Msg. 2) Posted: Wed Jul 20, 2005 2:40 pm
Post subject: Re: The subscription to publication Null has expired or does [Login to view extended thread Info.]

Confused

I still cant get this to work, anyone run across this problem before?

 >> Stay informed about: The subscription to publication Null has expired or does not 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Merge publication - SQL 2008 Express - Does anybody know if SQL Server 2008 Express edition will be able to participate in a merge replication as a publisher and a subscriber (like SQL Server 2000 MSDE)? I can't understand why Microsoft removed this capability in the 2005 Express version....

Problem Applying Schema Changes to Existing Merge Publicat.. - Publisher: - Windows 2000 SP4 - SQL Server 2005 Subscriber: - Tablet XP SP2 - SQLExpress SP1 - Merge Pull subscriptions with parameterized filters All, As brief as I can: We have 2 table articles and a trigger in our publication. The 2..

Incremental Article Additions to an Existing Merge Publica.. - Hi there, We are running Merge Replication for SSL between SQL Server 2005 Standard Edition SP2 Server and SQL Server 2005 Express Edition SP2 (With Advanced Services) Subscribers. We actually have 3 publications per SUBSCRIBER, one for tables, one..

Remove push subscription from subscriber - Hi everyone. I have an SQL Server 2000 "A" pushing a transactional replica of a database on an SQL Server 2000 "B". Today i removed the subscription from server "A" (publisher), but i still see the subscription on the ser...

Merge Subscription Database move to new Server - I want to move Merge Pull Subscription database to New server(Hardware) without dropping subscription. Note: I do not want copy master and msdb database to new server because collation is different from subscription database. OS : Windows 2003..
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]