InterSystems IRIS® for Health Managed Service Change Notes (2025.3.3)
This document is meant to help you assess the impact of upgrading to the InterSystems IRIS® for Health Managed Service 2025.3.3 cloud maintenance release.
InterSystems News, Alerts, and Advisories
From time to time, InterSystems publishes items of immediate importance to users of our software. These include alerts, mission-critical issues, important updates, fixes, and release announcements. You can obtain the most current list at https://www.intersystems.com/support-learning/support/product-news-alerts/Opens in a new tab. InterSystems recommends that you check this list periodically to obtain the latest information on these issues.
Changes Introduced in 2025.3.3
ODBC
DP-447202: Prevent crash when user pass null buffer in SQLBindParam
Category: ODBC
Platforms: All
Version: 2025.3.3
This change corrects an issue that cause the system to attempt writing to a NULL buffer that was passed as an output parameter to SQLBindParameter() ODBC function.
SQL
- Use new SQL CPF parameter to disable NLS collation mismatch logging to messages.log
- Fix missing trailing delimiters in DATEDIFF conditions
- Correct issues with null-handling functions
DP-445590: Use new SQL CPF parameter to disable NLS collation mismatch logging to messages.log
Category: SQL
Platforms: All
Version: 2025.3.3
This change introduces the DisableNLSCollationMismatchLogging CPF parameter for SQL. When this parameter is set to true, the system does not log warnings to messages.log when SQL queries contain globals that have different NLS collations. However, the warnings still appear in the query plan.
DP-447096: Fix missing trailing delimiters in DATEDIFF conditions
Category: SQL
Platforms: All
Version: 2025.3.3
This change resolves an issue that caused DATEDIFF conditions to occassionally fail. The issue has been resolved.
DP-447340: Correct issues with null-handling functions
Category: SQL
Platforms: All
Version: 2025.3.3
Previously, there was an issue that incorrectly handled null-handling functions, such as NVL, COALESCE, or IFNULL. In particular, queries that select from a view, use a null-handling function in a WHERE clause on a field that is derived from a function or case, use the same field in a GROUP BY, and employ a union were affected. The issue has been resolved.
Changes Introduced in 2025.3.2
DataMove
DP-446670: Fix invalid global reference error in %Library.GlobalEdit:CompareRanges()
Category: DataMove
Platforms: All
Version: 2025.3.2
Previously, the CompareRange() method of the %Library.GlobalEdit class could erroneously return an invalid global reference error under certain circumstances. This issue has been resolved.
Interoperability
DP-446688: Correct miscalculated timer count for MasterPendingResponses
Category: Interoperability
Platforms: All
Version: 2025.3.2
Previously, there was an issue that prevented subsequent <sync>s on the same <call> within a BPL process. That issue has been resolved.
JSON
DP-446333: Fix import of JSON strings containing a Unicode character
Category: JSON
Platforms: All
Version: 2025.3.2
Previously, there was an issue that resulted in the improper import of a JSON string via the %FromJSON() or %FromJSONFile methods. In particular, if the JSON string being imported was longer than 8,192 characters and contained at least one Unicode character, then the imported JSON would erroneously contain many $c(0) characters. This issue has been resolved.
SQL
- Fix automatic frozen plan utility upon upgrade
- SQL: Correct LOAD DATA into a linked table (linked via the JDBC Gateway)
- SQL: Correct importing of %Date and %Time fields
DP-446162: Fix automatic frozen plan utility upon upgrade
Category: SQL
Platforms: All
Version: 2025.3.2
This change resolves an issue that prevented the Frozen/Upgrade status from being correctly applied to query plans where the statement includes the IsolationLevel:0 comment option.
DP-446548: SQL: Correct LOAD DATA into a linked table (linked via the JDBC Gateway)
Category: SQL
Platforms: All
Version: 2025.3.2
Previously, if you used LOAD DATA on a linked table created with a JDBC gateway connection, you could receive the following error message: SQLCODE: <-400>: Fatal error occurred %msg: Index 1 out of bounds for length 1. The issue has been resolved.
DP-446556: SQL: Correct importing of %Date and %Time fields
Category: SQL
Platforms: All
Version: 2025.3.2
This change resolves an issue that caused imports of columns with %Date or %Time types to fail with a SQLCODE -147 error.
Changes Introduced in 2025.3.1
Security
DP-445884: Fix unattended startup with KMIP
Category: Security
Platforms: All
Version: 2025.3.1
This change resolves an issue that prevented unattended startup of an instance configured with a KMIP server from completing correctly.
SQL
- Support CTE within CREATE VIEW
- SQL: Correct datatype output conversion for selected value from a subquery
- Correct selectivity for JOINS on outlier fields
DP-441317: Support CTE within CREATE VIEW
Category: SQL
Platforms: All
Version: 2025.3.1
This change adds support for Common Table Expressions within a CREATE OR REPLACE VIEW statement.
DP-444802: SQL: Correct datatype output conversion for selected value from a subquery
Category: SQL
Platforms: All
Version: 2025.3.1
Previously, queries that selected a field that required datatype conversion for Display/ODBC from a subquery did not properly return the external format of the field's value. This issue has been resolved.
DP-445629: Correct selectivity for JOINS on outlier fields
Category: SQL
Platforms: All
Version: 2025.3.1
This change resolves an issue that caused a significant performance decrease in queries that use a JOIN on outlier fields in equivalence classes, largely affecting upgrades from Caché.
System
DP-444964: Modified stat collection to avoid changing the argument stack
Category: System
Platforms: All
Version: 2025.3.1
This change resolves an error that could cause a core dump with signal 11 in the ECPCliR process when serving a long string to an ECP application server while ^TRACE is attached to the ECPSvrW process.
For Additional Help
If you need assistance with evaluating how upgrading to this maintenance release will affect your applications, systems, or related plans, please contact the InterSystems Worldwide Support Center:
- Phone: +1.617.621.0700
- Fax: +1.617.734.9391
- Email: support@intersystems.com
Current release notes (and complete product documentation) can be found online at https://docs.intersystems.com.