Transaction Configuration center - Enhancement - Transactional Functions - Missing Transaction - Missing Transaction with the status DELETED

This page explains the case when you are waiting to get a Transaction with the status DELETED, but you are not able to observe the same under TCC:

Figure 1

Official documentation 

• CAST AIP 8.3 : TCC - Enhancement node - Right hand panel
• CAST AIP 8.2 : TCC - Enhancement node - Right hand panel
• CAST AIP 8.1 : TCC - EFP Calibration node - Right hand panel
• CAST AIP 8.0 : TCC - EFP Calibration node - Right hand panel  

 TKB page for Information Guides > Component of the feature Transaction Configuration Center TCC

Step by Step scenario

1. Connect to TCC.
2. Go to the node Enhancement > Transactional Functions.
3. Observe that there is a missing DELETED Transaction.

1. Check if the Transaction was present in a previous snapshot, for that refer to SQL Queries - CAST Central Base - SQL Queries on Transactions - How to retrieve the list of Transactions per snapshot

2. If the query return rows

   1. Get the Status of the Transaction associated with the latest snapshot from where the Transaction is shown, for that refer to SQL Queries - CAST Central Base - SQL Queries on Transactions - How to retrieve the status of Transactions per snapshot

   2. Get the latest snapshot of the application, for that refer to the following pages: SQL Queries - CAST Central Base - Queries on snapshots - How to get the ID and name of a snapshot for a given application and SQL Queries - CAST Central Base - Queries on applications - How to get the ID of the application

   3. If the latest snapshot of the application is greater than the latest snapshot from where the Transaction is shown, and if the Status of the Transaction was Deleted in the latest snapshot from where the Transaction is shown , then it is a normal behavior to not get the Transaction as Deleted in the current snapshot. In fact the Status of the Transaction takes to account the state of the Transaction between 2 successive snapshots, so if a Transaction was Deleted previously then it will be non existent currently. The Transaction was Deleted previously for one of the following reasons:

      1. 1. The Transaction is a Merged Transaction of Transactions Merge, you can check it by referring to SQL Queries - CAST Knowledge Base - Queries on Transactions - How to get the Main object of a Merged object in a Transaction Merge
         2. The Transaction is an Empty Transaction, you can validate then investigate the issue by referring to Transaction Configuration Center - AFP Calibration - Transactional Functions - Missing Links

3. Else if the query do not return rows then Run the following query under the central schema - Transaction_status_deleted. Replace <Transaction_ID> by the id of the Transaction.

   Query result example

   "doKfn"; 3; 

   Interpretation

    The query returns the Transaction name, the snapshot ID

   1. If the query returns rows then this is a bug, report the issue to CAST Technical Support and provide the relevant input

   2. Else If the query do not returns rows then, provide the justification of why you are waiting to get Transaction with the status DELETED then report the issue to CAST Technical Support and provide the relevant input

If the above steps do not resolve your issue, then contact CAST Technical Support with the following relevant input  

Ticket # 11005

Specify pages indirectly related to this topic.(eg:side- effects)