SQL Guide : Database system tables and system views : System tables for data synchronization : SYS_SYNC_MASTER_MSGINFO
  
SYS_SYNC_MASTER_MSGINFO
This table contains information about the currently active message in the master database.
Data in this table is used to control the synchronization process between the replica and master database. This table also contains information that is useful for troubleshooting purposes. If the execution of a message halts in the master database due to an error, you can query this table to obtain the reason for the problem, as well as the transaction and statement that caused the error.
Column name
Description
STATE
Current state of the message. The following values are possible:
0 = DELETED N/A (internal non-persistent state)
1 = ERROR - Error has occurred during message processing; the reason for the error was recorded in the error-columns of the row.
10 = RECEIVED - master has received a message from the replica
11 = SAVED - message has been saved in the master database and is being processed
12 = READY - master has processed the message
13 = SENT - N/A (internal non-persistent state)
REPLICA_ID
ID of the replica database from which the message was sent.
MASTER_ID
ID of the database to which the master is sent.
MSG_ID
Internal ID of the message.
MSG_NAME
Name of the message given by the user.
MSG_TIME
Create time of the message.
MSG_BYTE_COUNT
Size of the message in bytes.
CREATE_UID
ID of the user who created the message.
FORWARD_UID
ID of the user who forwarded the message.
ERROR_CODE
Code of the error that caused the termination of the message execution. You can determine the transaction and statement that caused the error from the TRX_ID and STMT_ID information.
ERROR_TEXT
Description of the error that caused the termination of the message execution.
TRX_ID
Sequence number of the transaction that caused the error.
STMT_ID
Sequence number of the statement of a transaction that caused an error.
ORD_ID_COUNT
N/A (internal use only).
ORD_ID
N/A (internal use only).
FLAGS
NULL or 0 = Normal message.
1 = Message is deleted when reply is sent to replica.
FAILED_MSG_ID
This is an INTEGER column which is part of the primary key. The value is zero for normal messages. The value is msg_id if LOG_ERRORS option is ON and any errors exists.
See also
System tables for data synchronization