Column name
|
Description
|
---|---|
Partno
|
Message part number
|
Type
|
The type of result set row. Possible types are:
0: Message part start
1: This type is not in use
2: The message was a propagation message and the status of that operation is stored in the return message
3: Task
4: Subscription task
5: Type of refresh (FULL or INCREMENTAL)
6: MESSAGE DELETE status
|
Masterid
|
Master ID
|
Msgid
|
Message ID
|
Errcode
|
Message error code. Zero if successful.
|
Errstr
|
Message error string. NULL is successful.
|
Insertcount
|
Number of inserted rows to replica.
Type=3: Total number of insert
Type=4: Row inserts restored from replica history to replica base table
Type=5: Insert operations received from master
|
Deletecount
|
Type = 3: Total number of deletes
Type = 4: Row deletes restored from replica base table
Type = 5: Delete operations received from master
|
Bytecount
|
Size of message in bytes. Indicated in result received from command MESSAGE END. Otherwise 0.
|
Info
|
Information of the current task.
|
|
Type = 0: then Message name
|
|
Type = 3: Publication name
|
|
Type = 4: Table name
|
|
Type = 5: FULL/INCREMENTAL
|
Error code
|
Description
|
---|---|
13XXX
|
Table level error
|
21XXX
|
Communication error
|
10006
|
Concurrency conflict (simultaneous other operation)
|
13047
|
No privilege for operation
|
13056
|
Insert not allowed for pseudo column
|
25005
|
Message message_name is already active
|
25013
|
Message name message_name not found
|
25018
|
Illegal message state
In the replica, the message can only be executed using the MESSAGE FORWARD statement if the message is ended and the ending transaction is committed.
|
25024
|
Master not defined
This message is produced if double quotation marks, rather than single quotation marks, are used around the connect_string in a MESSAGE FORWARD statement.
For example, if the master node is given the node name “master” (which is a reserved word and therefore should be delimited by double quotation marks), and if that node’s connect string is:
tcp localhost 1315
then the MESSAGE statements shown below are correct:
--On the replica
... --double quotation marks MESSAGE msg1 BEGIN TO "master"; ... --single quotation marks MESSAGE msg2 FORWARD TO 'tcp localhost 1315'; Note that the MESSAGE BEGIN statement defines (within the replica server) what the node name of the master is. The MESSAGE FORWARD statement may contain the connect string to the server.
|
25026
|
Not a valid master user
|
25031
|
Transaction is active, operation failed
|
25035
|
Message message_name is in use.
A user is currently creating or forwarding this message.
|
25040
|
User id user_id is not found.
While executing a message reply an attempt to map a master user to a local replica id failed.
|
25041
|
Subscription to publication publication_name not found
|
25048
|
Publication publication_name request info not found
|
25052
|
Failed to set node name to node_name.
|
25054
|
Table table_name is not set for synchronization history
|
25055
|
Connect information is allowed only when not registered
The connect info in MESSAGE message_name FORWARD TO connect_info options is allowed only if the replica has not yet been registered to the master database.
|
25056
|
Autocommit not allowed
|
25057
|
The replica database has already been registered to a master database
|
25057
|
The replica database has already been registered to a master database
|
25060
|
Column column_name does not exist on publication publication_name resultset in table table_name
|
Error code
|
Description
|
---|---|
13XXX
|
Table level error
|
13124
|
User id num not found
This message is generated, for example, if the user has been dropped.
|
25016
|
Message not found, replica ID replica_id, message ID message_id
|
25056
|
Autocommit not allowed
|