Skip to content
Effettua una ricerca per conoscere i prodotti e le soluzioni di InterSystems, le opportunità di carriera e altro ancora.

Alert: Possible Query, Compilation, and Data Access Issues with Unicode Character 223 (ß)

September 19, 2019 – Alert: Possible Query, Compilation, and Data Access Issues with Unicode Character 223 (ß)

InterSystems has corrected a defect in applications that use Unicode character 223 (ß). This defect can result in incomplete query results, class compilation errors, and removal of custom SQL privileges.

This problem occurs on systems that are running or have previously run on:

  • Caché and Ensemble 2018.1.0, 2018.1.1, and 2018.1.2
  • HealthShare Health Connect (HSAP) 15.032 on Core versions 2018.1.0, 2018.1.1, and 2018.1.2
  • HealthShare Health Connect 2019.1
  • InterSystems IRIS data platform – all currently released versions
  • InterSystems IRIS for Health – all currently released versions

The defect is triggered by data and component names containing Unicode character 223 (ß). In the versions listed above, an uppercase conversion incorrectly maps that character to Unicode character 7838 (ẞ).  Applications perform this uppercase conversion using features such as $ZCONVERT and %SQLUPPER.

Problems can occur when accessing data or classes created or modified on a product with a different uppercase conversion than the one currently in use.

Mitigating Issues with Incomplete Query Results

This issue can cause problems in applications that use uppercase conversion. Also, InterSystems SQL uses uppercase conversion by default for indices, so queries on a dataset containing this character can return incorrect results.

To address this defect, InterSystems recommends that you rebuild all indices after upgrading from an unaffected version to an affected version, and vice versa.

Mitigating Issues with Class Compilation and Data Access

For classes with names or components that contain the ß character, the defect can also cause class compilation to fail in one of several ways.

In one case, compilation can fail with a message such as:

ERROR #5503: Field name is invalid: Field (Prop1ö) is not unique within Table (ISC.ße). (Prop1ö)

In a second case, compilation can report success but actually delete the table. In this situation, there are messages during compilation such as:

Dropping orphaned table: ISC.ße

Dropping orphaned procedure: ISC.ẞE_EXTENT

These messages indicate that the table has been dropped, though its underlying data is not removed. In this case, any custom SQL permissions on that table will be lost, causing data access issues.

For this situation, InterSystems recommends the following solution: After upgrading to or from an affected version, but prior to compiling any affected classes, export any users and roles that have been granted SQL permissions on any affected tables. To do this, use either the ^SECURITY routine or the Export class methods of the Security.Users and Security.Roles classes. Make sure to include SQL privileges, which are not included by default in the export via either of these methods. (For more information, see the article “ Tips on exporting and importing security settings” on the InterSystems Developer Community.)

If the table is dropped during compilation, you can re-import the users and roles after successfully compiling the class, either via ^SECURITY or the corresponding Import class method.

Obtaining an Update and More Information

The correction for this defect is identified as JLC2212, which will be included in all future product releases. It is also available via Ad hoc change file (patch) or full kit distribution from the WRC. If you have any questions regarding this alert, please contact the Worldwide Response Center (WRC).

Latest Alerts & Advisories

15 Aug 2024
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.
24 Jul 2024
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.
24 Jun 2024
Broadcom recently announced a problem that can cause data consistency errors in database applications. The Broadcom article is available here:
30 May 2024
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.
01 May 2024
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.
08 Apr 2024
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.
19 Mar 2024
In evaluating an IBM Support notification, InterSystems has determined a potential impact for our customers. The notification in question is:
27 Feb 2024
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.
01 Feb 2024
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.