Created by James Hurrell, last modified on Apr 24, 2023

On this page:

Consolidate Dashboard Service into Measurement Service

This action consolidates a CAST Dashboard Service schema and all its Applications into your Health Dashboard (Measurement Service schema). You can achieve this using a GUI based tool called AadConsolidation-GUI.exe, or with a CLI based tool called AadConsolidation.exe. Both approaches have their own merits and advantages:

  • GUI > Easy to use and do not require the creation of batch scripts
  • CLI > Require batch scripts, but these can be retained and re-used

GUI mode

  • In the AAD/GUI folder located at the root of the CAST AIP installation folder, load the AadConsolidation-GUI.exe file:

  • Click the Consolidate option on the toolbar:

  • In the AAD Connection tab, enter the connection details for your CAST Storage Service 2 (where the Measurement Service is hosted): for the Schema field, use the name of the Measurement Service. You can find out more information about each field in GUI common fields.
  • In the Dashboard Connection tab, enter the connection details for the CAST Dashboard Service you want to consolidate - in this example, the Dashboard Service is hosted on the same CAST Storage Service that hosts the Measurement Service:

  • In the Advanced tab (ensure you are working in Advanced mode: select View > Advanced mode), ensure that the Synchronize Indicators option is selected (see GUI common fields for more information).
  • Click the Run Application option to begin the consolidation process:

  • On completion the Measurement Service will now contain information from your selected CAST Dashboard Service and is ready to be used.

CLI mode

Note that you can view the full syntax for all the CLI tools by running <tool_name>.exe -h from the command line. For example: AadConsolidation.exe -h
  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadConsolidation.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Note that:
    • Commands beginning "remote" refer to the connection parameters for the CAST Dashboard Service you want to consolidate
    • -synchronize_indicators is explained in GUI common fields and is required.
AadConsolidation.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-remote_url jdbc:postgresql://NEFYN:2280/postgres
-remote_schema V71_CENTRAL
-remote_user operator
-remote_password CastAIP
-synchronize_indicators
-log_file log.log

  • The log file will contain the results - in this case it indicates that the Measurement Service now contains information from your selected CAST Dashboard Service and is ready to be used:

What happens if you have multiple CAST Dashboard Services?

If you have multiple Dashboard Services that you want to consolidate into your Health Dashboard, you can do so as follows:

  • Run the process described above for each CAST Dashboard Service you want to consolidate.
You can consolidate CAST Dashboard Services installed on different host RDBMS/CAST Storage Service - i.e. you can consolidate CAST Dashboard Service "A" hosted on CAST Storage Service and CAST Dashboard Service "B" hosted on Microsoft SQL Server etc.

What happens if you only want to consolidate one specific Application from a CAST Dashboard Service?

By default when you run the consolidate action described  above, all Applications stored on the remote CAST Dashboard Service will be consolidated and therefore will be available in the Health Dashboard. This may not be appropriate (if data in certain Applications is sensitive) and you may, instead, need to consolidate one specific Application. This is possible and you can do so as follows:

GUI mode

First run the Preview action:

  • In the AAD/GUI folder located at the root of the CAST AIP installation folder, load the AadConsolidation-GUI.exe file.
  • Ensure that you have filled in the connection parameters in the AAD Connection and Dashboard Connection tabs. You can find out more information about each field in GUI common fields.
  • Ensure the Preview option is selected:

  • Click the Run Application option
  • On completion, check the log section of the GUI tool to identify the Application and their IDs. In this example, there is only one Application (MEUDON) on the remote CAST Dashboard Service with the ID 3:

Now run the Consolidate action using the Application ID you identified using the Preview action above:

  • Now in the same AadConsolidation-GUI.exe tool, click the Dashboard Connection tab (the connection parameters to the Dashboard Service on which the Application is stored should still be filled in).
  • In the Select Application ID field, enter the ID of the Application you want to consolidate (3 in this example) based on the results of the Preview action described above and ensure that the Consolidate option is activated:

  • In the Advanced tab (ensure you are working in Advanced mode: select View > Advanced mode), ensure that the Synchronize Indicators option is selected (see GUI common fields for more information).
  • Click the Run Application option
  • On completion, only data from the chosen Application will be consolidated.

CLI mode

Note that you can view the full syntax for all the CLI tools by running <tool_name>.exe -h from the command line. For example: AadConsolidation.exe -h

First run the Preview action:

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadConsolidation.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Note:
    • Commands beginning "remote" refer to the connection parameters for the CAST Dashboard Service on which the Application you want to consolidate is located.
    • Ensure the -preview option is present to ensure a preview is executed.
AadConsolidation.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-remote_url jdbc:postgresql://NEFYN:2280/postgres
-remote_schema V71_CENTRAL
-remote_user operator
-remote_password CastAIP
-preview
-log_file log.log
  • On completion, check the log to identify the Application and their IDs. In this example, there is only one Application (listed as node ID) MEUDON on the remote CAST Dashboard Service with the ID 3.
Version 2.0
Aad Service version: 8.2.0.1
Valid portfolio hierarchy on remote Dashboard Service
Valid assessment model on remote Dashboard Service
Found node ID: MEUDON (3)
Number of Snapshots (with complete status) for node MEUDON : 4
Snapshot Computed on 201610122152 (1), version V1, functional date 2016-10-12 00:00:00.0.
No corruption detected on this snapshot. It can be consolidated.
Snapshot Computed on 201610131631 (2), version V2, functional date 2016-10-13 00:00:00.0.
No corruption detected on this snapshot. It can be consolidated.
Snapshot Computed on 201610131645 (3), version V2, functional date 2016-10-14 00:00:00.0.
No corruption detected on this snapshot. It can be consolidated.
Snapshot Computed on 201610141241 (4), version V2, functional date 2016-10-15 00:00:00.0.
No corruption detected on this snapshot. It can be consolidated.

Now run the Consolidate action using the Application ID:

  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Note that:
    • Commands beginning "remote" refer to the connection parameters for the CAST Dashboard Service you want to consolidate
    • Ensure the -remote_node_id option is present, together with the ID of the Application you want to consolidate (3 in this example):
AadConsolidation.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-remote_url jdbc:postgresql://NEFYN:2280/postgres
-remote_schema V71_CENTRAL
-remote_user operator
-remote_password CastAIP
-remote_node_id 3
-log_file log.log
  • On completion, only data from the chosen Application will be consolidated.
Version 2.0
Aad Service version: 8.2.0.1
ADG Service version: 8.2.0.1
New Site registered v82_1317_central.operator (remoteID: 1601538755 consolidatedID: 1601538755
Found node ID: 3
Found snapshot ID: 1
Snapshot synchronized, ID: 1
Found snapshot ID: 2
Snapshot synchronized, ID: 2
Found snapshot ID: 3
Snapshot synchronized, ID: 3
Found snapshot ID: 4
Snapshot synchronized, ID: 4
Done

What happens if you make a mistake and need to remove ALL data from the Health Dashboard?

If you have run a Consolidation action and subsequently decide that the data you are presenting is incorrect or if you have data from specific Applications that you do not want to display, then you can perform a Full Reset to clear the Health Dashboard of ALL consolidated data. This section describes how to achieve this:

GUI mode

  • In the AAD/GUI folder located at the root of the CAST AIP installation folder, load the AadConsolidation-GUI.exe file.
  • Ensure the Full Reset option is selected (this will disable the Dashboard Connection tab)

  • Ensure that you have filled in the connection parameters in the AAD Connection tab (i.e. for the Measurement Service you want to reset). You can find out more information about each field in GUI common fields.
  • Click the Run Application option
  • On completion, all data already consolidated into the Health Dashboard will be removed.
  • You now need to run your Consolidate action again to populate the Health Dashboard with the correct data.

CLI mode

Note that you can view the full syntax for all the CLI tools by running <tool_name>.exe -h from the command line. For example: AadConsolidation.exe -h

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadConsolidation.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Ensure the -reset option is present to ensure a reset is executed.
AadConsolidation.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-reset
-log_file log.log
  • On completion, check the log to ensure that the process completed.

How do you remove one specific CAST Dashboard Service from the Health Dashboard?

If you have run a Consolidation action and subsequently decide that data from an entire Dashboard Service needs to be removed from the Health Dashboard, you can do so as follows:

GUI mode

First run the List Site action to identify the CAST Dashboard Service you want to remove

  • In the AAD/GUI folder located at the root of the CAST AIP installation folder, load the AadSite-GUI.exe file.
  • Ensure the List Site option is selected (this will disable the Site and Update URL tabs)

  • Ensure that you have filled in the connection parameters in the AAD Connection tab (i.e. for the target Measurement Service). You can find out more information about each field in GUI common fields.
  • Click the Run Application option
  • On completion, check the log section of the GUI tool to identify the CAST Dashboard Services and their IDs. In this example, there is only one CAST Dashboard Service (v71_central.operator) with the ID 615342091:

Now run the Reset Site action

  • Now in the same AadSite-GUI.exe tool, ensure that the Reset Site option is selected

  • Leave the AAD Connection tab as configured above (i.e. for the target Measurement Service). You can find out more information about each field in GUI common fields.
  • In the Site tab, enter the Name of the CAST Dashboard Service you want to remove (v82_1317_central.operator in this example) in the Site Name field, based on the results of the List Site action described above:

  • Click the Run Application option
  • On completion, the specified CAST Dashboard Service and all its data will be removed from the Measurement Service

CLI mode

Note that you can view the full syntax for all the CLI tools by running <tool_name>.exe -h from the command line. For example: AadSite.exe -h

First run the List Site action to identify the CAST Dashboard Service you want to remove

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadSite.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Ensure the -list option is present to ensure a list is executed.
AadSite.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-list
-log_file log.log
  • On completion, check the log to identify the CAST Dashboard Services and their IDs. In this example, there is only one CAST Dashboard Service (v82_1317_central.operator) with the ID 1601538755:
Version 2.0
Aad Service version: 8.2.0.1
Found Site: v82_1317_central.operator (1601538755)
INFO - AadSite - found application ID: MEUDON (3)
Snapshot Computed on 201610122152 (1), version V1, functional date 2016-10-12 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610131631 (2), version V2, functional date 2016-10-13 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610131645 (3), version V2, functional date 2016-10-14 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610141241 (4), version V2, functional date 2016-10-15 00:00:00.0.
No corruption detected on this snapshot.

Now run the Reset Site action

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadSite.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Ensure the -site_reset option is present to ensure a reset is executed and ensure that the -site_name option is also specified:
AadSite.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-site_name v82_1317_central.operator
-site_reset
-log_file log.log
  • On completion, check the log to ensure that the process completed.

How do you remove one specific snapshot from the Health Dashboard?

If you have run a Consolidation action and subsequently decide that data from one specific snapshot needs to be removed from the Health Dashboard, you can do so as follows:

GUI mode

First run the List Site action to identify the snapshot you want to remove and the Application it belongs to:

  • In the AAD/GUI folder located at the root of the CAST AIP installation folder, load the AadSite-GUI.exe file.
  • Ensure the List Site option is selected (this will disable the Site and Update URL tabs)

  • Ensure that you have filled in the connection parameters in the AAD Connection tab (i.e. for the target Measurement Service). You can find out more information about each field in GUI common fields.
  • Click the Run Application option
  • On completion, check the log section of the GUI tool to identify the snapshots / applications and their IDs. In this example, there are two Applications (MEUDON and SERVES) with multiple snapshots. This information will be used to delete the required snapshot:

Now run the Reset action

  • In the AAD/GUI folder located at the root of the CAST AIP installation folder, load the AadConsolidation-GUI.exe file.
  • Ensure the Reset option is selected (this will disable the Dashboard Connection tab)

  • Ensure that you have filled in the connection parameters in the AAD Connection tab (i.e. for the Measurement Service you want to reset). You can find out more information about each field in GUI common fields.
  • In the Reset tab fill in the fields as follows. This information is provided in the first part of the process using the AadSite-GUI.exe tool:
    • Site ID: enter the ID number of the CAST Dashboard Service you want to remove (1340455286 in this example)
    • Select Application ID: enter the ID number of the Application to which the snapshot belongs (3 in this example for the Application MEUDON)
    • Select Snapshot ID: enter the ID number of the specific Snapshot you want to remove (1 in this example to delete the very first snapshot generated for the MEUDON Application)

  • Click the Run Application option
  • On completion, the specified snapshot will be removed from the Measurement Service and will no longer be visible in the Health Dashboard.

CLI mode

Note that you can view the full syntax for all the CLI tools by running <tool_name>.exe -h from the command line. For example: AadSite.exe -h

First run the List Site action to identify the snapshot you want to remove and the Application it belongs to:

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadSite.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Ensure the -list option is present to ensure a list is executed.
AadSite.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema v82_1286_measure
-user operator
-password CastAIP
-list
-log_file log.log
  • On completion, check the log to identify the snapshots / applications and their IDs. In this example, there are two Applications (MEUDON and SERVES) with multiple snapshots. This information will be used to delete the required snapshot:
Version 2.0
Aad Service version: 8.2.0.1
Found Site: v82_1286_central.operator (1340455286)
INFO - AadSite - found application ID: MEUDON (3)
Snapshot Computed on 201609121718 (1), version V1, functional date 2016-09-12 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201609121726 (2), version V1, functional date 2016-09-13 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201609121734 (3), version V1, functional date 2016-09-14 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201609151023 (5), version V2, functional date 2016-09-15 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201609191604 (6), version V2, functional date 2016-09-19 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201609201050 (7), version V2, functional date 2016-09-20 00:00:00.0.
No corruption detected on this snapshot.
INFO - AadSite - found application ID: SEVRES (9)
Snapshot Computed on 201609131139 (4), version V1, functional date 2016-09-13 00:00:00.0.
No corruption detected on this snapshot.

Now run the Reset action

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadConsolidation.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Ensure the following options are present:
    • -delete

    • -remote_site_id: enter the ID number of the CAST Dashboard Service you want to remove (1340455286 in this example)

    • -remote_application_id: enter the ID number of the Application to which the snapshot belongs (3 in this example for the Application MEUDON)

    • -remote_snapshot_id: enter the ID number of the specific Snapshot you want to remove (1 in this example to delete the very first snapshot generated for the MEUDON Application)

AadConsolidation.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema v82_1286_measure
-user operator
-password CastAIP
-remote_site_id 1340455286
-remote_application_id 3
-remote_snapshot_id 1
-delete
-log_file log.log
  • On completion, check the log to ensure that the process completed.

What happens if you want to unlock a locked snapshot process following an aborted synchronization

If you have used AadConsolidation-GUI.exe to perform a synchronization, but this synchronization is aborted for whatever reason, then the Measurement Service schema will remain in a "locked" state and no further synchronization can take place:

To clear the lock, you can use the Unlock synchronization option:

GUI mode

  • In the AAD/GUI folder located at the root of the CAST AIP installation folder, load the AadConsolidation-GUI.exe file.
  • Ensure the Unlock synchronization option is selected:


  • Ensure that you have filled in the connection parameters in the AAD Connection tab (i.e. for the Measurement Service you want to reset). You can find out more information about each field in GUI common fields.
  • Click the Run Application option
  • On completion, the target Measurement Service schema will be unlocked

CLI mode

Note that you can view the full syntax for all the CLI tools by running <tool_name>.exe -h from the command line. For example: AadConsolidation.exe -h

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadConsolidation.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Ensure the -reset option is present to ensure a reset is executed.
AadConsolidation.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-unlock
-log_file log.log
  • On completion, check the log to ensure that the process completed.

Configure your CAST Dashboard URLs

The Health Dashboard enables users to access directly the underlying Engineering Dashboard / legacy CAST Engineering Dashboards that provide the top level data. Although the consolidation action described in Step 3 onboards the CAST Dashboard Services schemas, it does not configure the URL for direct access from the Health Dashboard. You can achieve this using a GUI based tool called AadSite-GUI.exe, or with a CLI based tool called AadSite.exe. It is entirely down to user preference which type you use. Both types have advantages:

  • GUI > Easy to use and do not require the creation of batch scripts
  • CLI > Require batch scripts, but these can be retained and re-used

GUI mode

First run the List Site action to identify the CAST Dashboard Service for which you want to add a URL

  • In the AAD/GUI folder located at the root of the CAST AIP installation folder, load the AadSite-GUI.exe file.
  • Ensure the List Site option is selected (this will disable the Site and Update URL tabs)

  • Ensure that you have filled in the connection parameters in the AAD Connection tab as specified above in Step 3 (i.e. for the target Measurement Service). You can find out more information about each field in GUI common fields.
  • Click the Run Application option
  • On completion, check the log section of the GUI tool to identify the CAST Dashboard Services and their IDs. In this example, there is only one CAST Dashboard Service (v82_1317_central.operator) with the ID 1601538755:

Now run the Update URL action

  • Now in the same AadSite-GUI.exe tool, ensure that the Update URL option is selected:

  • Leave the AAD Connection tab as configured above (i.e. for the target Measurement Service). You can find out more information about each field in GUI common fields.
  • In the Site tab, enter the Name of the CAST Dashboard Service for which you want to add a URL (v82_1317_central.operator in this example) in the Site Name field, based on the results of the List Site action described above.
  • In the Update URL tab, enter the URL to the Engineering Dashboard / legacy CAST Engineering Dashboard for the specified CAST Dashboard Service - ensure this URL will work for all of your Health Dashboard users:

  • Click the Run Application option
  • On completion, drilling down through the data in the Health Dashboard will allow users to access the underlying Engineering Dashboard / legacy CAST Engineering Dashboards.

CLI mode

Note that you can view the full syntax for all the CLI tools by running <tool_name>.exe -h from the command line. For example: AadSite.exe -h

First run the List Site action to identify the CAST Dashboard Service for which you want to add a URL

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadSite.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Ensure the -list option is present to ensure a list is executed..
AadSite.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-list
-log_file log.log
  • On completion, check the log to identify the CAST Dashboard Services and their IDs. In this example, there is only one CAST Dashboard Service v82_1317_central.operator) with the ID 1601538755:
Version 2.0
Aad Service version: 8.2.0.1
Found Site: v82_1317_central.operator (1601538755)
INFO - AadSite - found application ID: MEUDON (3)
Snapshot Computed on 201610122152 (1), version V1, functional date 2016-10-12 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610131631 (2), version V2, functional date 2016-10-13 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610131645 (3), version V2, functional date 2016-10-14 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610141241 (4), version V2, functional date 2016-10-15 00:00:00.0.
No corruption detected on this snapshot.

Now run the Update URL action

  • In the AAD/CLI folder located at the root of the CAST AIP installation folder, find the AadSite.exe file.
  • Create the following script in a batch file and adapt to your environment (note that commands must be presented on one line in the batch file - the below script puts each command on a separate line to make it more understandable).
  • Ensure the -site_name and -site_url options are present:
AadSite.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-site_name v71_central.operator
-site_url http://DINLLAEN:8080/CASTAD
-log_file log.log
  • On completion, check the log to ensure that the process completed.

Notes about Preview (AADConsolidation) and List Site (AADSite) commands

The Preview (AADConsolidation) and List Site (AADSite) commands provide additional information about snapshots:

Preview (AADConsolidation)

This command lists the Applications that exist in the CAST Dashboard Service schema together with any snapshots and their statuses:

Version 2.0
Aad Service version: 8.2.0.1
Valid portfolio hierarchy on remote Dashboard Service
Valid assessment model on remote Dashboard Service
Found node ID: MEUDON (3)
Number of Snapshots (with complete status) for node MEUDON : 4
Snapshot Computed on 201610122152 (1), version V1, functional date 2016-10-12 00:00:00.0.
No corruption detected on this snapshot. It can be consolidated.
Snapshot Computed on 201610131631 (2), version V2, functional date 2016-10-13 00:00:00.0.
No corruption detected on this snapshot. It can be consolidated.
Snapshot Computed on 201610131645 (3), version V2, functional date 2016-10-14 00:00:00.0.
No corruption detected on this snapshot. It can be consolidated.
Snapshot Computed on 201610141241 (4), version V2, functional date 2016-10-15 00:00:00.0.
No corruption detected on this snapshot. It can be consolidated.

List Site (AADSite)

For each CAST Dashboard Service schema in the Measurement Service schema, this command lists the Applications together with any snapshots and their statuses:

Version 2.0
Aad Service version: 8.2.0.1
Found Site: v82_1317_central.operator (1601538755)
INFO - AadSite - found application ID: MEUDON (3)
Snapshot Computed on 201610122152 (1), version V1, functional date 2016-10-12 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610131631 (2), version V2, functional date 2016-10-13 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610131645 (3), version V2, functional date 2016-10-14 00:00:00.0.
No corruption detected on this snapshot.
Snapshot Computed on 201610141241 (4), version V2, functional date 2016-10-15 00:00:00.0.
No corruption detected on this snapshot.

Snapshot statuses

The following statuses are possible:

MessageDescriptionCan the snapshot be uploaded to the Measurement Service?SQL query to check

"No corruption detected on this snapshot."

The snapshot status is good and no corruption is present.(tick)N/A
"Warning : Snapshot is in an uncomplete state."This is when the status of a snapshot (in dss_snapshots table) is different from 2.(error) (the snapshot must be re-generated before it can be uploaded)
select SNAPSHOT_STATUS
from DSS_SNAPSHOTS
where SNAPSHOT_ID = ?
"Warning : Links are missing in this snapshot."This is when their is no data (in dss_link_info table) for this snapshot, which can lead to errors in the RestAPI or Health Dashboard.(error) (the snapshot must be re-generated before it can be uploaded)
select count(NEXT_OBJECT_ID)
from DSS_LINK_INFO
where SNAPSHOT_ID = ?
"Warning : Snapshot has no compute end date."This is when the snapshot generation has not completed, or is currently being processed by the CAST Management Studio.(error) (the snapshot must be re-generated before it can be uploaded)
select to_char(COMPUTE_END_DATE,'YYYYMMDDHH24MISS')
from DSS_SNAPSHOTS
where SNAPSHOT_ID = ?
"Warning : Snapshot has no value for number of code lines."This is when there is no result for this sizing measure at Application level.(error) (the snapshot must be re-generated before it can be uploaded)
select count(METRIC_NUM_VALUE)
from DSS_METRIC_RESULTS
where SNAPSHOT_ID = ? and OBJECT_ID = ? and METRIC_ID = 10151
"Warning : Snapshot has no score for TQI."This is when the Total Quality Index (TQI) has no grade at Application level.(error) (the snapshot must be re-generated before it can be uploaded)
select count(METRIC_NUM_VALUE)
from DSS_METRIC_RESULTS
where SNAPSHOT_ID = ? and OBJECT_ID = ? and METRIC_ID = 60017 and METRIC_VALUE_INDEX = 0
"Warning : Snapshot is locked in measure site."This is when the consolidation of a snapshot in the Measurement Service has been started, but the consolidation has been cancelled or killed, so the snapshot has not been fully consolidated and is now in an invalid state.N/A (in this situation, the snapshot should be deleted from the Measurement Service schema)
select COUNT(1)
from SYS_SITE_OPTIONS
where OPTION_NAME = LOCK_SNAPSHOT AND OPTION_VALUE = <consolidatedSnapshotId>
"Warning : This snapshot should be deleted from measure site."This error message indicates that the snapshot is corrupt and should be deleted from the Measurement Service schema to avoid issues when using the RestAPI or the Health Dashboard.N/A (in this situation, the snapshot should be deleted from the Measurement Service schema)N/A