Description

This page describes the solution to a known problem with Application Analytics Dashboard Component.

 A test has been introduced into the process of uploading snapshots to the Measurement Service schema for display in the CAST Application Analytics Dashboard which will check for Quality Rules that have returned "total checks = 0" when they were fired during the analysis/snapshot. When a Quality Rule shows these results, there is a bug in the Quality Rule itself. This bug leads to corrupt data which, if uploaded to the Measurement Service schema, can cause the CAST Application Analytics Dashboard to crash.

It is important to note that in normal circumstances with a default Assessment Model, this error should never occur.

 When the test finds a Quality Rule that has returned "total checks = 0", an error is logged and the upload of the snapshot containing the faulty data to the Measurement Service schemas is skipped. The CAST Management Studio will NOT show that the upload of the snapshot has been skipped, however, when checking the CAST Application Analytics Dashboard the snapshot will not be visible. If this situation occurs then the first thing to do is to check the following log file:

%temp%\CAST\CAST\<version>\HDCli-YYYYMMDDHHmmSS.TXT

When a snapshot has been skipped and not uploaded to the Measurement Service schema the following error message will be visible in this log file:

The snapshot you attempt to synchronize (2) has erroneous violation ratio.

For example:

 HD Service version: 8.2.0.1
 ADG Service version: 8.2.0.1
 Found node ID: 3
 Found snapshot ID: 1
 Snapshot already consolidated - synchronization skipped
 Found snapshot ID: 2
 The snapshot you attempt to synchronize (2) has erroneous violation ratio.
 Found snapshot ID: 3
 The snapshot you attempt to synchronize (3) has erroneous violation ratio.
 Found snapshot ID: 4
 The snapshot you attempt to synchronize (4) has erroneous violation ratio.
 Check for indicator description requiring consolidation
 Required the consolidation of parentship: ID# 60001/ ID# -1)
 Check for indicator description requiring consolidation
 Check for indicator description requiring consolidation

In the above file it can be seen that the very first snapshot generated is present in the Measurement Service schema, but all subsequent snapshots have not been uploaded to the Measurement Service schema and consequently are not present in the DSS_SNAPSHOTS table.

Observed in CAST AIP
Release
Yes/No
8.3.x   (error)
8.2.x (x<=2)   (tick)
8.1.x (x<=1)(tick)
8.0.x    (error)
7.3.x    (error)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS3   (error)
CSS2(tick)
CSS1(error)
Step by Step Scenario

 This problem occurs when the following steps are done:

  1. Generate a snapshot and choose to upload data to the Measurement Service schema or Manually upload snapshots to the Measurement Service schema.

  2. The upload process completes without error but none of the snapshots uploaded are visible in the CAST Application Analytics Dashboard.

Action Plan
  1. Check if there are quality rules with a zero total check, for that refer to - SQL Queries - CAST Measure Base - Checking and removing corruptions - Snapshot containing quality rules with zero total check, if yes then apply the solution from the page
  2. Else contact  CAST Technical Support with Relevant Inputs

 Relevant Input

  1. CAST Support Tool (CST) - alias Sherlock export with option Export CAST Databases and Export Logs options checked
  2. Screenshot showing the problem
Impact on Analysis Results and Dashboard

Impact of issue: The entire snapshot will not be visible in HD. 

Impact of applying solution: the snapshot can then be uploaded to the Measure and  the snapshot will then be visible in HD.

Notes/comments