Advisory: Health Insight Query Performance Degrades After Upgrade

This problem affects the following products:

• HealthShare® Health Insight versions 2020.1 through 2023.1:
  
  • 2020.1
  • 2020.2
  • 2021.1
  • 2021.2
  • 2022.1
  • 2022.2
  • 2023.1

Requirements:

• Health Insight upgrade

Customers may experience slower query performance after upgrading Health Insight.

To resolve this issue, customers will need to

1. Request and apply an ad hoc patch for DP-422292 from the Worldwide Response Center (WRC).
   
2. For customers upgrading to Health Insight versions 2022.2 and 2023.1 only (these versions include the InterSystems IRIS auto-tune feature), open a terminal in the HSANALYTICS namespace and execute the following command:
   set ^%SYS("sql ", "sys ", "autotune ")=0
   

3. For customers on all versions, open a terminal in the HSANALYTICS namespace and execute the following commands:
   set sc=##class(HSAA.API.Data).TuneHSAASchema()
   (this may take some time to execute)

   write $System.OBJ.DisplayError(sc)
   (returns 1 for success)

The correction for this defect is identified as DP-422292 which is included HealthShare 2023.2 and later product releases. It is also available for older versions via ad hoc change file (patch) or full kit from the Worldwide Response Center (WRC).