Purpose (problem description)

This troubleshooting guide treats the problems of the evolution's view where the values are incoherent or not as expected. For instance the absolute values displayed in the Quantity Evolution section (value is set to 0) are contrary to the relative values displayed in the Quantity Evolution (%) section (value is set to 100%).
Another example is that the deleted artifacts value is set to zero while artifacts have been deleted.

 You will find the definitions of the available quantities in the following page: Definition of quantities' values displayed in the Evolution View

Applicable in CAST Version
Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS (tick)
Action Plan

To troubleshoot this issue, you need the following Relevant input

The action plan to troubleshoot these problems is as follow:

  1. Calculate the values displayed on the page manually . If your manual calculation does not match with the ones displayed on the dashboard then contact  CAST Technical Support with Relevant input
  2. If the manual calculation matches the values displayed on dashboard and if the values are not the ones expected by you then please contact  CAST Technical Support with Relevant input along with the justification on why are these values not expected by you.
    For CAST Technical support only - Justification and expectation will be validated with the help of information from official documentation . If the justification is valid then steps given in the page CAST Engineering Dashboard - Information - How to identify and execute SQL query involved in data display will be followed.

Relevant Input

  1. Complete screenshot of the dashboard showing the quantity value (the page's url should be seen on the page) or the faulty Application to know how to navigate in the CED.
  2. Sherlock Export with options Export CAST Databases and Export Logs checked
  3. The username used for login
  4. Manual calculation if your calculation does not match the values on the dashboard.

Calculate the values displayed on the page manually

To calculate the values manually use the definition of the quantities available in page Definition of quantities' values displayed in the Evolution View 

Sections - Quantity Evolution and Quantity Evolution(%)

 For instance TOTAL_CC=TCC_NOW - TCC_BEFORE

Identify the query for the quantity

  1. Follow the steps given in the page CAST Engineering Dashboard - Information - How to identify and execute SQL query involved in data display
  2. Specific for Evolution - Quality & Size View
    1. For Quantity Evolution Sections, the retriever names for the two tables are: RETRIEVER_SECTION_COMPARISON_VIEW_QUANTITY_VAR_TABLE and RETRIEVER_SECTION_COMPARISON_VIEW_ARTIFACT_STATUS_TABLE
    2. For Estimated Effort(Absolute and Split) Section, the retriever name is: RETRIEVER_SECTION_COMPARISON_VIEW_ARTIFACT_EFFORT_TABLE
    3. For Quality Status and Evolution section the retriever names for the two table are:
      RETRIEVER_PORTFOLIO_VIEW_HF_CUR and RETRIEVER_PORTFOLIO_VIEW_HF_MIN_MAX
  3. Identify the query responsible of the value displayed. To get this just get the SELECT SQL query under the identified retriever.


For instance, for the section QUANTITY EVOLUTION, the execution of the SELECT statement identified in RETRIEVER_SECTION_COMPARISON_VIEW_QUANTITY_VAR_TABLE gives the following result:
NEXT_OBJECT_ID     BFP_NOW                 BFP_BEFORE             TCC_NOW       TCC_BEFORE    LOC_NOW     LOC_BEFORE   P_ARTIFACTS     ARTIFACTS  P_OBJECTS    OBJECTS
---------          -------------    ------------    ------        ---------   ------    --------    ----------     --------  -------    --------- 
575924                    16896,6499999999    20098,4499999999    124885           127000             1013799        1205907         418                    17367          2337              27203

Sections - Quantity Evolution and Quantity Evolution(%)
The result given by the SELECT for the second table are the one displayed on CED

Section - Estimated Effort
The result given by the SELECT for the first table are the one displayed on CED.  These result are therefore divided by the Total to have percentage in the second table

Section - Quality status
The result given given by the SELECT for both the table are the one displayed on CED

Notes/comments


Related Pages