#InterSystems IRIS

Killer presentations are essential for opening doors, doing business and delighting customers. These types of presentations move away from the traditional and tiring topics and portions of texts, or even pictures of happy people to get closer to the interests of their audience.The best presentations materialize what customers are looking for into something they can see working. Instead of promises, examples in execution and the ability to be very close to what you want to do.

Work Queue Manager (WQM) is a feature of InterSystems IRIS that enables you to improve performance by distributing work to multiple concurrent processes programmatically. The idea is that you split the work into chunks, and WQM distributes the chunks across worker processes and can provide the info that the work is done.

However, recently, I got an interesting question: there's a large logical transaction composed of ~1,000,000 individual objects and SQL inserts and updates. Some updates are CPU-intensive, so the original idea was to use WQM to split an update into chunks to speed things up. 

But, here's a catch: if one of the individual 1,000,000 changes fails (there's a variety of application-level checks so that it can fail, and that's not even that abnormal a behavior), the entire transaction must be rolled back. That creates a problem: each chunk must report success before committing their individual transactions, and someone must get all these reports and decide if we are committing or not.

Unfortunately, it looks like WQM does not have a bidirectional communication between workers and manager, so I suggested an approach using events:

1. Start jobs.
2. Wait for all jobs to report success using $System.Event.WaitMsg().
3. Send Commit or Rollback using the $System.Event.Signal().

Below is the job description for your reference 

Position: Integration Engineer/SME  (US only) 

Location: Remote 

Contract: 12 months 

Job Description:

Description:

Looking for IRIS experience must have 

Lead the implementation of FHIR (Fast Healthcare Interoperability Resources) standards within the data warehouse, ensuring accuracy and efficient data exchange across the ecosystem of partner APIs

• Ingest healthcare data from source systems into FHIR resources and profiles through developing ETL (Extract, Transform, Load) processes, checking for data quality and integrity

• Create and maintain data

Hi,

I have an odd problem that occurs when I'm trying to import lookup tables in the XML format into Studio.

I store my files in in C:\CodeRepository.

I can manually import these lookup tables using "Import local..." option in the InterSystems Studio. 

However, when I'm trying to import them using command in terminal: do $system.OBJ.LoadDir("C:\CodeRepository\","ck")

I'm getting the following error:

Loading file C:\CodeRepository\Title.lut.xml as xml
ERROR #5863: Another user has 'Title.LUT' open for editing.
  > ERROR #6315: Errors reporting importing XML subelement in file

A quick question. What's the shortcut to uncomment multiple lines of code in Studio? And what's the shortcut to comment out multiple lines of code in Studio?

Thanks in advance!

• The idea of this package is to compare the performance of columnar storage    inside IRIS without wrapping it to some foreign platform that is not my world   
• In addition, I do not want to measure network performance between 2 containers,     but inside a closed IRIS environment that I have fully under my control
• Even the use of SMP or some other browser-based presentation has some influence that I want to avoid.
• Measuring should be as close to the core as possible. So I flagged it NATIVE. Some people might feel it is ABORIGINAL.

As most of you probably already know, since approximately the end of 2022 InterSystems IRIS included the columnar storage functionality to its database, well, in today's article we are going to put it to the test in comparison to the usual row storage.

Columnar Storage

What is the main characteristic of this type of storage?

"Set Up a Kerberized Connection from the Web Gateway to InterSystems IRIS " and "Configuring the Web Gateway to Connect to InterSystems IRIS Using TLS" are these two alternative options that exclude each other? Which option should I select if I want to establish a tls connection between a client (browser) and IRIS server?

I had a question about using ZSTART, ZSTOP, and ZMIRROR.

• If we use them and it is not correct, does it mess up with any of the existing functionality?
• So, if I create a ZSTART with a simple command of starting the %JDBC Server will that mess up anything existing in the Startup sequence?
• Is ZSTART, ZSTOP, and ZMIRROR just an extension of the existing functionality, or does it alter how the built in functionality runs?
• Should we tread lightly in the use of them?

Has anyone come up with a way to put a delay in a routing rule? We have text and PDF results sending to EPIC and need to put a delay on the PDF send so the text posts first in EPIC.

Thank you!

InterSystems announces its fourth preview, as part of the developer preview program for the 2024.1 release.  This release will include InterSystems IRIS^®,  InterSystems IRIS^® for Health^TM, and HealthShare^® Health Connect.

Highlights

Many updates and enhancements have been added in 2024.1 and there are also brand-new capabilities, such as Using vectors in ObjectScript,  Vector Search (experimental), Multi-Volume Database, the ability to use Fast Online Backup (experimental), and the introduction of Multiple Super Server Ports.

How to send the HL7 Batch messages over a SOAP webservice which takes 3 credentials(Username, Password& Org.ID) using IRIS Management Portal V 2019.1?

WSDL   xsd : element - 1.Username , 2.Password ,3.Org.ID ,4.HL7 Message.

Info I had -  

Source is CSV File will be translated to HL7 using data Transformations. All the transformed messages need to be sent to destination System through SOAP request as a single Batch File.

Challenge faced was - How to send the request message (Message Structure asked : Username , Password, Org.ID and HL7 message )in batch transformation.

While creating the WSDL, I'm encountering the following error:

"Mismatched definition of ELEMENTQUALIFIED for the class in the namespace http://www.test.xx/xyx/abc-ns/xsd/v1: CSP Error"

Why am I getting this error while generating the WSDL?

Can someone guide me to understand this issue?

Hi all,

Does anybody have the same issue?

$ZF(-100) to run python script not work when directly execute in studio or in storedproc called by TrakCare, but can work when do in iris session.

The python script imports a "barcode" package. It seems that when directly execute in studio or in storedproc called by TrakCare, the package can not be imported.

s r = $ZF(-100,"/SHELL", "/usr/bin/python3.9","/trak/cnpubase/tc/webfiles/web/custom/CNPU/script/py/barcode/genslbarcodetest.py",keyStr,path)

import sys
import barcode
from barcode.writer import ImageWriter
spn=sys.argv[1]
name=sys.

Hi Community,

We're pleased to invite you to the upcoming webinar in Hebrew:

👉 Introducing InterSystems Cloud Services 👈

📅 Date & time: March 20th, 3:00 PM IDT

One can modify Interoperability External-Service Registry in Management Portal (Interoperability > Configure > External-Service Registry).

Can the registry be accessed and modified programmatically?

I don't find much documentation about the subject. Mainly https://docs.intersystems.com/irisforhealth20221/csp/docbook/DocBook.UI…

Hi,

I've just installed WebTerminal to my IRIS system (Linux SUSE).

I go url:

http://trak01:57772/terminal/

But it just times out

My management portal address is:

http://trak01:52773/csp/sys/UtilHome.csp

The port 57772 is not being listened to [ ss -l|grep LISTEN|grep 57772] 

The doco for WebTerminal says to use this port number in "1.1.3 Launching WebTerminal"

How can I fix this?

Is there some process that needs starting?

Is there further configuration eg. apache web server setup?

Thanks.

==========

This install was done from the *.xml (WebTerminal-v4.9.5.

Hi all,

As you know, it is very complicated to debug a Business Service Rest API because the object is created when the applications receive a request, so we cannot have the JobId that we can use to debug.

https://docs.intersystems.com/iris20211/csp/docbook/DocBook.UI.Page.cls…

So, I'm trying to get the JobId when the class is being created, write a trace in OnInit() method and write the JobId in a log info

Method OnInit() As %Status
{
	$$$LOGINFO("JobId: "_$JOB)
	hang 20 break
	Quit .

Intro

Most server-client communication on the web is based on a request and response structure. The client sends a request to the server and the server responds to this request. The WebSocket protocol provides a two-way channel of communication between a server and client, allowing servers to send messages to clients without first receiving a request. For more information on the WebSocket protocol and its implementation in InterSystems IRIS, see the links below.

If you're running IRIS in a mirrored configuration for HA in Azure, the question of providing a Mirror VIP (Virtual IP) becomes relevant. Virtual IP offers a way for downstream systems to interact with IRIS using one IP address. Even when a failover happens, downstream systems can reconnect to the same IP address and continue working.

The main issue, when deploying to Azure, is that an IRIS VIP has a requirement of IRIS being essentially a network admin, per the docs.

To get HA, IRIS mirror members must be deployed to different availability zones in one subnet (which is possible in Azure as subnets can span several zones). One of the solutions might be load balancers, but they, of course, cost extra, and you need to administrate them.

In this article, I would like to provide a way to configure a Mirror VIP without the using Load Balancers suggested in most other Azure reference architectures.

Every class on the server throws this same error when trying to run the debugger. I've already made sure I don't have the %SecureBreak role assigned which seems to typically fix this issue. Any advice on how to troubleshoot this would be greatly appreciated! 
Error is : <COMMAND>zDebugStub+40^%Debugger.System.1

Don’t know how to create an XML schema structure, there are no pre-defined categories in XML Schemas utility 

Hello,

I wrote a class that extends %Persistent and has only a few properties, one of which is Serial, a %SerialObject property (it needs to store any class that extends %SerialObject). When I assign a value to this property and call %Save on the class instance, I get this:

<METHOD DOES NOT EXIST>zSerialNewObject+1^HS.Local.CZ.OR.ROUTER.Service.Data.KeyProperty.1 *%New,%Library.SerialObjectr
HSROUTERcJ$^zSerialNewObject+1^HS.Local.CZ.OR.ROUTER.Service.Data.KeyProperty.1 +1L$^zSerialGetSwizzled+2^HS.Local.CZ.OR.ROUTER.Service.Data.KeyProperty.1 +3G$^%AddToSaveSet+5^HSLocal.CZ.OR.ROUTER.Service.

Hi All,

On February 8, 2024, we asked for input from the IRIS community regarding exam topics for our InterSystems IRIS Developer Professional exam. We will close the window for providing feedback on the exam topics on Friday, March 8, 2024. If you would like to have your say in what topics are covered on the exam, this is your last chance!

How can I access the survey?

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ How to Migrate a Mirror Configuration to Apache - Linux Unix

Hi Community,

Can anyone point me to the docs that show how to add automatic class documentation for the arguments used in a method call?   I can auto document the class, methods, properties etc. with the "///" but can't figure out how to get the nice argument documentation for the arguments used when calling a method.

Thanks in advance

InterSystems FAQ rubric

Global mappings can be registered using the system class Config.MapGlobals.

The method to globally map ^Sample.PersonD in a database SAMPLES other than the default database from the namespace USER is as follows (example executed in a terminal).

USER>zn "%SYS" 

%SYS>set ns="USER" 

%SYS>set glo="Sample.PersonD"
 
%SYS>set vals("Database")="SAMPLES"
 
%SYS>set st=##class (Config.MapGlobals).Create(ns,glo,.vals)

The third argument of the Create() method of the Config.MapGlobals class is passed by reference, so specify it by appending a period (.) to the variable name.

Can anyone give me a hint about this error?

I can compile sources following this approach, create a container and so on, but for example in specific commands to run test, I get the error.

ERROR #6063: Memory allocation for the Monitor failed

--

stats:

CONTAINER ID   CPU %     MEM USAGE / LIMIT     MEM %     NET I/O                  BLOCK I/O            PIDS
29efa407abc9   3.46%     2.094GiB / 77.32GiB      2.71%       40.1MB / 2.1MB   416MB / 4.

I save / compile a class and instantly run a debug.  No issue

A few seconds later, try to run the same debug and get presented with either: 

1) Target Source is not compiled (Open launch json) dialog box

                                                    OR

2) The version of the file on the server is newer.

In the meantime I have made no edits to the VS Code window at all. 

If I pull a compare in response to #2 above, I am presented with a bunch of extent info built into the storage definition similar to the lines below.

hi,

I am trying to connect to an external MySQL database from IRIS 2023.1 platform. Does anyone know the right adapter to use? Where do you set up the DSN name?

Thank you in advance.

Sheetal