Missing Columns When You Create the Standby Database

When you create a standby database for an existing database that has replication definitions, missing columns may result under a certain combination of circumstances.

Missing columns may result under the following combination of circumstances:

Although, by default, a standby database is supposed to receive all columns, at the time the transaction began, the standby database did not exist. Replication Server would have discarded values for columns not in the replication definition. If a column is not in the replication definition and the standby database allows a null value for the column, the row can be inserted into or updated in the standby database without the missing value. Otherwise, you must reconcile the databases yourself.