Saturday 25 February 2012

Conflicts and "String and Binary Datawould be truncated"

I have an application using SQL Server 2000 and Delphi
for the front end. I have 2 SQL Server, on each side of a
WAN and 15 offline users with Laptops that sync using
Merge replication. This app has been running successfully
for about 6 months now.
Lately, I am getting a few conflicts from 3 of the 15
offline users saying that the row was inserted or updated
at the Laptop, but could not be updated or inserted at
the Server - String or Binary Data would be truncated.
The Merge agent reports no errors, saying that the
session succeeded. I have a Trigger that updates a
Datestamp field when the app makes an update, but I have
the "NOT FOR REPLICATION" line at the top. I do not get
the error using the app, only when the selected users
replicates. Out of 15 users, 3 are getting the message in
the conflicts screen.
Thanks for the Help.
Steve
Steve,
it could be a service pack issue. Have a look at
http://support.microsoft.com/default...icle%3D319258.
Also, you could do some logging from the trigger to a separate table, just
to confirm that it is/isn't firing during the replication process.
HTH,
Paul Ibison

No comments:

Post a Comment