Purpose (problem description)

This page troubleshoot the case when you get Transactions that have the status ADDED and the status DELETED:

Figure 1

Observed in CAST AIP
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
CSS1(tick)
Action Plan
  1. Check if the behavior is not due to the following corruption SQL Queries - CAST Central Base - Corruptions on Data Function - How to list and clean Data Functions that are targeting the same Object.
  2. If yes then apply the steps that cleanup this corruption then perform the below sub steps:
    1. Open TCC
    2. Go to Enhancement -> Data Function sub node.
    3. Recompute checksums and snapshots status.
    4. Observe that the issue is solved.
  3. Else, this behavior can be due to the fact that the object that is targeted by the Data Function have the status ADDED and DELETED, in order to check this, observe if the object of ROLE "DATA_RECORD" have the object status ADDED in the ADDED Data Function and have the status DELETED in the deleted Data Function
    Figure 2
  4. If you confirm this then the issue of ADDED/DELETED Data Function is due to the issue of ADDED/DELETED object, in order to investigate this refer to the following page CAST Engineering Dashboard - Object - Incorrect Object Status - Same object seen as added deleted
  5. Else contact CAST Technical support with the following Relevant input. For CAST Technical support only reproduce the issue by using the steps given in Transaction Configuration Center - Information - How to reproduce user issues

 

 

Notes/comments
 
Related Pages