SQL Guide : Database system tables and system views : System tables for data synchronization : SYS_SYNC_REPLICA_MSGINFO
  
SYS_SYNC_REPLICA_MSGINFO
This table contains information about currently active messages in the replica 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 replica 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 - Internal error has occurred during message processing; the reason for the error was recorded in the error-columns of the row.
20 = R_INIT - N/A (internal non-persistent state)
21 = R_INITEND - N/A (internal non-persistent state)
22 = R_SAVED - Replica has saved an outgoing message
23 = R_SENT - Replica has sent a message to the master
24 = R_RECEIVED - Replica has received a reply message from the master
25 = R_EXECUTE - The reply message in a replica is ready for execution
26 = R_EXECUTE_NOTIFYMASTER - Replica has received a reply, but not yet confirmed it with the master
MASTER_ID
ID of the master database to which the message is sent.
MASTER_NAME
Name of the master database to which the message 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 sent the message.
ERROR_CODE
Code of the error that caused the message execution to terminate.
ERROR_TEXT
Description of the error that caused the message execution to terminate.
FLAGS
NULL or 0 = Normal message.
1 = Message is deleted when a reply is received from master.
3 = Message is a registration message.
See also
System tables for data synchronization