Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix A Database Schema Definition : Audit Schema Details : BC_TRANSACTIONS

BC_TRANSACTIONS
Details for the table BC_TRANSACTIONS are explained in Table 16.
The column BC_TRANS_ID is a GUID generated by TIBCO BusinessConnect that holds the last STATUS of the transaction from the partner or from the messages sent from the private process. The column STARTDATE is stamped when the first entry is inserted, and TS column is updated every time a child row is inserted in the BC_MESSAGES table.
Depending on the business protocol type (such as TIBCO BusinessConnect™ EDI Protocol powered by Instream®, TIBCO BusinessConnect Services Plug-in, TIBCO BusinessConnect™ ebXML Protocol, TIBCO BusinessConnect™ RosettaNet Protocol, TIBCO BusinessConnect™ SOAP Protocol) or the startup of the TIBCO BusinessConnect Gateway engines, various column values are populated differently in order to show the views differently when looked from the TIBCO Administrator UI.
Usage of the AUX columns is completely governed by individual business protocols or Gateway instances, while the log viewer for individual plug-ins generates a screen layout based on the metadata of these plug-ins.
Users who archive the BC_TRANSACTIONS data should query based on the STATUS column and the TS column, which would give all the transactions between the dates specified for certain STATUSes.
Note: This table will grow based on the exchanged transactions, as well as the number of times the Gateway instances are restarted.
This table should be added as a part of the archiving process; for example, a search for Select * from BC_TRANSACTIONS where STATUS is such as %COMPLETED% OR %ERROR% and TS is <from Date> .
Columns summary for the table BC_TRANSACTIONS is shown in Table 17.
Indices information for the table BC_TRANSACTIONS is shown in Table 18 and Table 19.
Relationship information for the table BC_TRANSACTIONS is shown in Table 20.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved