CAST Engineering Dashboard - Object - Wrong object - Objects from the previous analysis are present in current snapshot

Purpose (problem description)

This page is a troubleshooting guide for the problem on CAST Engineering Dashboard where the objects from the previous analysis are present in current dashboard even after deleting the source code from physical disk.

Observed in CAST AIP

Observed on RDBMS

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.

   ```sql
select  * from ObjPro where IdObj = '<object_id'

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
                  )
           )
   )

   ```sql
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.

Notes/comments

Reference Ticket ID - 5155

Related Pages