2006 Ensemble News, Alerts, and Advisories

Receive these Ensemble News, Alerts, and Advisories by E-mail

November 9, 2006 – Caché 5.2, Ensemble 4.0 and >2 GB Shared Memory

InterSystems Worldwide Response Center (WRC) has identified a defect in Caché 5.2 and Ensemble 4.0 that can cause unpredictable behavior for instances configured with more than 2GB of shared memory.

This defect is present in Caché version 5.2 on all platforms and operating systems.

This defect is present in Ensemble version 4.0 on all platforms and operating systems.

Caché shared memory includes: global buffers, routine buffers, gmheap, lock table, network structures and other internal uses.

The risk from this defect is high. Observed incorrect behavior includes inability to run the System Management Portal and access violations at startup. Other failures modes are possible. InterSystems strongly recommends that any system running a Caché 5.2 instance or Ensemble 4.0 should install the corrections to this defect (see next paragraph).

Four corrections exist for various aspects of this defect; they are identified as SAP643, SAP663, SAP686 and SAP696. A maintenance release of Caché designated Caché 5.2.3 will be available within the next few weeks. The corrections can also be ordered in an Ad Hoc distribution from the WRC.

A related correction, SAP672, addresses a problem with an incorrect message in startup log files. The result is a message indicating a very low number of buffers allocated even though the number of buffers actually allocated is correct. This problem is limited to 64-bit UNIX platforms.

If you have any questions regarding this advisory, please contact the Worldwide Response Center at support@intersystems.com.

October 13, 2006 – ODBC Client return wrong Stream data

A problem has been corrected where the Caché ODBC client would return wrong stream data. The problem was in a conversion of the stream’s ID value from Hex to decimal and would start to happen with Stream ID values of 130 or greater.

Where:
Caché 5.2, Ensemble 4.0

Symptoms:
If you select a Stream field from a table where the Stream ID equaled 130 we would return a point to stream 63. This is just one example, the problem happens for other values of the Stream ID.

Cause:
The value of the Stream ID was getting converted to Multi Bit when it should have been a binary value. This caused the server to return the wrong stream.

Solution:
InterSystems has a patch available that will prevent this problem from happening. If you would like to receive this patch please contact Support and reference Dev Change JCN723. This correction will be part of Caché 2007.1

If you have any questions regarding this advisory, please contact the Worldwide Response Center at support@intersystems.com.

October 2, 2006 – Correction to SQL NOT with AND or OR

A problem has been corrected where SQL queries containing NOT in the WHERE clause in conjunction with AND or OR could return the wrong results.

Where:
Caché 5.2, Ensemble 4.0

Symptoms:
Query that match the following format:
SELECT f1 from Table1 where NOT (... AND...)
SELECT f1 from Table1 where NOT (... OR ...)

Cause:
A bug fix that overhauled the way negation was handled in SQL statements was incompletely integrated into Cache 5.2, which introduced this problem.

Solution:
InterSystems has a patch available that will prevent this problem from happening. If you would like to receive this patch please contact Support and reference Dev Change JLF090 and JLF111. This correction will be part of Caché 2007.1 and Ensemble 4.0.1

If you have any questions regarding this, please contact the InterSystems Worldwide Response Center (WRC) at Worldwide Response Center.