Health Dashboard - Technology - Duplicate Technology - DOTNet technology is displayed twice in the Filter of HD

This page provides the solution to the problem of duplicate DotNET technology shown in the filter of HD after migration from 7.3.x to 8.0.x.

The technology filter shows .Net and .NET both on the HD when an application is migrated from 7.3.x to 8.0.x. Please refer to the below screenshot to know about the issue:

This issue is permanently fixed in CAST AIP 8.0.5. This issue is not encountered in 8.1.

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

1. Run analysis+snapshot for a DotNETapplication in 7.3.x.
2. Upload snapshots to Measurement schema.
3. Migrate the triplets from 7.3.x to 8.0.x.
4. Run analysis+snapshot for a DotNETapplication in 8.0.x.
5. Consolidate the 8.0.x snapshot on the same measure schema.
6. Open HD and check the technology filter showing both .Net and .NET

The impact of the problem on the dashboard is: The dashboard will show duplicate filter of same technology.

The issue occurs because of the change in the naming convention of DotNET from 7.3.x to 8.0.x. In 7.3.x. it was spelled ".Net" whereas in 8.0.x it has been changed to ".NET".

To fix the problem, proceed as follows:

1. Connect to the measure schema by opening a pgAdmin SQL Session.

   set search_path=<measure_schema>

2. Then run the below query to get the list of technologies on it.
    

   select * from DSS_OBJECT_TYPES dot, DSS_OBJECTS
   where DSS_OBJECTS.OBJECT_TYPE_ID = dot.OBJECT_TYPE_ID 
   and dot.OBJECT_GROUP = 2

3. The above will return below results:

   -6;".Net";"Technologic .Net object";2;"";5;-6;".Net";"Technologic .Net object";".Net"
   -6;".Net";"Technologic .Net object";2;"";6;-6;".Net";"Technologic .Net object";".Net"
   -6;".Net";"Technologic .Net object";2;"";9;-6;".NET";"Technologic .NET object";".NET"
   -6;".Net";"Technologic .Net object";2;"";10;-6;".NET";"Technologic .NET object";".NET" 

   
   

4. Then to update the name of technology, run the below query: 

   update DSS_OBJECTS 
   set OBJECT_NAME = dot.OBJECT_TYPE_NAME
   from DSS_OBJECT_TYPES dot
   where DSS_OBJECTS.OBJECT_TYPE_ID = dot.OBJECT_TYPE_ID 
   and dot.OBJECT_GROUP = 2