Subscription to publication 'x' is invalid

Subscription to publication 'x' is invalid

Post by EBirni » Thu, 19 Apr 2001 22:52:11

I have the following problem with replication:

All machines are Win2K SP1, SQL server 2000. Server x is
publisher/distributor. Server y has several merge publications pushed to it
by server x. This problem is occurring on server y (subscriber).

I get the following error on server y:

Category: Agent, Source: Merge Replication Provider, Number: -2147201019
Error: The subscription to publication 'x' is invalid
Category: Data Source, Source: 'Server x', Number: 20026
Error: The publication 'x' does not exist.

I have looked in sysmergepublications on server y (ie the subscriber), and
there is only one record (for the subscription that is working correctly,
and there is not an entry for the one causing the above problem). I've also
had this problem on another publication, and I dropped the subscribers,
dropped the publication and recreated it. This simply moved the problem on
to another publication.

Another funny thing that I've noticed is that this problem does not happen
immediately after recreating the publication and its subscriptions, and
seems to happen after the merge agent has run several times.

I have dropped and recreated several publications on this database, which
caused a similar problem on SQL server pre-SP3, where the pubid in
syspublications exceeded a max value.

Would it be useful to drop all subscriptions to all publications, drop the
publications, remove replication and start again? Obviously this is the last
thing I'd try as these are live systems!

I'd appreciate any suggestions!



1. Subscription of Publication 'DATABASE' is invalid

Hi there,

I'm planning to use SQL's Merge replication feature to solve synchronization
issues. However, I got stucked at some errors. Let's say I configured
publisher and distributor at Server A. Publication created at Server A named
DataPub1. Then, I create push new subscription to Server B using Merge type.
It will initialize the schemas and everything is working properly. But, when
it comes to Synchronization process, it is failed. The error is
"Subscription of Publication 'DataPub1' is invalid". Anyone has any idea
about this?

Best regards,


2. Failed to enlist on calling objects transaction ????

3. subscription to publication 'XXXX' is invalid

4. Is your computer being bugged????

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

6. BT 5.10a and HP drivers using Toolbox

7. The subscription to publication <'publication name'> is invalid

8. updatable spanshot's help

9. Can't Setup a Pull Subscription to an Snapshot Publication using SQLDMO

10. The subscription to publication 'Pub1' is invalid

11. The subscription to publication 'xxxxx' is invalid

12. Error: Subscription to Publication 'xxx' is Invalid

13. The subscription to publication 'Db' is invalid