TIBEDI_BATCH_TX

Details for the table TIBEDI_BATCH_TX are explained in the table below:

TIBEDI_BATCH_TX
Name Value
Data Model Physical
Documentation

This table stores the metadata for each transaction that is triggered when batching is enabled for any of the protocols. This records data such as the trading partner name, time stamp, interchange header, and group related data. It also has a reference to the record in TIBEDI_BATCH_TX_BIN (BININDEX) which has the actual transaction EDI document and TIBEDI_BATCH_TASK (BATCHID).

Note: Note: This table will grow based on the exchanged transactions. This table should be added as a part of the archiving process.

A typical sample archive query for an Oracle database is shown below:

Select * from TIBEDI_BATCH_TX where STATUS like '%COMPLETED%' OR
'%ERROR%' AND TS <= TO_TIMESTAMP(<from date>, 'YYYY-MM-DD
HH24:MI:SS.FF') AND TS >= TO_TIMESTAMP(<to date>,'YYYY-MM-DD
HH24:MI:SS.FF')
A typical sample archive query for Microsoft SQL database is shown below:
Select * from TIBEDI_BATCH_TX where STATUS like '%COMPLETED%' or
'%ERROR%' and PROTOCOLNAME = '<protocol>' AND TS <= '<to date>'
and TS >= '<from date>
User IDLast Numeric Value 0
DDLClause

BININDEX NUMBER(18) PRIMARY KEY, TRANSPORTINGTP VARCHAR2(128), INTERCHANGEHEADER VARCHAR2(256), GROUPHEADER VARCHAR2(256),

BATCHID VARCHAR2(255) NULL,

STATUS VARCHAR2(64) NULL,

PROTOCOLNAME VARCHAR2(32) NULL, INSTALLATIONNAME VARCHAR2(32) NULL, PROTOCOLVERSION VARCHAR2(32) NULL, OPERATIONID VARCHAR2(512) NULL,

DOCUMENTID VARCHAR2(512) NULL,

DOCUMENTTYPE VARCHAR2(32) NULL,

TPNAME VARCHAR2(128) NULL,

TPDOMAIN VARCHAR2(32) NULL,

TPID VARCHAR2(32) NULL,

HOSTNAME VARCHAR2(128) NULL,

HOSTDOMAIN VARCHAR2(32) NULL,

HOSTID VARCHAR2(32) NULL,

HOSTINITIATES VARCHAR2(5) NULL,

CAQHOBJ BLOB NULL,

TS TIMESTAMP DEFAULT SYSTIMESTAMP, LOGCONTEXTID VARCHAR2(512) NULL,

CONSTRAINT TIBEDI_BCH_TX_FKEY FOREIGN KEY (BATCHID) REFERENCES TIBEDI_BATCH_TASK(BATCHID) ON DELETE CASCADE

Columns summary for the table TIBEDI_BATCH_TX is shown in the below table:

TIBEDI_BATCH_TX: Columns Summary
Name Data Type Constraints Nullable Documentation
BININDEX number(18) PK No Uniquely generated by TIBCO BusinessConnect Container Edition.
TRANSPORTINGTP varchar2(128)   No Transporting Trading Partner Name.
INTERCHANGEHEADER varchar2(256)   No Has basic interchange header information.
GROUPHEADER varchar2(256)   No Has basic group header information.
BATCHID varchar2(255)   Yes Refers to the BATCHID in TIBEDI_BATCH_TASK table.
STATUS varchar2(64)   Yes Status of the batch and transaction.
PROTOCOLNAME varchar2(32)   Yes Protocol name.
INSTALLATIONNAME varchar2(32)   Yes BusinessConnect Container Edition Admin Installation name.
PROTOCOLVERSION varchar2(32)   Yes Protocol version.
OPERATIONID varchar2(512)   Yes Basic operation ID.
DOCUMENTID varchar2(512)   Yes Document ID generated for each batching transaction.
DOCUMENTTYPE varchar2(32)   Yes Similar to Operation ID.
TPNAME varchar2(128)   Yes Name of the Trading Partner
TPDOMAIN varchar2(32)   Yes Domain name of the Trading Partner.
TPID varchar2(32)   Yes ID of the Trading Partner.
HOSTNAME varchar2(32)   Yes Name of the Host.
HOSTDOMAIN varchar2(32)   Yes Domain name of the Host.
HOSTID varchar2(32)   Yes ID of the HOST.
HOSTINITIATES varchar2(5)   Yes Becomes true if generated from the machine where BCCE is installed.
TS TIMESTAMP   No The time at which the message is sent.
LOGCONTEXTID varchar2(512)   Yes Save the value of BC_TRANS_ID column value of BC_TRANSACTIONS table.