Replication Error: 4138

If our subcribers try to synchronize the following error occurs. The Upload of the data works but the download failes.

Error messages:
The merge process was unable to perform data validation on
article 'tbl_xTableFieldValue'. Check for SQL Server
errors in the Windows application event log or retry at a
later time. (Source: MSSQL_REPL, Error number:
MSSQL_REPL2147766343)
Get help: http://help/MSSQL_REPL2147766343

Conflicting locking hints are specified for
table "fncReplicationFilterTableFieldValue". This may be
caused by a conflicting hint specified for a view.
(Source: MSSQLServer, Error number: 4138)
Get help: http://help/4138

What does this mean and how can we resolve this?

Best regards,
Markus

This error means that when the merge agent attempted to validate that the replicated data at the Publisher and Subscriber was the same, it was not the same. From the "Validating Replicated Data" topic in SQL Server Books Online:

"Is the fact that validation failed an issue for your application? If the validation failure is an issue, manually update the data so that it is synchronized, or reinitialize the subscription:

"Data can be updated using the tablediff Utility. For more information about using this utility, see How to: Compare Replicated Tables for Differences (Replication Programming).

"For more information about reinitializaton, see Reinitializing a Subscription."

Phillip Garding
Senior Program Manager
Microsoft SQL Server Replication Management Tools

sql