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
Release | Yes/No |
|---|---|
| 8.3.x |  |
RDBMS | Yes/No |
|---|---|
| CSS | |
To troubleshoot this issue, you need the following Relevant input
The action plan to troubleshoot these problems is as follow:
- 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
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
- 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.
- Sherlock Export with options Export CAST Databases and Export Logs checked
- The username used for login
- 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
- Follow the steps given in the page CAST Engineering Dashboard - Information - How to identify and execute SQL query involved in data display
- Specific for Evolution - Quality & Size View
- 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
- For Estimated Effort(Absolute and Split) Section, the retriever name is: RETRIEVER_SECTION_COMPARISON_VIEW_ARTIFACT_EFFORT_TABLE
- 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
- 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
