XML Tags

XML tags are used in ATS and RIS files that are generated in XML format.

Table 1. XML tags in ATS and RIS files
Tag name Description Attributes Parent tag Child tags
ERFILE Top level tag for ATS and RIS files version: XML file format version number. None ATS

RIS
ATS Parent tag for ATS files version: ATS file format version number. ERFILE

TRANSACTION

ATSROWS
RIS Parent tag for RIS files
  • version: RIS file format version number.
  • fromSource: Set to true if the RIS file is generated at the source server.
ERFILE

SOURCE

TARGET

RISROWS

TXNABORTED

TXNCOMMITTED
TRANSACTION Contains the name of the RIS file (if it exists) and the number of rows processed before the transaction was aborted.
  • RISFile: The name of the RIS file, if it was created.
  • generateRISFile: Set to true if an RIS file exists for this aborted transaction.
  • processedRows: Number of rows processed before the transaction was aborted.
 ATS

SOURCE

TARGET

MESSAGE

CDRERROR

SQLERROR

ISAMERROR

SPLCODE
ATSROWS Contains the replicated aborted rows None ATS ATSROW
SOURCE Contains source server information
  • id: Server ID.
  • name: Server group name.
  • commitTime: Transaction commit time.

TRANSACTION

RIS

 None
TARGET Contains target server information
  • id: Server ID.
  • name: Server group name.
  • receiveTime: Transaction receive time.

TRANSACTION

RIS

 None
SQLERROR Contains the SQL error code num: Error number.

TRANSACTION

RISROW

 None
ISAMERROR Contains the ISAM error code num: Error number.

TRANSACTION

RISROW

 None
CDRERROR Contains the data sync error code
  • num: Error number.
  • description: Error description.

TRANSACTION

RISROW

 None
MESSAGE Contains the notification message None

TRANSACTION

RISROW

 None
SPLCODE Contains the SPL code number if a stored procedure conflict rule is being used num: SPL code number.

TRANSACTION

RISROW

 None
RISROWS Contains the local and replicated aborted rows None RIS RISROW
RISROW Contains information about local or replicated row data for one aborted row
  • num: Row sequence number.
  • replicateID: Replicate ID.
  • database: Database name.
  • owner: Table owner name.
  • table: Table name.
  • operation: DML operation type.
 RISROWS

MESSAGE

CDRERROR

SQLERROR

ISAMERROR

SPLCODE

MESSAGE

LOCAL

REPLICATED
LOCAL Contains the local row data for an aborted row None RISROW

SHADOWCOLUMNS

DATA
REPLICATED Contains replicated row data for an aborted row None

ATSROW

RISROW

SHADOWCOLUMNS

DATA
ATSROW Contains information for one replicated aborted row
  • num: Row sequence number.
  • replicateID: Replicate ID.
  • database: Database name.
  • owner: Table owner name.
  • table: Table name.
  • operation: DML operation type.
 ATSROWS REPLICATED
SHADOWCOLUMNS Optional shadow column values for local and replicated rows
  • serverID: Server ID.
  • serverName: Server group name.
  • cdrTimeInt: The cdrtime column value in integer format (GMT time).
  • cdrTimeString: Time in string format. For example: 2008-11-08T20:16:25.

LOCAL

REPLICATED

 None
DATA Contains aborted row data dataExists: Identifies whether data exists for this row or not.

ATSROW

RISROW

 COLUMN
COLUMN Contains column data for an aborted row
  • name: The column name.
  • dataExists: Identifies whether data is displayed for this column or not.
  • isLOBorUDT: Set to true if the column is of type UDT, smart large object or simple large object. If set to true, data for the column is skipped and the dataExists value is set to false.
  • isHex: Set to true if column data is displayed in hex format because Enterprise Replication does not have enough information to interpret the row data.
  • isNull: Set to true if the column value is NULL. Set to false if the column has a valid value or an empty string.
 DATA None
TXNABORTED Indicates that the replicated transaction was aborted
  • ATSFile: The name of the ATS file if the transaction was aborted and an ATS file was created for this aborted row.
  • generateATSFile: Set to true if an ATS file was created.
  • TxnErr: Error description for the aborted transaction.
 RIS None
TXNCOMMITTED Indicates that the replicated transaction was committed totalRows: Total number of rows processed. RIS None