Article ID: 280684 - View products that this article applies to.
This article was previously published under Q280684
When you assign a blank value to an image column table that is part of merge replication, the Merge agent may fail with the following error message:
This behavior only happens when the image column is updated to an empty string value such as "" on either the Publishing or Subscribing merge table.
The process could not enumerate changes at the Subscriber.
Full Message: Invalid argument value
You can check whether you have an empty string value in your image column by viewing the binary value stored in the image column. A binary value of "0x" indicates an empty string value.
This error message occurs because of an incorrect data conversion by the SQLGetData ODBC driver function. The SQLGetData function incorrectly interprets a blank value stored in the image column.
Avoid assigning empty string values ("") to the image columns.
To resolve this merge agent error, UPDATE the image column to a non-empty string value such as NULL or to an actual string value.
Steps to Reproduce Problem