Hi Community,

I’m trying to execute a directory query in InterSystems IRIS using %SQL.Statement, but encountering an unexpected error.

Details:
The following command confirms that the directory exists:

Set dirPath="\\MYNETWORK_DRIVE\DFS-Shared_Product\GXM"
Write ##class(%File).DirectoryExists(dirPath)

It returns 1, meaning the path is valid and accessible.

However, when I try to execute this SQL query:

1 3
0 65
InterSystems Developer Community is a community of 25,131 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hi Community!

We are excited to announce the new French technical article writing contest!

✍️ Technical Article Contest ✍️

This is the perfect opportunity for all InterSystems technology enthusiasts to share their knowledge and showcase their writing skills. No matter your experience level, everyone is welcome to participate. Articles can cover a wide range of topics, from technical implementation to your impressions and feedback on using InterSystems products or services. So let your creativity and expertise run wild!

📅 Contest period: September 15 - November 30, 2025 (extended!)

🎁 Gifts for all: a special gift is prepared for each participant!

🏅 Prizes for the authors of the best articles

2 0
0 68

Hi, Community!

Need to connect your .NET application to InterSystems IRIS® data platform? See how Entity Framework Core can help:

Using Entity Framework Core with InterSystems IRIS

https://www.youtube.com/embed/7VGfcCkO_-Q?utm_source=youtube&utm_medium=social&utm_campaign=7VGfcCkO_-Q
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
1 68
Hello and welcome to the March 2025 Developer Community YouTube Recap.
InterSystems Global Summit
By Andreas Dieckow, Amy Farley
By Timothy Leavitt, Gerrit Henning, Stephan du Plooy
By Keren Skubach, Vic Sun, Steve Mallam
FHIR Object Model
By Patrick Jamieson, Jaideep Majumdar
"Code to Care" videos
Is your data ready for AI?
By Don Woodlock, Head of Global Healthcare Solutions, InterSystems
Energy Consumption for AI
By Jessica Jowdy, Manager of Healthcare Sales Engineering, InterSystems
1 0
0 68

Hi,

I'd like to report a really strange behavior of the Intersystems Lite Terminal after executing a simple ObjectScript instruction.

From the Intersystems Lite terminal, execute the following instructions:

- Set uniqueId = "12345678_1"
- Set uniqueId = $p(uniqueId,"_",1)_"_"_($p(uniqueId,"_",*)+1)
After executing the second instruction, the terminal closes without any error.

1 4
0 63

IKO Helm Status: WFH

Here is an option for your headspace if you are designing an multi-cluster architecture and the Operator is an FTE to the design. You can run the Operator from a central Kubernetes cluster (A), and point it to another Kubernetes cluster (B), so that when the apply an IrisCluster to B the Operator works remotely on A and plans the cluster accordingly on B. This design keeps some resource heat off the actual workload cluster, spares us some serviceaccounts/rbac and gives us only one operator deployment to worry about so we can concentrate on the IRIS workloads.

3 1
1 47

Technical Documentation — Quarkus IRIS Monitor System

1. Purpose and Scope

This module enables integration between Quarkus-based Java applications and InterSystems IRIS’s native performance monitoring capabilities.
It allows a developer to annotate methods with @PerfmonReport, which triggers IRIS’s ^PERFMON routines automatically around method execution, generating performance reports without manual intervention.

1 1
0 47

Our vendor is developing an interface API on their end to capture HL7 data on a Server Port, and they require us to send a pre-defined HL7 Order message for testing every hour until the API is completely operational.

Is it possible to accomplish that in a Business Operation automatically without utilizing a service or process? The BO is a standard TCP/IP connection.

I'm manually sending the message again from the Operations right now. I do not have access to the System Operation to use the Task Manager feature.

1 3
0 64

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

HealthShares Nav App as a Service Orchestrator with Single SignOn for 3rd Party Apps @ Global Summit 2024

https://www.youtube.com/embed/8BkDBpj1Cyo
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 67

Overview I'm excited to announce the release of testcontainers-iris-node, a Node.js library that makes it easy to spin up temporary InterSystems IRIS containers for integration and E2E testing. This project is a natural addition to the existing family of Testcontainers adapters for IRIS, including testcontainers-iris-python and testcontainers-iris-java.

Why testcontainers-iris-node? As a Node.js developer working with InterSystems IRIS, I often faced challenges when setting up test environments that mimic production. testcontainers-iris-node solves this by leveraging the testcontainers-node framework to create isolated IRIS environments on-demand.

This is particularly valuable for:

  • Integration testing with IRIS databases
  • Testing data pipelines or microservices
  • Automating test environments in CI pipelines

Features

  • Launches IRIS in Docker containers using Testcontainers
  • Supports custom Docker images and configuration
  • Wait strategies to ensure IRIS is ready before tests begin
  • Clean teardown between test runs

2 0
1 67

Hello,

I'm trying to connect a Python backend application to an InterSystems IRIS Community Edition instance running in a Docker container on an AWS EC2 instance. I'm facing persistent connection issues and an SSL Error despite the Superserver apparently having SSL disabled. I'm hoping for some insight into what might be causing this contradictory behavior.

My Setup:

0 2
0 65

Hello,

I have a problem generating QR code in Caché now.

After executing the code

set Status=##Class(%SYS.QRCode).GenerateImage(P0,,.DataURI)

(variable P0 contains data for QR code)

an error is displayed now:

0 1
0 66

I have a stream that I read out until the end. I then append more content to the stream and want to read out only what has been added. How do I only read out the new contents of the stream? Essentially, I want to read a stream, record the end position, then once the stream is updated read the contents from that recorded position until at the new end. This stream needs to be kept intact for historical reference so cannot be cleared between reads.

0 2
0 65

I am testing vectorsearch, while doing so I am trying to paginate my resultset for a "next page" function to give me the first, second, third 15 entries within a table.

For this I have two embedding classes. One with a HNSW Index (vectornomicembedtextlatest) , and one without (vectornomicembedtexttest).

Calling SELECT ID,PRIMKEY FROM SQLUser.vectornomicembedtexttest LIMIT 5 OFFSET 1 works fine with the first entry having the rowID of 486448. (I deleted old entries in the beginning and reused the table)

0 0
0 67

I have a widget that uses "choose Data source" control option. Termlist for the control consist of the two data sources and i want to set one of them by default. For example: I have two data sources, one is grouped by month, the other by year. I need to set the one that is grouped by year by default

Using default value at the bottom return an error

How can i achive that?

0 2
0 65

Hi, Community!

Looking to get actionable insights from your healthcare research? See how InterSystems OMOP can help:

👨‍🔬What is InterSystems OMOP?

https://www.youtube.com/embed/otS3vi4FMt0?utm_source=youtube&utm_medium=social&utm_campaign=otS3vi4FMt0
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 67

Hey Community!

We are pleased to invite everyone to participate in the new webinar in German dedicated to AI:

➡️ Interoperability as a catalyst for AI

Date & Time: March 11, 2025, 3:30 pm CET

👨‍🏫 Speakers:

  • @Thomas Nitzsche, Sales Manager, InterSystems
  • Dr. Olaf Iseringhausen, Head of Competence Center Health Care Solutions, Bechtle
  • Dr. @Erion Dasho, Clinical Advisor, InterSystems

0 0
0 67
Hello and welcome to the January 2025 Developer Community YouTube Recap.
InterSystems Global Summit
By Jon Sue-Ho, Senior Security Engineer, InterSystems
By Murray Oldfield, Mark Bolinsky
InterSystems Package Manager
By Timothy Leavitt, Bob Kuszewski
Containers & Kubernetes - Proper Use and Lessons Learned
By Mark Bolinsky, Ari Glikman, Bob Kuszewski, Kai Zou
Moving to InterSystems Reports
By Eric Hoelper, Michael Braam
1 0
0 67