Skip to content
Search to learn about InterSystems products and solutions, career opportunities, and more.

Advisory: Slow DELETE query during Health Insight data ingestion

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.

RELATED TOPICS

Sign Up Today

Receive notifications on support alerts, critical issues,
fixes, and product releases.
*Required Fields
Highlighted fields are required
*Required Fields
Highlighted fields are required
By submitting this form, you give consent to receive notifications concerning support alerts, critical issues, important updates, fixes, and product releases via email. In addition, you consent to your business contact information being entered into our CRM solution that is hosted in the United States, but maintained consistent with applicable data protection laws.
**By clicking here, you give consent to be contacted for news, updates and other marketing purposes related to existing and future InterSystems products, offerings, and events.