Page tree
Skip to end of metadata
Go to start of metadata
Purpose (problem description)

This page helps to troubleshoot issues when the Contribution of the Quality Rule is incorrect on dashboard.

For example the contribution should be equal to 100% in the case when the consolidation mode is using a full application mode. The following screenshot illustrate an unexpected behavior:

Figure 1

Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)

Step by Step scenario

  1. Run analysis
  2. Compute snapshot
  3. Open CED
Action Plan


  1. Validate if the contribution displayed on the CED is correct -
    Depending on the consolidation mode and Number of modules, the contribution will be as follows:

    Consolidation Mode

    Number of Modules

    Contribution

    Full Application

    One Full content

    100%

    Other legacy modes based on averages of modules

    N

    (100/N)%

    For more detail refer to Investigation - Quality Model Drilldown

  2. If the displayed contribution on CED is wrong then Get the SQL query for the "RETRIEVER_RULE_INVEST_TCRIT_TABLE" using the following pages  - CAST Engineering Dashboard - Information - Configuring Dashboard to SQL trace and CAST Engineering Dashboard - Information - Configuring Dashboard to show the retriever name

  3. Compare the query retrieved from the previous point with the following:

    SELECT res.metric_id, 
           /* id de la metrique fille */ 
           res.curgrade, 
           /* grade de la metrique fille dans le snapshot courant */ 
           ( 
           CASE res.prevgrade 
                  WHEN 0 THEN 100 
                  ELSE(res.curgrade - res.prevgrade) / res.prevgrade * 100 
           END), 
           /* grade variation de la metrique fille par rapport au snapshot precedent */ 
           res.aggregate_weight, 
           /* poids de la metrique fille dans la metrique mere */ 
           CASE %object_type% 
                  WHEN -102 THEN 
                         /* Compute consolidation percentage when object is an application */ 
                         CASE res.weight_metric 
                                WHEN 0 THEN 1 
                                WHEN 1 THEN 
                                       ( 
                                              SELECT res.module_weight / 
                                                     CASE res.total_weight 
                                                            WHEN 0 THEN 1 
                                                            ELSE res.total_weight 
                                                     END 
                                              FROM   %prefix%viewer_dual ) 
                         END 
                  WHEN 20000 THEN 1 
                         /* Consolidation percentage is always 1 when object is a module */ 
           END, 
           res.metric_critical, 
           /* 1 si la metrique fille est critique pour la metrique mere */ 
           ( 
                  SELECT d.metric_description 
                  FROM   %prefix%dss_metric_descriptions d 
                  WHERE  d.metric_id = res.metric_id 
                  AND    d.description_type_id = 0 
                  AND    d.language = ''%languageid%'' ) 
           /* TC Name */


    1. If the query matches the above select query then contact CAST Technical Support. with the following Relevant input

    2. If the query does not match the above select query then perform the bellow steps -


      1. Execute the following query under the central schema:

        UPDATE viewer_parameters 
        SET    value = 
        ' select  res.METRIC_ID,     /* id de la metrique fille */  res.CURGRADE,     /* grade de la metrique fille dans le snapshot courant */     (case res.PREVGRADE         when 0         then 100         else(res.CURGRADE - res.PREVGRADE) / res.PREVGRADE * 100     end),     /* grade variation de la metrique fille par rapport au snapshot precedent */  res.AGGREGATE_WEIGHT,    /* poids de la metrique fille dans la metrique mere */  case %object_type%         when -102         then             /* Compute consolidation percentage when object is an application */             case res.WEIGHT_METRIC                 when 0                 then 1                 when 1                 then                     (select                         res.MODULE_WEIGHT / case res.TOTAL_WEIGHT when 0 then 1 else res.TOTAL_WEIGHT end                     from                         %PREFIX%VIEWER_DUAL                     )             end         when 20000         then 1 /* Consolidation percentage is always 1 when object is a module */     end,     res.METRIC_CRITICAL,    /* 1 si la metrique fille est critique pour la metrique mere */     (select         d.METRIC_DESCRIPTION     from         %PREFIX%DSS_METRIC_DESCRIPTIONS d     where         d.METRIC_ID = res.METRIC_ID         and d.DESCRIPTION_TYPE_ID = 0         and d.LANGUAGE = ''%languageid%''     )    /* TC Name */     '
        WHERE  id = 'SELECT_QUERY_1' 
               AND component_id = 'RETRIEVER_RULE_INVEST_TCRIT_TABLE' 
      2. Restart tomcat application

      3. Open CED

      4. Navigate to the view FRAME_PORTAL_INVESTIGATION_VIEW and observe if the issue is fixed

      Note that this a known bug that is fixed in AIP 8.2.10.

  4. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input
Notes/comments

Ticket # 10366

Related Pages





  • No labels