When the RepAgent shuts down because a text or image column has a status of replicate_if_changed at the Adaptive Server database and always_replicate in the replication definition, you must change the replication status so that they match, for example, either:
Replicate text, unitext, or image columns only when their values change, or
Always replicate text, unitext, or image columns.
To replicate text, unitext, or image columns only when their values change:
Execute the alter replication definition command at the primary Replication Server and change the status of the text, unitext, or image columns to replicate_if_changed. Wait for the modified replication definition to arrive at the replicate sites.
Restart the RepAgent.
To always replicate text, unitext, or image columns:
Stop updates at the primary table.
Execute the alter replication definition command at the primary Replication Server, and change the status of the text, unitext, or image columns to replicate_if_changed. Wait for the modified replication definition to arrive at the replicate sites.
Restart the RepAgent to let transactions with a replicate_if_changed status finish processing.
Execute the sp_setrepcol system procedure at the Adaptive Server and change the status to always_replicate.
Execute alter replication definition at the primary Replication Server and change the status of the text, unitext, or image columns to always_replicate. Wait for the modified replication definition to be replicated to the replicate sites.
Resume updates to the primary table.
