Managing Configuration Items › Manage Staged Transactions › Populating the TWA › How to Use SQL to Update Data into the TWA › How to Set Transaction Status

Previous Topic: CI Identifiers in the TWA

Next Topic: How to Share Tables with CA SDM
How to Set Transaction Status

You can set the transaction status (tran_status) of each transaction in the TWA. For GRLoader to processes a transaction, it must be set to Ready (tran_status=1).

Value

Short Description

Long Description

0

Initial

Default value. Requires intervention to move to "Ready" in order for GRLoader to act upon this transaction

1

Ready

 

The transaction is ready to be loaded into either the appropriate CI or relationship tables

2

Successful

 

Transaction processed successfully

3

Warning

Warning detected during load into ca_owned_resource/bmhier

4

Error

Error detected during load into ca_owned_resource/bmhier

40000+

For customer use

 

If GRLoader –lftwa is run two or more times, the status is updated after the first run and all subsequent runs do not find any transactions. Reset the status of the ready transactions before every GRLoader –lftwa execution.

For information about how to represent XML data in the TWA tables, see the XML examples in previous sections.