subscription to publication is invalid ??

subscription to publication is invalid ??

Post by Hung Huyn » Wed, 27 Nov 2002 06:46:25



Hi,

I'm trying to implement Merged Replication on w2k and sql 2k.  Everything
has been cleaned up and setup for merged replication.  Snapshot has been
created successfully with about 72 articles. When it was time to push schema
and data over to the replicated server, it was working for a while, then
suddenly stopped and reported an error saying that "Subscription to
Publication "database-name" is invalid?". I checked the replicated server
for internet connectivity, the connection was fine. The server was still up
and replicated database working properly.

Please advice. Thanks!

HH

 
 
 

1. The subscription to publication X is invalid

Hello,

I've created a push supscription to a publication and all goes well (.sch scripts applied, data copied, .dri scripts applied) but then I get the before mentioned error.

This error appeared in this newsgroup a couple of times, but unfortunatly none of the solutions provided worked for me.

I think in my case it has to do with the database, though CHECKDB doesn't report errors. The reason for this suspicion is the fact that I can create a publication AND working subscription on table X. But if my publication includes the 'Order' table (the most important, yes..) I get the error.

I would appreciate any clues or hint a lot.

Thanks,
Joost van Rijswijk

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

2. Recommendations Please

3. Merge replication: The subscription to the publication is invalid

4. Questions about Open Client 10.0.2 on OS/2 boxes

5. Merge replication: the subscription to the publication is invalid

6. 7.30 problems

7. subscription to publication 'XXXX' is invalid

8. Subscription to publication 'x' is invalid

9. subscription to publication is invalid error

10. Subscription of Publication 'DATABASE' is invalid

11. subscription to publication is invalid ??

12. The subscription to publication 'publication name' is invalid