Inconsistencies in the replication status of text, unitext, or image columns between the Adaptive Server database and the replication definition.
Message: 32046 -- ’The status of column ’%s’ in repdef is inconsistent with that of the LTL command.’
The replication status for text, unitext, and image columns in the Adaptive Server database is carried in the modification Log Transfer Language (LTL) commands that the RepAgent sends to the Replication Server. If the status of a text, unitext, or image column is not the same in both the Adaptive Server database and the replication definition, Replication Server detects the inconsistency when the modification is being replicated, and the RepAgent shuts down.
If a text, unitext, or image column has a status of do_not_replicate at the Adaptive Server database and the replication definition includes that column for replication, processing continues and the Replication Server sends the modifications to the replicate database without the text, unitext, or image data. The Replication Server records a warning message in the Adaptive Server error log (for the RepAgent).
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.
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 sp_setrepcol 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.
Execute sp_setrepcol at the Adaptive Server database and change the status of the text, unitext, or image 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, unitext, or image column to be processed by the Replication Server.
Consider correcting any inconsistencies with the rs_subcmp program.