Fix direct load materialization problems that occur during the definition, activation, and validation phases based on the status returned by check subscription.
Status at Replicate Replication Server |
Problem |
Suggested Actions |
---|---|---|
Materialized |
A subscription stays at the MATERIALIZED state. |
Verify that Replication Agent is running. Make sure that the replication path is correct, either by replicating to another subscription which is already in the VALID state or by using the rs_ticket stored procedure. |
Error |
The primary or replicate replication definition datatype or column length is inconsistent. |
Check the replicate Replication Server log, and check the datatype and column lengths. Correct the problem, drop the subscription, delete data at the replicate, and recreate the subscription. |