Another normalization error occurs when there are inconsistencies in the replication status of text, unitext, or image columns between the Adaptive Server database and the replication definition. Replication Server error 32046 is displayed in the Adaptive Server error log (for RepAgent):
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 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 the Adaptive Server database and in the replication definition, then 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).
Use the following procedures to resolve replication status inconsistencies for text, unitext, or image column status and to resume operations after the RepAgent has shut down.
