Determines how Replication Agent trigger errors are handled in the primary database.
false
true – If an error occurs during trigger execution, the error is logged in the exceptions table and the transaction in the primary database continues without being recorded in the Replication Agent transaction log.
false – If an error occurs during trigger execution, the transaction in the primary database fails, reporting the error to the entity that submitted the transaction.
When the value of the pdb_exception_handling parameter is true, trigger errors are logged in the Replication Agent exceptions table, and transactions against the marked object are allowed to continue without being captured in the Replication Agent transaction log. Although replication fails for all marked objects, the operation of the primary database is not interrupted by the failure of a Replication Agent trigger.
If the value of the pdb_exception_handling parameter
is true and replication is interrupted by a trigger
error, transactions will continue to occur in the primary database,
but they will not be replicated. When transactions
in the primary database are not replicated, the replicate database
must be rematerialized before replication can resume.
Once replication is interrupted by the failure of a Replication Agent trigger, it cannot be resumed until the cause of the trigger error is corrected.
When the value of the pdb_exception_handling parameter is false, a trigger error will cause the transaction in the primary database to fail. The primary database reports the transaction failure to the entity that submitted the transaction. Although operation of the primary database is interrupted, the integrity of the replication system is not adversely affected (no transactions can occur without being replicated).
If maintaining the availability of the primary database is a higher priority than maintaining integrity of the replicate database, set the value of the pdb_exception_handling parameter to true.
If maintaining the integrity of the replicate database is a higher priority than maintaining the availability of the primary database, set the value of the pdb_exception_handling parameter to false.
