Step by Step scenario

1. Generate snapshot after running the analysis for V1.
2. Do new delivery with some missing source code V2.
3. Generate snapshot after running the analysis for V2.
4. Launch dashboard.
5. Get violations for older code.
6. The Application drilldown view shows object in object tree, which points to older release.

Action Plan

To troubleshoot this issue, you need the following Relevant input

Perform the below actions:

1.  Check for corruptions 
2. check if there is wrong objects populated in the module - CMS Application - Modules - Incorrect module content - Unexpected objects
3.  If you find any corruptions then take a backup of the databases before applying any solution given in this page.
4.  If this page doesn't give a solution to the issue or give a reason for the problem then please contact CAST Technical Support with Relevant input.
   

Relevant input

1. CAST Support Tool (CST) - alias Sherlock Export before applying the solution given in this page. 
2. Screenshot of the dashboard with URL, showing the object that you are not expecting to be present on the dashboard.
   

Check for corruptions

Case 1 - ACC / ObjPro without Project

To check if there are any OBjPro without project the below queries have to be run on the Knowledge Base.

1. Get the id of the object

   select object_id from dss_objects where object_name = '<object_name>'

2. Get the idpro of the objects by using the object_id obtained from above query.

   select  * from ObjPro where IdObj = '<object_id'

   Example

   select object_id from dss_objects where object_name = 'getname'
   Result -
   "object_id"
   2708943
   
   select  * from ObjPro where IdObj = 2708943
   Result -
   "idobj";"idpro";"prop"
   2708943;2708302;0 

3. run the below query and check if the idpro obtained in the above query exists in the results of this query.

   SELECT idkey
   FROM   Keys 
   WHERE  IdKey IN 
          ( SELECT IdPro 
          FROM    (SELECT DISTINCT IdPro
                  FROM             ObjPro
                   
                  UNION
                   
                  SELECT DISTINCT IdPro
                  FROM            Acc
                  ORDER BY        1
                  ) 
                  p
          WHERE   IdPro NOT IN
                  ( SELECT IdPro
                  FROM    AnaPro
                   
                  UNION
                   
                  SELECT IdPro
                  FROM   ProDep
                  WHERE  IdProMain IN 
                         (SELECT IdPro
                         FROM    AnaPro
                         )
                  )
          )

   Example

   Result -
   idkey; 
   2708301
   2708302
   2708303

4. If the idpro exists in the results then Apply the solution to remove this corruption.

If there are no corruptions then please contact CAST Technical Support with Relevant input

Apply the solution

1.Create a SQL tool in the content enrichment tab of the application.

2.Copy the SQL query in the attached clean_up_query.txt and set the search path to local database.

3.Run the tool.
4.See that the object is not present in the Keys table by executing the below query on Knowledge base.

select * from keys where idkey = <object_id>

In this example as seen in the prior queries the object_id is 
select * from keys where idkey = 2708943

Result - The query should not return any rows.

5.Run the snapshot and see that the objects are not present in the dashboard.

Reference Ticket ID - 5155