Hi Community,

Check out the new video that shows how to easily create solutions using InterSystems IRIS:

📺 Building Smarter Applications with InterSystems IRIS

Summary of Alerts

Detail of Alerts

DP-439207 - AIX JSON Unicode Parsing Issue

A bug has been identified in InterSystems IRIS 2024.3.0 on AIX instances that affects the parsing of JSON Unicode strings. The issue arises when either the %FromJSON() or %FromJSONFile() method

Hi Guys,

Not sure what I'm missing here, I'm using to download files that starts with MTC_88 from S3 bucket using AmazonS3 inboundAdapter as below, but I'm not getting anything and I'm sure there thousands of files that starts with MTC_88 

and the log is not getting any errors?

Thanks

If you want to know if a class about a topic already exists asking a simple natural language question, it is possible now. Download and run the application https://openexchange.intersystems.com/package/langchain-iris-tool to know all about your project classes in a Chat.

 JSON Web Token (JWT) Authentication

Hi Everyone,

I would like to share the code and step-by-step instructions/or guideline for generating a JWT (JSON Web Token) signature, as well as how to test it using Postman / HealthConnect.

JWT is an open standard (RFC 7519) that defines a compact, URL-safe method for securely transmitting information between parties in the form of a JSON object.

Structure of a JWT:

A JWT consists of three parts, separated by dots (.):

1. Header: The header contains about the token, specifying its type and the signing

Hi all,

As part of the development an API to know what is the instance of IRIS is connected, I've found some methods to know information about the server that can help you.

Get the server name: $SYSTEM.INetInfo.LocalHostName()

Get the server IP: $SYSTEM.INetInfo.HostNameToAddr($SYSTEM.INetInfo.LocalHostName())

Get the instance name: $PIECE($SYSTEM,":",2)

So, I have created the following code as BS class:

Class St.Common.Api Extends (%CSP.REST, Ens.BusinessService)
{
{

XData UrlMap [ XMLNamespace = "http://www.intersystems.com/urlmap" ]
{
<Routes>
	<Route Url="/check" Method="GET" Call="Check

When batch inserting data into a table via SQL, I can use the %NOCHECK keyword to avoid checking foreign key integrity.  This would be appropriate for cases when the inserted data has been verified by some external process.

However, when inserting via objects, I don't see a way to get the same behavior.  Are there any workarounds that use objects for this?

For this case, I have a tool (Tier 2 CCR) for loading many objects into a namespace.The referential integrity of these objects has already be confirmed in a source namespace.

Hi,

I've a list of running scheduled task in task manger and would to crate a tasks to monitor if any of my tasks has stopped running, is there a function to check tasks status?  

Thanks 

Prompt

Firstly, we need to understand what prompt words are and what their functions are.

Prompt Engineering

Hint word engineering is a method specifically designed for optimizing language models.
Its goal is to guide these models to generate more accurate and targeted output text by designing and adjusting the input prompt words.

Core Functions of Prompts

• Improve content matching: By accurately expressing your needs, AI can generate high-quality content that better meets expectations
• Efficiency and time optimization: A clear prompt can directly obtain the desired answer, reducing the time for

Now it is possible ask your IRIS server using an AI Chat or compose other agent applications to get:

1. List the server metrics
2. Return intersystems iris server information
3. Save the global value Hello to the global name Greetings
4. Get the global value Greetings
5. Kill the global Greetings
6. List the classes on IRIS Server
7. Where is intersystems iris installed?
8. Return namespace information from the USER
9. List the CSP Applications
10. List the server files on namespace USER
11. List the jobs on namespace %SYS

To do it, get and install the new package langchain-iris-tool

If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you made a major change and expect a changed review just let me know.

We are receiving the report in text format and it has special characters like ', - like that in the text. Source system is using the UTF8 encoding format hence the text is showing as ' � ' . Is there a way to convert the utf8 to actual character in the DTL.

Thank you,

Hey Community,

It's time for the first programming contest of the year, and there's a surprise so read on! Please welcome:

🏆 InterSystems AI Programming Contest: Vector Search, GenAI, and AI Agents 🏆

Duration: March 17 - April 6, 2025

Prize pool: $12,000 + a chance to be invited to the GlobalSummit2025!

As an IT and cloud team manager with 18 years of experience with InterSystems technologies, I recently led our team in the transformation of our traditional on-premises ERP system to a cloud-based solution. We embarked on deploying InterSystems IRIS within a Kubernetes environment on AWS EKS, aiming to achieve a scalable, performant, and secure system. Central to this endeavor was the utilization of the AWS Application Load Balancer (ALB) as our ingress controller. 

However, our challenge extended beyond the initial cluster and application deployment; we needed to establish an efficient and

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯  Rapidly Create and Deploy Secure REST Services on InterSystems IRIS @ Global Summit 2024

 I have dynamic sql select query ,

Set resultset = ##class(%ResultSet).%New()

 set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'"

 SET SC = resultset.Prepare(sql)

 SET SC = resultset.Execute(sql)

How can I print/view the count ?

Is there a way to use a property of the type %Persistent class in a %ZEN.Component.page class?
Example:

// Data classClass PersistentClass Extends %Persistent
{
    Property Value As%String;
}

// Page classClass ClassName Extends%ZEN.Component.page
{
  Property TestProperty As PersistentClass; 
}

The problem is that when using it the described in the example.
The property can be set in a Method like this:

Method DoStuff() As %Status  [ ZenMethod ]
{
    Set result = ##class(HBS.EnsUtil.CompanyFunctions).GetData(.aVariable) // aVariable is of type PersistentClass
    Set..TestProper

InterSystems FAQ rubric

You can use the WriteToConsoleLog method of the %SYS.System class to write any message to the console log.

The following is an example:

%SYS>write##class(%SYS.System).WriteToConsoleLog("xxxxx log message",0,0)
1

For details on the parameters that can be specified in the WriteToConsoleLog method, please refer to the following document:

Class Reference (%SYS.System) 【IRIS】

Class Reference (%SYS.System)

Hello,

I tried to define Pool Size in System Default Settings, but it is not being used. I see I am not the first to try this without success:

Define PoolSize as system default value | InterSystems Developer Community
 

Any suggestions?

Here is my code:

Method getStocks(pRequest As Stock.Message.Req, Output pResponse As Ens.StreamContainer) As %Status
{
     s tSC = pRequest.NewResponse(.pResponse)
     q:$$$ISERR(tSC) tSC

     #dim pRS As EnsLib.SQL.GatewayResultSet

     s tSC = ..Adapter.ExecuteQuery(.pRS, "select jsonb_agg(s) #>> '{}' FROM prod.stocks s where s.""Warehouse"" = ?", pRequest.Warehouse)
     q:$$$ISERR(tSC) tSC

     s pResponse = ##class(Ens.StreamContainer).%New()
     s pResponse.Stream = ##class(%GlobalCharacterStream).%New()

     i pRS.Next() {
          d pResponse.Stream.CopyFrom(pRS.GetDataStream(1))
     } else 

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Quick wins with InterSystems IRIS Vector DB

InterSystems Announces General Availability of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect 2025.1

The 2025.1 release of InterSystems IRIS® data platform, InterSystems IRIS^® for Health^TM, and HealthShare^® Health Connect is now Generally Available (GA). This is an Extended Maintenance (EM) release.

Release Highlights

In this exciting release, users can expect several new features and enhancements, including:

1. Advanced Vector Search Capabilities
   
   • A new disk-based Approximate Nearest Neighbor (ANN) index significantly accelerates vector search queries, yielding

Join our next in-person Developer Meetup in Cambridge to explore the latest trends, tools, and features for innovating on health data.

This event will bring you into the conversation on GenAI and the evolution of AI Agents.

Talk 1: From GenAI to Real ROI
Dr. Qi Li will use recent client projects on back office automation using GenAI to achieve meaningful ROI for healthcare organization. He will review the techniques used to address training set limitations. He will also describe real world examples of how to set threshold to maximize benefit and minimize side effects.

Speaker: Dr.Qi Li, M.D.

Managing InterSystems Servers – In-Person  April 14-18, 2025

• Configure, manage, plan, and monitor system operations of InterSystems Data Platform technology
• This five-day course teaches system and database administrators how to install, configure and secure InterSystems server software, configure for high availability and disaster recovery, and monitor the system. Students also learn troubleshooting techniques.
• This course is applicable to both InterSystems IRIS and Caché. Although the course is mostly platform independent, students can complete the exercises using either Windows or Ubuntu.

Hi!
I have installed IRIS 2024.1 in RHEL 9.5, using the following 

sudo ISC_PACKAGE_INSTANCENAME="IRISTEST01" ISC_PACKAGE_INSTALLDIR="/iris" \
ISC_PACKAGE_UNICODE="N"  ISC_PACKAGE_INITIAL_SECURITY="Normal" \
ISC_PACKAGE_INSTALL_INTEGRATEDML="N" ISC_PACKAGE_MGRUSER="irisowner" \
ISC_PACKAGE_MGRGROUP="irismgr" ISC_PACKAGE_USER_PASSWORD="**************"  \
ISC_PACKAGE_IRISUSER="irisusr" ISC_PACKAGE_IRISGROUP="irisgrp" \
ISC_PACKAGE_CSPSYSTEM_PASSWORD="**************" ISC_PACKAGE_WEB_CONFIGURE="Y" \
ISC_PACKAGE_WEB_SERVERTYPE="Apache" ISC_PACKAGE_WEB_APACHE_VERSION="2.4" \

Hello interface engineers and app developers,     

Did you know that you can use Python in productions or integrations?

The production configuration user interface is low-code, but in many projects, you may reach a point where you need to write some code. As discussed in the Integration Architecture course, business processes are full of places for inserting code, specifically the BPL editor (for BPL business processes) and the DTL editor (for data transformations).

😯 As of InterSystems IRIS 2025.1, both Python and InterSystems ObjectScript are supported in the BPL and DTL editors.

Hi!
I have question about MDX functionality in context of IRIS Analytics.

How does IRIS MDX distinct selection works? Is there any restruqtion when analyzing strings? Like special symbols or length?
Here is an example
I have this data:
 6 rows and 2 of them unique
Then we create data cube based on this model and examine it with Analyzer
 
Detailed listing 
6 rows an ONE unique string. Which is obviously not true. 
This happed only with string with symbols in it
My task is to get the right amount of unique strings

Are you a developer, data engineer, integration engineer, or data scientist who works hands-on with InterSystems products? 

We are conducting 30-45 minute interviews to understand your experience — how you started with InterSystems products, where you find helpful code samples, and how we can improve our products to better support your journey. 

✅ If you’re interested, fill out a quick survey to share your contact info and experience.

If you're selected, we will schedule a session at your convenience between April 2 and May 8 for an interview based on the information you provide.

🎁 As a thank-you, interview participants will receive 10,000 Global Masters points!

Your feedback will directly help us improve your experience using InterSystems products and services.

Kindly note that the spots are limited. 

Hi all.

I'm trying to create an indexed table with an vector field so I can search by the vector value.
I've been investigating and found that to get the vector value based on the text (token), use a Python method like the following:

ClassMethod TokenizeData(desc As%String) As%String [ Language = python ]
{
    import iris
    # Step 2: Generate Document Embeddings
    from sentence_transformers import SentenceTransformer

    model = SentenceTransformer('/opt/irisbuild/all-MiniLM-L6-v2')

    # Generate embeddings for each document
    document_embeddings = model.encode(desc)

    r

Role: Principal Architect and Integration Engineer

Employment Type: Full Time 

Note: Expertise in Rhapsody/Intersystems is Mandatory.

Main Responsibilities  

1. Technology Strategy Key contributor to the technology strategy for the business, setting a north star, and driving excellence for our adoption and implementation of technologies to deliver Data Sharing/Integration, API Enablement, and Data Migration Services now and into the future. 

2. Customer Facing This technical leader will represent technology in the public eye, can think quick on their feet and are a confidence building