SQL Guide : Database system tables and system views : Synchronization-related views : SYNC_FAILED_MESSAGES
  
SYNC_FAILED_MESSAGES
This table is on the master and holds information about messages received from the replica. It is possible to view all necessary information about failed messages using one simple view: SELECT * FROM SYNC_FAILED_MESSAGES.
This returns the following columns:
Column name
Data type
Description
REPLICA_NAME
WVARCHAR
Given node name of the replica from which the message was sent.
MESSAGE_NAME
WVARCHAR
Name of the message given by the user.
TRANSACTION_ID
BINARY
Internal ID of the replica transaction that has failed.
STATEMENT_ID
INTEGER
Sequence number of the statement within the transaction.
STATEMENT_STRING
WVARCHAR
SQL statement as a string.
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.
See also
Synchronization-related views