I use cspa24.so Apache module to connect to IRIS. I have notified that idle Apache processes will always result in connections being kept open to the IRIS server, and thus some amount of IRIS processes being kept alive (and dedicated to those apache processes) because of those connections.

Eg: if I have 50 idle Apache processes, I will have 50 IRIS processes being kept alive in IRIS even if there is no client connection being made at that time. 

It's even worse with multiple Apache nodes and a load balancer.

Summary

Issue

• Deployments do not serve FHIR Server, bulk FHIR, FHIR SQL, or associated security user interfaces when using a non-default path prefix. For example, when using logical path configurations with Windows IIS, Apache, or other web servers.

This past weekend we ran into something odd. When we failed over our mirror from 2022.1.3 to 2025.1.3 the one of the Business Rules that was on what became the Primary (2025.1.3), had a rule within it that was removed back in January. When the Failover occurred, we had to scramble to backup, disable, and remove the Rule that shouldn't have been there. 

Both the Data and Code live within the same IRIS.dat that is the main MIRROR database for that Namespace. 

If this happened to one Class file, could it happen to others we do not know about?

READY 2026 is almost here, and we’re really curious to hear what everyone is looking forward to this year 🚀

What are you most excited about? It could be a topic you want to explore, a question you’re hoping to get answered or something you’re simply curious about.

Share your thoughts below! We’d love to hear what’s on your mind and see what others are excited about too 💬

Feel free to read through the replies and like the ones you relate to! 😊

Motivation

Why do we need this?

1. Lack of Compiled Context: AI tools only see source code; they don't know what the final compiled routine looks like.

2. Macro Hallucination: Because AI doesn't see our #include files or system macros, it often makes them up, wasting time during debugging.

3. The Documentation Gap: Deep logic optimization often requires understanding internal macros that aren't fully covered in public documentation.

4. Manual Overhead: Currently, the only way to fix this is to manually use the IRIS VS Code extension to find the "truth" in the routine.

Hi Community,

In our two preceding articles, we explored the fundamentals of the Interoperability Embedded Python (IoP) framework, including message handling, production setup, and Python-based business components.

In this third piece, we will examine advanced methodologies and practical patterns within the IoP framework that are pivotal for real-world interoperability implementations.
We will explore the following topics: 

✅ DTL (Data Transformation Language) in IoP
✅ JSON Schema Support
✅ Effective Debugging Techniques

Collectively, these features help us create maintainable, validated, and easily troubleshootable production-grade interoperability solutions.

Hey Community!

Have you attended one of the Global Summits or a previous READY 2025? We’d love your help to inspire others to join InterSystems READY 2026!

We’re inviting community members to record a short video (less than 1 minute) answering one or more of these questions:

• What did you find most valuable about attending?
• What surprised you?
• Why should others join READY 2026?
• Who would benefit most from attending?

Your authentic perspective helps future attendees understand the real impact of these events, beyond the agenda.

🎥 To record a short video, follow the link. No preparation needed.

Hi Community,

We're excited to invite you to the next Community webinar presented by George James Software, an InterSystems partner:

👉 Deltanji source control 👈

🗓️ Date & Time: Thursday, April 9th, 4 pm BST | 11 am EDT

The PACELC theorem was created by Daniel Abadi (University of Maryland, College Park) in 2010 as an extension of the CAP theorem (created by Eric Brewer - Consistency, Availability, and Partition Tolerance). Both help design how to architect the most suitable operation of data platforms in distributed environments under the aspects of consistency versus availability. The difference is that PACELC also allows analysis of the best option for non-distributed environments, making it the gold standard for considering all possible scenarios to define your deployment topology and architecture.

The CAP theorem states that in distributed systems, it is not possible to have consistency, availability, and partition tolerance simultaneously, requiring a choice of two out of three, according to the following diagram.

Source: https://medium.com/nerd-for-tech/understand-cap-theorem-751f0672890e

Hi Community!

We’re building a series of short, hands-on Instruqt tutorials to help newcomers get up to speed with InterSystems technologies faster and more effectively. To kick things off, we’ve just released a new tutorial, “Data Models of InterSystems IRIS,” covering the fundamentals of the IRIS multimodel approach. This is exactly the type of focused, concise, practical learning experience we want to expand. And this is where you come in!

We’d love to hear your ideas for other tutorial topics to help developers new to InterSystems IRIS take their first steps with confidence. Please welcome the new sweepstakes:

💡 Topics for hands-on Instruqt Tutorials 💡

hi 😊,

i'm able to LOAD DATA in IRIS from a rather complex, say Oracle's, query. It works pretty well but requires a target table created aforehand:

LOAD DATA FROM JDBC CONNECTION SOME_OTHER_SERVER QUERY 'complex query here' INTO TargetTable

is there a way to base such target table on the same query ? 
CREATE FOREIGN TABLE seems to require a column definition which I would prefer to be taken from the query
CREATE TABLE AS SELECT seems to be for local queries and other methods, like Linked Table Wizard or %SYSTEM.SQL.Schema.

Hello,

I am working on integrating a CELL-DYN Ruby hematology analyzer (Abbott) with InterSystems Ensemble using the ASTM E1394 protocol over TCP/IP via a Digi One SP serial-to-TCP converter. I am facing a persistent issue where the Link Test keeps failing on the CDRuby side and the Transmit button remains greyed out. I have overridden EOTOptional=1 in the service class file as Ensemble was not able to send ACK after ENQ. Now I am getting below logs like Machine sends ENQ, Ensemble sends back ACK and Machine sends EOT instead of STX.

Hey Developers,

Thank you for being part of the InterSystems Developer Ecosystem! 
We truly appreciate your participation across the Developer Community, Open Exchange, Global Masters, and the Ideas Portal.

Each year we run a short survey to understand how we can improve our platforms and better support developers like you. Your feedback helps us shape the future of the ecosystem.

Please take a few minutes to complete the survey:

👉 InterSystems Developer Ecosystem Annual Survey 2026 (3-5 min, 12 questions)

Note: The survey takes less than 5 minutes to complete.

Hey Community,

We're bringing our Developer Ecosystem session back to READY 2026.

👥 Streamlining Development Workflow with InterSystems Developer Community and Ecosystem 

🗓️ Wednesday, April 29, 2026
🕑 3:30 PM – 3:50 PM ET
📍 Cherry Blossom, Gaylord National Resort & Convention Center, National Harbor, MD 

Please, provide Code example to build a %Library.DynamicObject or a %Library.DynamicArray from Resultset followed by converting to JSON

Hi everyone,

I was wondering if it is possible to use the InterSystems Server VSCode Extension to work in client side mode but importing locally the content of a project without having to choose the files manually.

It would be awesome to have all project-related assets synchronized in one go. Relying on InterSystems Projects (.prj files) would be convenient for several reasons:

1. Projects bundle different file types (CLS, MAC, INT, CSP). Importing the project as a whole is much more efficient than picking individual files piece by piece.

Claude Code has a strong understanding of IRIS, but unexpected issues still occur.

The first issue is one that has already happened several times and is likely to continue occurring if not properly addressed.

In IRIS, the collation for string data (%String) is set to SQLUPPER by default. As a result, when data is retrieved via SQL, it may be returned in uppercase (for example, when sorting and aggregating with GROUP BY).

HealthShare Unified Care Record Fundamentals – Virtual* May 4-8, 2026

*Please review the important prerequisite requirements for this class prior to registering.

• Learn the architecture, configuration, and management of HealthShare Unified Care Record.
• This 5-day course teaches HealthShare Unified Care Record users and integrators the HealthShare Unified Care Record architecture and administration tasks. 
• The course also includes how to install HealthShare Unified Care Record. 
• This course is intended for HealthShare Unified Care Record developers, integrators, administrators and managers.

Hi Community!

Welcome to Issue #28 of the InterSystems Ideas newsletter! Let's look at the latest news from the Ideas Portal, such as:

✓ General Statistics
✓ Update on the current sweepstakes
✓ Your ideas implemented by InterSystems

And a little teaser: look forward to an exciting initiative linking Ideas Portal, Open Exchange, Global Masters, and Developer Community!

Hi, Community!

Need help setting up OAuth on the FHIR Server? We'll guide you through the workflow:

Configuring OAuth for InterSystems FHIR Server