Page tree
Skip to end of metadata
Go to start of metadata
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
Release
Yes/No
8.3.x (tick)
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)

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



Notes/comments

Ticket # 9592

Related Pages




  • No labels