Subscription failed validation.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Subscription failed validation.

Subscription failed validation.

Rate Topic

Display Mode

Topic Options

Author

Message

Suresh B.

Posted Thursday, September 04, 2008 11:10 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:54 AM
Points: 1,076, Visits: 5,128

A subscription is failing validation (checksum).

I deleted and recreated publication.
Recreated the subscriptions with initialization.
Still it is failing validation.
What could be the reason? How to resolve it?
Any help in this matter will be highly appreciated.

Note: Replication is working. New rows are being replicated to the subscriber.
There are other replications between the same publisher and subscriber. They are passing validation.

Post #564325

Adrian Robertson

Posted Monday, October 06, 2008 10:36 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, October 11, 2009 3:17 PM
Points: 23, Visits: 107

This is telling you that some data within tables is failing validation, meaning that at least one table has data in it which is different between the Publisher and Subscriber. This could be due to a conflict, and this is the first place I would look

The results of the validation exercise should tell you which table(s) this is occuring in, so step 1 is to check this against any possible conflicts, and resolve these conflicts where necessary, and then re-validate the subscription

If it is not a conflict, and if it is a only a small number of tables affected, you can use tablediff to create a script file that will essentially contain all of the updates, which should be the differences between one table and the other. You can then view this script file to see what and how many of those changes there are

The tablediff utility, to my knowledge, can only be run on a single table at a time though so if there are a lot of tables affected, you probably need a different solution

Post #581505

Suresh B.

Posted Tuesday, October 07, 2008 2:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:54 AM
Points: 1,076, Visits: 5,128

Thanks Adrian for replying.

This issue has been resolved. It was happening due to difference in the UDDTs in the publisher and subscriber.

Post #581592

« Prev Topic | Next Topic »

Permissions