solidDB Help : solidDB reference : SQL: Database system tables and system views : Synchronization-related views : SYNC_FAILED_MESSAGES
  
SYNC_FAILED_MESSAGES
The SYNC_FAILED_MESSAGES view is in the master database and holds information about messages received from the replica. It is possible to view all necessary information about failed messages using the following query:
SELECT * FROM SYNC_FAILED_MESSAGES
The columns in the SYNC_FAILED_MESSAGES view are described in the following table:
 
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.
Go up to
Synchronization-related views