CAST Engineering Dashboard - Exclusion - Excluded Objects reappears on dashboard- Objects excluded in previous snapshot still appears in current snapshot- exclusion object id issue

Description

The dashboard does not display exclusions that have been previously entered for an object.

The exclusion previously entered in a prior snapshot would look like this in the dashboard:

Later after subsequent snapshots and analysis, the exclusion that was done for this object -

Observed in CAST AIP

 

Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS (tick)
Step by Step Scenario

Below is the step-by-step scenario leading to the problem:

  • An exclusion was entered for an item in a previous snapshot.
  • The current dashboard no longer shows the exclusion.
Impact of the Problem

The impact of the problem on the analysis or the dashboard is:  Object that was previously excluded is still shown in the dashboard in current snapshot.

Action Plan

  1. Check if the ID of the object excluded in previous snapshot is same as the ID of the object not excluded in current snapshot . If the object does not have two different IDs and if the object is included in the list of exclusion and yet it is not appearing on the CED then please contact CAST Technical Support with Relevant Inputs

  2. Else if the object does not have two different IDs and if the object is not included in the list of exclusion then it means you have not added this object for exclusion in the previous snapshot. If you have added this object in the previous snapshot then please contact CAST Technical Support with Relevant Inputs

  3. Else if the object has two different IDs and if only one is added in exclusion and the other is not then check if this object is added as well as deleted in Dashboard

  4. If you see the object appearing as added as well as deleted then please refer to the page CAST Engineering Dashboard - Object - Incorrect Object Status - Same object seen as added deleted
  5. Else if you see that the object is not appearing in the list of added as well as deleted Check if the objects are two entirely different objects by checking its fullname . If the fullname is also same then please contact CAST Technical Support with Relevant Inputs

Relevant Inputs

  1. Sherlock export with the options Export CAST Database and Export Logs checked
  2. Complete screenshot of the dashboard with URL pointing to the object that you are expecting to be in violation but it is not

Check if the ID of the object excluded in previous snapshot is same as the ID of the object not excluded in current snapshot

Get the ID of the object by using the page - SQL Queries - CAST Central Base - Queries on Objects - How to get the ID of an object

Query result example
object_id
---------
78997
90031

Run the below query to check if these objects are in Exclusion list -

select * from dss_object_exceptions where object_id in (<object_id1> , <object_id2>,....<object_idn>)
Query result example

select * from dss_object_exceptions where object_id in (78997 , 90031)

7204;78997;10;1000000000;"asdfg";"2013-01-10 11:02:15.849976";"exclusion justification"

You can see that the result contains only one object (78997) in exclusion and the other (90031) is not.

Notes/comments
 Zendesk 4868
Related Pages