Provides information for troubleshooting atomic, nonatomic, bulk, and other common materialization problems.
Incorrect or Missing Login Account and Permissions
Many problems with materialization are due to incorrect or missing permissions in primary or replicate databases. Error messages that identify these problems are reported in the replicate Replication Server error log.
Schema Inconsistency
Materialization problems can result from schema inconsistencies at the primary database, Replication Server, and the replicate database. Error messages that identify these problems are reported in the replicate Replication Server error log.
Missing interfaces File Entries
Login attempts may fail due to missing interfaces file entries. The message that identifies this materialization problem appears in the replicate Replication Server error log.
Bulk-Materialization Problems
Fix bulk-materialization problems that occur during the definition, activation, and validation phases based on the status returned by check subscription.