January 27, 2006 at 9:13 am
My merge agent is failing during the bulk copy of one of the tables with error message is "Expected the data length in data stream for bulkcopy of text, ntext, or image data." Error number 4813.
I looked this up and the only plausible finding was that my text columns may have null or zero-length data in them and I should correct it and run the snapshot again.
I'm working with a database schema that replicates fine and is a standard for my company's customer, so that this customer is having problems makes me think I got a bad piece of data in there. I just don't know how to identify it. The table the merge agent fails on has 5 text columns, 4 of which allow nulls which as I said works fine everywhere else except this site. I did a search on the one column that doesn't allow nulls for any null in it and it returned 0. Am I going on the right path? An other ideas to try?
I also found a source that said to change the replication option for the subscription to Insert using ODBC and that the option is under the subscription destination table, but I'm not finding where that configuration would be in Enterprise Mgr.
January 27, 2006 at 9:47 am
More info, prior to this error I have:
"Cannot insert duplicate row key in object 'sysmergeschemachange' with unique index 'schemachangeversion'.
I can't find any duplicates (unless I'm looking in the wrong place), and this is a new pull subscription, so the database it's going to is being generated by it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply