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 mode

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
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

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:

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:

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

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:

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
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:

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
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

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

AadConsolidation.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-reset
-log_file log.log

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

Now run the Reset Site action

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

AadSite.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-list
-log_file log.log
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

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

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:

Now run the Reset action

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:

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
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

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

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


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

AadConsolidation.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-unlock
-log_file log.log

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 mode

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

Now run the Update URL action

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

AadSite.exe
-driver org.postgresql.Driver
-url jdbc:postgresql://NEFYN:2280/postgres
-schema CAST_AAD
-user operator
-password CastAIP
-list
-log_file log.log
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

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

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 score 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