#InterSystems IRIS

• 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.

sr$ZF

fromdeftestEan(str)

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

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%Library.SerialObjectr

I have not modified the compiled code manually. I have tried deleting the Storage definition for the class and recompiling. Did not work. I have tried creating an entirely new class, copying the properties in and compiling, that didn't work either.

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"

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.

In addition to using the Config.MapGlobals class, you can also define using the installation manifest class.

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

I know we can use Do ^DBREST and EXTSELCT ^DBREST or EXTALL ^DBREST to recover the database. But now I just want to use Do ^DBREST to achieve database recovery through this method.

Any help would be greatly appreciated

In this paragraph of the article, here is an example of different records to explain how to fill in DirName、Globals and RestAll, but i don't know what is DUA1:[TEST3] ? This doesn't look much like dirname, like this /cachesys/mgr/test/. Can someone explain it? I would greatly appreciate it !

Hello everyone,

I'm looking for a way to retrieve the result of the ZW command in a global, is this possible?

I want to address the nasty problems about reading a flat text in ASCII, UTF*
explicitly excluding HTML, EBCDIC, and other encoding.
According to Wikipedia there are at least 8 variations of control characters.

• CR+LF is typical for Windows
• LF is typical for the Linux/UNIX world
• CR is Mac's favorite

As you can deduct from the names the inspiration comes from mechanical typewriters.

In IRIS* similar as in Caché or Ensemble or .

There is an interesting new feature in the recently announced 2024.1 preview, JSON_TABLE. JSON_TABLE is one of a family of functions introduced by the 2016 version of the SQL Standard (ISO Standard, published in early 2017). It allows for JSON values to be mapped to columns and queried using SQL. JSON_TABLE is valid in the FROM clause of some SQL statements.

The syntax of JSON_TABLE is quite large, allowing for exceptional conditions where the provided JSON values don't match expectations, nested structures and so on.

The basic syntax is quite straightforward.