Missing Column Values

Missing column values may result from several Replication Server configurations.

Some column values may be missing at the replicate table if:

Row migration occurs in a subscription that has a where. See Row Migration in the Replication Server Administration Guide Volume 1.
You enable autocorrection for each replication definition. See Nonatomic Materialization and Autocorrection for Nonatomic Materialization in the Replication Server Administration Guide Volume 1.
You set dsi_command_convert to u2di to convert commands. See Command Conversion in the Replication Server Administration Guide Volume 2.
You customize the rs_update system function to execute an insert operation. See Customize Database Operations in the Replication Server Administration Guide Volume 2.

To prevent missing column values, enable the ra_set_autocorrection Replication Agent command to allow Replication Agent to send the values for all columns to the downstream Replication Server:

ra_set_autocorrection tablename, enable

Note: Enabling ra_set_autocorrection can impact replication performance and may not prevent missing LOB values in columns in the replicate database.

See ra_set_autocorrection in the Replication Agent Reference Manual.