September 26, 2008 at 11:26 pm
we r having Merge Replication i m gettin this error while syncronizing ..
syncronizatn stops and it gives me this error...
......data come from subscrtion to publication.......
Data validation failed for one or more articles. When troubleshooting, check the output log files for any errors that may be preventing data from being synchronized properly. Note that when error compensation or delete tracking functionalities are disabled for an article, non-convergence can occur.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200953) Get help: http://help/MSSQL_REPL-2147200953 Article 't_boom' failed data validation (rowcount only). Rowcount
actual: 35047, expected: 0. (Source: MSSQL_REPL, Error number:
MSSQL_REPL-2147200953)
Get help: http://help/MSSQL_REPL-2147200953 Article 't_soocs' failed data validation (rowcount only). Rowcount
actual: 74, expected: 0. (Source: MSSQL_REPL, Error number:
MSSQL_REPL-2147200953)
Get help: http://help/MSSQL_REPL-2147200953
September 29, 2008 at 10:18 pm
still waiting for the reply.
October 2, 2008 at 11:24 pm
plz reply
October 6, 2008 at 11:02 pm
You haven't really asked a question here, just posted the output of the error you are getting
What are you trying to do? The Validation process is telling you that there are X number of rows in the tables you have listed, when it was expecting 0. What should the figure be? In a nutshell, there is a difference in the rowcount in at least two of the tables you are replicating, that SQL is not able to rectify
The first thing I tend to do if faced with this scenario is check for conflicts, and in this case insert conflicts (by the sound of it anyway)
Your options are (but not limited to):
Ignore the validation by telling the merge agent to skip over these and continue. If you look at the details of the merge agent job, you might see "-Validate 3" in there somewhere. Remove this and the merge agent will no longer stop if it finds errors in the validation process
Investigate why there are differences in the rowcounts, and if it only affects a small number of tables then look into using something like tablediff to create a script file that contains a bunch of insert statements
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply