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.
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.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x (x<=2) | |
8.1.x (x<=1) | |
8.0.x | |
7.3.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 | |
CSS1 |
This problem occurs when the following steps are done:
Generate a snapshot and choose to upload data to the Measurement Service schema or Manually upload snapshots to the Measurement Service schema.
The upload process completes without error but none of the snapshots uploaded are visible in the CAST Application Analytics Dashboard.
- 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
- Else contact CAST Technical Support with Relevant Inputs
Relevant Input
- CAST Support Tool (CST) - alias Sherlock export with option Export CAST Databases and Export Logs options checked
- Screenshot showing the problem
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.