Purpose (problem description)
This page helps you to troubleshoot issues when the content of the snapshot is wrong on HD. For instance there are X objects in Snapshot n and X+Y objects in Snapshot n+1 but this is not displayed on HD.
For instance
- the LOC for Snapshot V12 is 209,370 and for V11 the LOC is 370,899.
- critical violation count for Snapshot V12 is 304 and for V11 it is 204 , etc
When you select the two versions from the top left drop down in the Application Landing page you can see that for both the versions, the LOC , critical violations , etc are displayed as 209,370 , 304 , etc respectively, which implies that the entire content of the snapshot is wrong on HD.
Observed in CAST AIP
Release | Yes/No |
---|---|
8.3.x | |
8.2.x, x < 4 | |
8.1.x | |
8.0.x |
Observed on RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | N/A |
Microsoft SQL Server | N/A |
CSS3 | |
CSS2 |
Step by Step scenario
- Take a snapshot
- upload the results to the measurement database.
- Examine HD and notice that the data not correct for the current snapshot
Action Plan
To troubleshoot this issue, you need the following Relevant input
- Perform the below actions
- Check that the snapshots are done on the same day using a query on the central database's dss_snapshots table to see if the month, day, and year in the snapshot_date column are the same. More on this query can be seen in the TKB page here: SQL Queries - CAST Central Base - Queries on snapshots - How to check the status of a snapshot
- If the snapshots have been generated on the same day then the previous data on HD for the same day is overwritten by the data from the most recent upload to HD. For example, if Lines of Code data for snapshot 1 done on day 1 is 1000, and Lines of Code data for snapshot 2 done on day 1 is 1500 and both snapshots are uploaded to the measurement database, the HD dashboard will show lines of code as 1500 for both snapshots. This issue has been resolved in CAST 8.2.4 and higher, so upgrading to CAST 8.2.4 or using a 8.2.4 measurement database and 8.2.4 consolidation tools will resolve this issue: Installing and configuring the CAST Application Analytics Dashboard.
If you do not want to upgrade to 8.2.4 then the only work around is below -- Reset your measurement database
- change the date of the snapshot in Cast-MS
- then upload the snapshots into measurememt database
- If the snapshots have been generated on different dates then please contact CAST Technical Support with Relevant input
- Check that the snapshots are done on the same day using a query on the central database's dss_snapshots table to see if the month, day, and year in the snapshot_date column are the same. More on this query can be seen in the TKB page here: SQL Queries - CAST Central Base - Queries on snapshots - How to check the status of a snapshot
- If your case do not match with any of the steps listed above then please contact CAST Technical Support with Relevant input
Notes/comments
Ticket # 9363
Related Pages