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

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
      

      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
      

      delete from DSS_TRANSLATION_TABLE where site_id = 286701547

   3. Run the below query on the CB

       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
       )

   4. 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

Ticket # 9592