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

Alert: Large ODBC Query Results Incomplete

November 3, 2015 – Alert: Large ODBC Query Results Incomplete

InterSystems has corrected a defect with the Caché ODBC driver that can result in incomplete query results. The problem can occur when the total size of all rows returned would exceed 4KB. There is no indication that the failure has occurred. Results greater than 4KB are truncated.

This defect exists only in the Caché ODBC driver that is distributed with versions 2015.2.0 and 2015.2.1 of Caché, Ensemble, and HealthShare. The risk is present for all platforms and operating systems.

The corrections for this defect are identified as JCN1662 and JCN1665. They will be included in all future releases of Caché, Ensemble, and HealthShare.

Caché ODBC drivers are designed to be upward and backward compatible. Until corrected Caché ODBC drivers for 2015.2 are available, drivers from older versions can be used to avoid this issue. Drivers for older versions are available in the download area of the Worldwide Response Center (WRC) application.

If you have any questions regarding this advisory, or need assistance with obtaining and installing drivers, please contact the Worldwide Response Center.

Latest Alerts & Advisories

Apr 17, 2025
InterSystems has addressed security vulnerabilities that impact applications using OAuth2 Client configurations on 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).
Apr 02, 2025
Product & Versions Affected Explicit Requirements DP-439207 InterSystems IRIS® data platform 2024.3 (AIX) AIX installations Using JSON processing and Unicode non-Latin-1 character sets DP-439280 InterSystems IRIS 2024.3 (containers with IntegratedML) IntegratedML Containers using TensorFlow
Mar 04, 2025
This problem affects the following products:
Mar 04, 2025
This problem affects the following products:

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.