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
Release | Yes/No |
---|---|
8.3.x | |
RDBMS | Yes/No |
---|---|
CSS |
Step by Step scenario
- Launch Analysis followed by snapshot.
- Observe that Automated function deleted shows 0 in view.
- 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
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.- If there is a change in SITE_ID then apply the below query as a work around to solve the issue -
Drop the last snapshot from CMS
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
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 )
Run the snapshot by skipping analysis.
- If there is no change in the site-ID then contact CAST Technical Support with Relevant input
Relevant input
- CAST Support Tool (CST) - alias Sherlock export with the options Export CAST Databases and Export Logs checked
- Complete Screenshots of dashboard showing urls
Ticket # 9592