SYNC_FAILED_MASTER

SQL Guide : Database system tables and system views : Synchronization-related views : SYNC_FAILED_MASTER_MESSAGES

SYNC_FAILED_MASTER_MESSAGES

This table is on the replica and holds information about messages sent to the master. It is possible to view all necessary information about failed messages using one simple view:

SELECT * FROM SYNC_FAILED_MASTER_MESSAGES

This returns the following columns:

Column name	Data type	Description
MASTER_NAME	WVARCHAR	Given node name of the master.
MESSAGE_NAME	WVARCHAR	Name of the message given by user.
ERROR_CODE	INTEGER	Code of the error that caused the termination of the message execution.
ERROR_MESSAGE	VARCHAR	Description of the error.

All users have access to this view; no particular privileges are required.