The replication process begins with subscription materialization, which is the process by which data is first copied to the destination database. When you no longer want a subscription replicated to a destination database, you dematerialize the subscription at the destination database. Dematerialization is the process by which data is deleted from the destination database. Subscription failures occur when materialization or dematerialization fails.
Usually, the person who is conducting the materialization or dematerialization monitors the operation and reports any problems.
Subscription problem symptoms are easily identified and include:
Materialization failure – no data in the subscription’s replicate table at the destination database, the status for subscriptions at the primary and replicate Replication Servers is not Valid, or materialization has been taking longer than is reasonable.
Dematerialization failure – data still exists in the subscription’s replicate table at the destination database, the status for subscriptions at the primary and replicate Replication Servers is not Invalid, or dematerialization has been taking longer than is reasonable.
Some subscription problem symptoms are displayed as error messages in the Replication Server error log. You might also need to use the diagnostic tools to identify subscription problem symptoms. For more information about subscription problems, see “Troubleshooting subscription failures”.
If you are having problems with customized function strings, which can be used to replicate changes, you might have used incorrect variables. Here are the restrictions:
Pre-11.0.2 release Replication Server function strings can use system-defined variables. Function-string class scope functions cannot use the defaults.
Only function strings for rs_insert and rs_update can use new column values.
Only function strings for rs_delete and rs_update can use old column values.
Only function strings for rs_select and rs_select_with_lock can have input templates. Only they can use user-defined variables.
Only function strings for user-defined functions can use parameter values of functions. The parameter value of a function consists of the parameters passed to a replicated stored procedure.