Health Dashboard - Run Consolidation - GUI - Error - Function AAD Gather Stats does not exist while consolidating snapshot on measure schema

This page provides the solution to the known error of "Failed to run HD GATHER STATS (ERROR: function HD_gather_stats() does not exist)" while consolidating the snapshots of Central Schema on the Measure Schema using the Consolidation GUI tool of HD.

Please refer to the screenshot given below to get a clear idea about the issue:

Please refer to the documentation link which provides information and details about the Consolidation GUI and CLI Tools.

Below is the step-by-step scenario leading to the problem:

1. Open the HDConsolidation GUI Tool provided in the installation directory of CAST AIP.
2. Configure the settings in the tool and provide the connection strings of measurement and central schema.
3. Click on Consolidate and this will start consolidating the snapshots present in central schema into the measurement schema.
4. In the log screen, the process will give an error "Failed to run HD GATHER STATS (ERROR: function HD_gather_stats() does not exist)".

The impact of the problem on the dashboard is : The snapshot details of application in central schema will not be consolidated on the measure schema, and it will not be present on the HD for user.

This problem occurs because of the reason that users are consolidating the snapshots on a measurement base of 7.3.x version and the consolidation GUI is of 8.x.x version. In this case, it is expected to get this error because the Measurement schema of 8.x.x has been enhanced and this function HD_gather_stats() is part of that enhancement. The same function was not present in the measurement schemas of 7.3.x.

So, It is recommended to

1. Use the Consolidation GUI of the same version of CAST AIP similar to the version of Measurement schema that is being used for consolidation.
2. This way, the error will not come up since both measurement base and Consolidation GUI will be of same version.
   Refer to the screenshots below that show this function present in 8.x.x and not in 7.3.x:
   
   
   
   
   
   
3. If still different version of Consolidation GUI is to be used then:
   
   1. User needs to do a "Component Upgrade" of this measurement from the Server Manager of 8.0.x so that the measurement base is upgraded and consists of all the functions that are part of enhancement.
      

4. After performing the Component Upgrade this error will not come since the function will now be present in the measurement schema.

   If a component upgrade can not be done, then as mentioned above it is recommended to use the HDConsolidation-GUI of 7.3.x instead of 8.x version to consolidate the snapshots.

Impact of the solution on the dashboard is: The snapshot details of applications will come up on the HD.