Adaptive Server text, image, and rawobject status: do_not_replicate
Replication definition text, image, and rawobject status: always_replicate or replicate_if_changed
When the Replication Server reports that the status of a text, image, or rawobject column is do_not_replicate at the Adaptive Server database and the replication definition includes that column for replication and specifies either always_replicate or replicate_if_changed, take the following steps to resolve inconsistencies.
If you do not want to replicate text, image, or rawobject columns:
Stop updates to the primary table.
Drop subscriptions to the replication definition.
Drop the replication definition.
Re-create the replication definition without the text, image, or rawobject columns, and re-create subscriptions.
Resume updates to the primary table.
If you do want to replicate text, image, or rawobject columns:
Execute sp_setrepcol at the Adaptive Server database and change the status of the text, image, or rawobject column to always_replicate or replicate_if_changed. It should match the status in the replication definition.
Wait for subsequent transactions that modify the text, image, or rawobject column to be processed by the Replication Server.
Consider correcting any inconsistencies with the rs_subcmp program. See “Verifying subscription consistency” for more information.
