Home

Advisory: Slow DELETE query during Health Insight data ingestion

Advisory: Slow DELETE query during Health Insight data ingestion

Mar 23, 2020

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.

Latest Alerts & Advisories

Product Alerts & Advisories

InterSystems Security Public Notification

InterSystems has addressed security vulnerabilities that impact Web Gateways and CSP Gateways for InterSystems IRIS, InterSystems IRIS for Health, HealthShare, HealthShare HealthConnect, TrakCare, Caché, and Ensemble. Remediation steps and additional guidance documentation are available from the InterSystems Worldwide Response Center (WRC). Please reference “SVR2024A” when discussing this notice. For assistance with remediation contact your Application Provider or InterSystems Worldwide Response Center.

Product Alerts & Advisories

Alert: Database Corruption with Multi-Volume Databases after Truncation

InterSystems has corrected a defect that can cause database corruption or errors with multi-volume databases under extremely rare circumstances. Only databases that have been truncated are at risk.

Risk & Safety Alert HS2024-03: Multiple Alerts for InterSystems IRIS for Health, HealthShare Health Connect and HealthShare Solutions

There are four alerts in the HS2024-03 Alert Communication. A summary of each alert is shown below. Details for each alert are contained in the linked document.

Product Alerts & Advisories

Advisory: VMware vSAN Data Consistency Errors

Broadcom recently announced a problem that can cause data consistency errors in database applications. The Broadcom article is available here:

Product Alerts & Advisories

Advisory: License Enforcement Changes – REST and SOAP

Beginning with the release of InterSystems IRIS® data platform 2022.3, InterSystems corrected the license enforcement mechanism to include REST and SOAP requests. Due to this change, environments with non-core-based licenses that use REST or SOAP may experience greater license utilization after upgrading. To determine if this advisory applies to your InterSystems license, follow the instructions in the FAQ linked below.

Product Alerts & Advisories

Alert: SQL Query using “NOT %INLIST” fails to return results

InterSystems has corrected an issue that can cause a small number of SQL queries to return incorrect results. See below for the specifics on impacted queries.

Product Alerts & Advisories

Alert: Upgrades fail for HealthShare Health Connect instances not licensed for HL7® FHIR®

InterSystems has encountered a defect that causes some upgrades of HealthShare® Health Connect to fail. This only affects instances that are not licensed for the use of FHIR® and that have interoperability-enabled namespaces. Under these conditions, the upgrade fails with an error.

Product Alerts & Advisories

Advisory: AIX Memory Leak

In evaluating an IBM Support notification, InterSystems has determined a potential impact for our customers. The notification in question is:

Product Alerts & Advisories

Alert HS2024-limited: InterSystems IRIS for Health, Health Connect & HealthShare Solution Alert for Customers who Received an Ad Hoc Correction for HSIEO-8613

There is 1 alert in the HealthShare HS2024-limited Alert communication. An alert summary for the issue is shown is in the table below. Details for the alert are contained in the attached document: HS2024 Limited Communication.

Product Alerts & Advisories

Alert HS2024-02: Multiple InterSystems IRIS for Health, Health Connect & HealthShare Solution Alerts

There are 2 alerts in the HealthShare HS2024-02 Alert communication. An alert summary for each issue is shown is in the table below. Details for each alert are contained in the attached document: HS2024-02-Communication.

View All Alerts & Advisories

Sign Up Today

Receive notifications on support alerts, critical issues,
fixes, and product releases.

*Required Fields

Highlighted fields are required

First Name *

Last Name *

Email *

Company Name *

Country *

Please sign me up for the latest news and updates from InterSystems.**

*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.