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
Release | Yes/No |
---|---|
8.3.x |
RDBMS | Yes/No |
---|---|
CSS |
Step by Step scenario
- Run analysis
- Compute snapshot
- Open CED
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
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
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 */
If the query matches the above select query then contact CAST Technical Support. with the following Relevant input
If the query does not match the above select query then perform the bellow steps -
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'
Restart tomcat application
Open CED
- 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.
- If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input
Ticket # 10366