CAST Engineering Dashboard - Metrics - AFP - Inconsistent value - Zero Automated Function Points Deleted while there are deleted function points

Purpose (problem description)

This page helps to troubleshoot issues when you are seeing zero value for Automated Function Points Deleted which is incorrect according to you. For instance the Automated function Points Deleted displays 0 but if you click on 0 , it displays the list of deleted Function Points as seen in the below screenshots.

Figure 1

Figure 2

Observed in CAST AIP

ReleaseYes/No
8.3.x✅

Observed on RDBMS

RDBMSYes/No
CSS✅

Step by Step scenario

  1. Launch Analysis followed by snapshot.
  2. Observe that Automated function deleted shows 0 in view.
  3. Click on zero and you will see the list of deleted Function Points.

Action Plan

To troubleshoot this issue, the following Relevant input is needed

Perform the below actions

  1. Check if the Knowledge base has been changed or replaced with a new one at the time of analysis of the current version by running the below query on the Central Database.

select doi.SNAPSHOT_ID, dtt.SITE_ID, count(1) from DSS_TRANSLATION_TABLE dtt join DSS_OBJECT_INFO doi on doi.OBJECT_ID = dtt.OBJECT_ID and SNAPSHOT_ID > 0 group by doi.SNAPSHOT_ID, dtt.SITE_ID order by doi.SNAPSHOT_ID, dtt.SITE_ID;


   Result

   SNAPSHOT\_ID;SITE\_ID;COUNT  
   1;286701547;99400  
   2;286701547;103748  
   3;286701547;104669  
   4;286701547;106203  
   5;286701547;106569  
   6;286701547;110556  
   7;286701547;112198  
   9;286701547;116932  
   10;286701547;117552  
   **11;32234887;121292**  
   12;32234887;121334  
   13;32234887;124335  
   14;32234887;123851  
   19;32234887;125610  
   20;32234887;106944  
   21;32234887;106939  
   22;32234887;107382  
   The second column SITE\_ID should have the same ID, if there is a change then it means that the KB has been changed / replaced with a new one or a different one. In the above example it can be seen that the KB has been changed since Snapshot 11 onwards.

   1. If there is a change in SITE\_ID then apply the below query as a work around to solve the issue -
   1. Drop the last snapshot from CMS
   2. Run the below queries in CB

      ```sql
delete from DSS_TRANSLATION_TABLE where site_id = <site_id_associated_with_previous_KB>

  In our example the SITE\_ID associated to the previous KB is 286701547

  ```sql

delete from DSS_TRANSLATION_TABLE where site_id = 286701547

   3. Run the below query on the CB

      ```sql
 insert into DSS_LINKS (PREVIOUS_OBJECT_ID, NEXT_OBJECT_ID, LINK_TYPE_ID)
select l.PREVIOUS_OBJECT_ID, l.NEXT_OBJECT_ID, l.LINK_TYPE_ID
 from (select application_id, snapshot_id
 from adg_delta_snapshots 
 where snapshot_id = last_snapshot_id) a
 join DSS_LINK_info l
 on l.previous_object_id = a.application_id 
 and l.LINK_TYPE_ID = 8
 and l.snapshot_id = a.snapshot_id
 join DSS_OBJECT_INFO m
 on m.object_id = l.next_object_id
 and m.snapshot_id = a.snapshot_id
 and m.object_type_id = 20000
where not exists (select 1 
 from DSS_LINKS dl
 where dl.PREVIOUS_OBJECT_ID = l.PREVIOUS_OBJECT_ID
 and dl.NEXT_OBJECT_Id = l.NEXT_OBJECT_ID
 and dl.LINK_TYPE_Id = 8
 )
  1. Run the snapshot by skipping analysis.2. If there is no change in the site-ID then contact CAST Technical Support with Relevant input

Relevant input

  1. CAST Support Tool (CST) - alias Sherlock export with the options Export CAST Databases and Export Logs checked
  2. Complete Screenshots of dashboard showing urls

Notes/comments

Ticket # 9592

Related Pages