March 23, 2020 – Advisory: Slow DELETE query during Health Insight data ingestion

InterSystems has corrected a defect affecting the population of Health Insight data.

This problem exists for:

  • HealthShare Health Insight customers upgrading from 15.03 to 2018.1 or above.

An issue was reported by a customer upgrading from Health Insight 15.03 to Health Insight 2019.1.  Their Health Insight instance had over 227 million records in the HSAA.Observation Table, whereas the HSAA.Outcome table was empty. The delete query was taking an average of 67 seconds (to delete zero records). This resulted in a large queue on the HSAA.TransferSDA3.Operation.Transfer component that was processing very slowly, causing Health Insight data ingestion to be slowed.

An Ad hoc software fix is available to correct this issue.

The correction for this defect is identified as AK1005 and will be included in all future product releases starting with Health Insight 2019.1.1. It is also available via Ad hoc change file (patch) or full kit distribution from the Worldwide Response Center (WRC).

If you have any questions regarding this advisory, please contact the WRC.