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

Replication concept

Hi,
I got a new application with Access front end and sql server back-end. This
application has replication features where users can directly upload their
changes on the main server. I have no knowledge about replication. However, I
need to maintain this sytem. Is there any article or book that will help me
achieve this? Please let me know. Thanks in advance.
Are you sure that this is being replicated? If users are sending their access
changes to sql server, it sounds like this might be the way that the Access
application is designed, and not SQL Server replication. If it is somehow SQL
Server Replication, then there are 2 books out there (see
www.replicationanswers.com for links on homepage) and books on line (BOL).
Cheers,
Paul Ibison
|||Thanks Paul for your advise. I appreciate it.
Best Regards,
"Paul Ibison" wrote:

> Are you sure that this is being replicated? If users are sending their access
> changes to sql server, it sounds like this might be the way that the Access
> application is designed, and not SQL Server replication. If it is somehow SQL
> Server Replication, then there are 2 books out there (see
> www.replicationanswers.com for links on homepage) and books on line (BOL).
> Cheers,
> Paul Ibison
>
|||Hope the books help, but I'd check first of all verify that you do have
replication occurring. It's possible that heterogenous subscribers have been
configured so your Access database is a subscriber to a SQL Server publisher,
and the uploading of changes in Access is a triggering of the synchronization
process (starting the ActiveX control to merge a pull subscription). Having a
look at the SQL Server box should show if this is the case and if so, looking
for heterogenous subscribers in BOL should help.
Paul Ibison
|||I would check to see if they have linked tables or if they have code in the
access project to write to SQL Server.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:2F158A54-ACE0-4C5B-913E-AD13C89DEF19@.microsoft.com...
> Hi,
> I got a new application with Access front end and sql server back-end.
> This
> application has replication features where users can directly upload their
> changes on the main server. I have no knowledge about replication.
> However, I
> need to maintain this sytem. Is there any article or book that will help
> me
> achieve this? Please let me know. Thanks in advance.
>