Engineering Dashboard - Violations - Mismatch in violation count between different views

• This page will help you to resolve the issue where violation count is not matching between different views of dashboard.
• For example, from below screenshot you can see that violation count is not matching between Home Page and Application Investigation view of dashboard.

• Run analysis+snapshot
• Launch Dashboard
• Observe violation counts are not same between views

Perform the below actions:

1. First make sure that you are not comparing items from a Risk introduced tile.  This will filter only on the added/deleted violations.  In this case, there should be a disclaimer on the view stating this as well.  You can see more in the documentation here:  Engineering Dashboard tile management - Risk Introduced

2. Verify the number of violations stored in the central base using below query

For Home Page:
SELECT r.OBJECT_ID ,r.SNAPSHOT_ID,r.METRIC_ID,r.METRIC_NUM_VALUE,r.METRIC_VALUE_INDEX
FROM DSS_METRIC_RESULTS r WHERE r.METRIC_VALUE_INDEX IN (0,1,2) AND r.OBJECT_ID = <application_id>
AND r.METRIC_ID IN (67011,67211) AND r.SNAPSHOT_ID = <snapshot_id>

For Application Investigation view:
SELECT * FROM DSS_TREE_RANKING2
WHERE SNAPSHOT_ID = <snapshot_id>
	AND OBJECT_ID = <application_id>

If the resulted numbers are same as the one displayed in dashboard then please go to next step.

Otherwise please contact  CAST Technical Support. with the following Relevant input

3. If you are using Cast AIP version <8.3.16 then please apply the attached 2 procedures fix_DSS_IMPORT_OBJECT_INFO.sql and fix_INSERT_DSS_TREE_RANKING2.sql on central schema and take a snapshot skipping analysis.

4. If you are using CAST AIP version < 8.3.27 and have a problem with deleted violations not agreeing between views, then run this attached procedure -  dashboard_deleted.sql -  on the central schema after modifying it for your particular snapshot_id which needs to be changed.  No snapshot is required after running this script.

5. If issue still persist even after applying above fix then please check if there is Green IT or Digital Ready Index Extension is installed in your application. It is found that because of these extensions there can be violation count mismatch.   In this case, you need to deactivate all the quality rules related to these 2 extensions and take a snapshot skipping analysis.

6. If you are using Cast AIP version >=8.3.16 and there is no GreenIT or Digital Ready Index Extension installed  but still there is a mismatch in violation count then there is a possibility that some of the technical criteria are not linked to its business criteria.   

You can check this using below queries :   

Run the query_TC.txt on central schema which will give you the technical criteria ID which is not linked to any business criteria.

7. In this case, please open the particular TC in assessment model and check the Grade Impact tab to see if any business criteria is linked. If there is no data present then please link the business criteria s based on any existing assessment model keeping the default weight.

8. Once done, please take a snapshot skipping analysis which should resolve your issue.

9. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input

Relevant input

• CAST Support Tool (CST) - alias Sherlock export with the following options Export CAST Bases with Management Base, Knowledge Base, Central base
  
• Screenshot of the different views showing issue.

Ticket # 23010, 23756