CAST Engineering Dashboard - Action Plan - Missing action plan objects - Action plan from prior snapshot is missing in new snapshot

Purpose (problem description)

 This page handles the problem when the objects in the action plan view disappears after running a new snapshot. 

Figure 1


Observed in CAST AIP


Release
Yes/No
8.3.x(tick)
Observed on RDBMS


RDBMS
Yes/No
CSS (tick)

Step by Step scenario

  • Run a snapshot n-1
  • Run a new snapshot n
  • Open the dashboard and go to the view Improvement - Action Plan
  • You might see all objects or some objects have disappeared

Action Plan

To troubleshoot this issue, you need the following Relevant input

Perform the below actions:

  1. If you have added an Object ObjectA in Snapshot3 to action plan and if you delete Snapshot3 then the ObjectA will not exist in the Action Plan of snapshots that were generated before Snapshot3 (which is deleted) .
    The ObjectA will reappear in Snapshot4 or Snapshot5 if the snapshot date of Snapshot4 or Snapshot5 is greater than Snapshot3 (which is deleted). The object ObjectA will not appear in Acttion plan of Snapshot4 or Snapshot5 if their snapshot dates are before Snapshot3 (which is deleted) .

    If your case does not match the above explanation then go to next step
  2. From previous snapshot (snapshot n-1), Check if you are using action plan optimizer
    1. If you are using Action plan optimizer which is in BETA, the issue is out of scope of CAST Technical Support
    2. If you are not using action plan optimizer, then goto next step
  3. Check if the objects that were added to Action plan in snapshot n-1 is present in Snapshot n
    1. If the objects are existing in snapshot n then contact CAST Technical Support with the Relevant input
    2. If the objects are not existing in snapshot n then check if the object is present in the list of added as well as deleted artifacts list in the comparison view
      1. If the object is present in both added as well as deleted list then follow the troubleshooting guide CAST Engineering Dashboard - Object - Incorrect Object Status - Same object seen as added deleted
      2. If the object is not present in both the lists then contact CAST Technical Support with the Relevant input

Relevant input

  • Screenshots from the dashboard (snapshot n-1) with a full URL showing an example of object that you can see on the Action plan

  • Screenshots from the dashboard (snapshot n) with a full URL without the object seen in snapshot n-1

  • Sherlock export with the following options: Export CAST Bases

Check if you are using action plan optimizer

For checking if you are using action plan optimizer, go to the comment column of the view Improvement - Action Plan.

Figure 2


 

Check if the objects that were added to Action plan in snapshot n-1 is present in Snapshot n

Run the below query of the Central Database -

select dos.object_id,dos.object_name from dss_object_info doi
join viewer_action_plans vap
on doi.object_id = vap.object_id
and doi.snapshot_id = <snapshot_id>
join dss_objects DOS
on vap.object_id = dos.object_id
and dos.object_id = doi.object_id
and dos.object_name like '<object_name>';

To get the snapshot_id please refer to the page - SQL Queries - CAST Central Base - Queries on snapshots - How to get the ID and name of a snapshot for a given application

Example -

If you cannot see objectA in the action plan view then execute the below query -

Example
select dos.object_id,dos.object_name from dss_object_info doi
join viewer_action_plans vap
on doi.object_id = vap.object_id
and doi.snapshot_id = 33
join dss_objects DOS
on vap.object_id = dos.object_id
and dos.object_id = doi.object_id
and dos.object_name like 'objectA';
 
Result -
object_id;object_name
1244;ObjectA
 
This means that ObjectA that was added in Snanshot < 33 still exists in the recent snapshot - 33

If the above query returns rows then the object exists in snapshot n, if it does not return any row then it means that the object is not present in snapshot n

Notes/comments

Ticket # 5401,7115

Related Pages