#InterSystems IRIS

19 Followers · 5.5K Posts

InterSystems IRIS is a Complete Data Platform
InterSystems IRIS gives you everything you need to capture, share, understand, and act upon your organization’s most valuable asset – your data.
As a complete platform, InterSystems IRIS eliminates the need to integrate multiple development technologies. Applications require less code, fewer system resources, and less maintenance.

Question Phillip Wu · Jan 10, 2024

Hi,

I have this IRIS server, NODE1. NODE1 is a Linux server running IRIS.

To connect to IRIS on this server I:

From my PC ssh (via putty) to NODE1

From the putty session, I, "iris session <iris instance>"

I was hoping to use iristerm on my PC:

I put NODE1 into IRIS Server Manager

From my PC, I, "iristerm /server=NODE1"

I get this error message:

"TCP connect() failed"
How to get this to work?

I understand that iristerm tries to connect to the server first using telnet then connects to the IRIS running on ths server. Correct?
For security purposes, ssh only is supported in connecting to

6
0 495
InterSystems Official Fabiano Sanches · Jan 17, 2024

The 2023.1.3 extended maintenance releases of InterSystems IRISInterSystems IRIS for Health, and HealthShare Health Connect is now available. It provides bug fixes for any of the previous 2023.1.x releases.

You can find the detailed change lists / upgrade checklists on these pages:

How to get the software

The software is available as both classic installation packages and container images.  For the complete list of available installers and container images, please refer to the Supported Platforms webpage.

Fu

0
0 230
Question Mathew Rimmington · Jan 16, 2024

When using VS Code to develop with Object Script, the Server Credentials prompt for connecting to the IRIS instance is happy accept a blank for UnknownUser. See screen shot:

From here VS Code happily connects to the IRIS instance using unauthenticated access. But the standard VS Code "Go To Definition" appears to do nothing. Whilst looking through the documentation I found that in the Language Server extension, there is a setting to output verbose trace details. With verbose output switched on, trying the "go to definition" of some code, the output shows this:

"[Warn  - 12:16:39 PM] Cannot

5
0 670
Question Heloisa Paiva · Jan 16, 2024

When I do $TRACE("message") I can see the message on the message viewer. However, I don't know where to find messages generated from $$$sysTRACE, and I haven't found anything about it in the documentation.

Do you know where I can find it? 

6
0 379
Article Daniel Aguilar · Jan 17, 2024 7m read

        

Hello, community!

Ihave been tinkering around with Flutter lately and, as a result, came up with some apps that can use Firebase as a database. When I realized there was an available Python library, I felt the urge to create something for InterSystems IRIS that would communicate with the Firebase RealTime Database and perform CRUD operations. Later, I stumbled upon the following idea from Evgeny in the portal:

https://ideas.intersystems.com/ideas/DP-I-146 

That is when  I got down to work!


 

Are you curious to see my findings? Then buckle up because we’re ab







































0
1 453
Article Anssi Kauppi · Jun 30, 2020 3m read
Many organisations implement centralised log management systems to separate and centralise the log data in order to e.g. automate threat detection (and response) and to comply with regulatory requirements. The primary systems of interest are the various user facing applications, but increasingly also other kinds of systems including integration platforms.

What comes to the data platform (not the user facing application) most of the the events of interest/required are available as predefined system audit events in audit log - out of the box. They just need to be enabled. The rest are generally

2
2 520
InterSystems Official Benjamin De Boe · Sep 21, 2023

InterSystems has decided to stop further development of the InterSystems IRIS Natural Language Processing, formerly known as iKnow, technology and label it as deprecated as of the 2023.3 release of InterSystems IRIS. InterSystems will continue to support existing customers using the technology, but does not recommend starting new development projects outside of the core text exploration use cases it was originally designed for. Other use cases involving natural language are increasingly well-served using novel techniques based on Large Language Models, an area InterSystems is also investigatin

7
0 913
Question Virat Sharma · Jan 11, 2024

Hello everyone,

I am new to Deepsee (BI intelligence) concepts in IRIS. I am looking for a solution of below question

Question: We have a server where we are currently storing archive PDF reports of our application.

We want to add and view these archive reports (PDF format only) in dashboards. Is there any way we can do this? Or any article which can help us performing this task.

Thanks in advance!!

1
0 203
Question Scott Roth · Jan 13, 2024

I am trying to work on a ZMIRROR that will execute a shell script to failover our VIP at the hardware level when NotifyBecomePrimary occurs.

ZMIRROR ; Custom logic for specific mirroring eventsq;
NotifyBecomePrimary() PUBLIC {
 #;This procedure is called as a notification when this system becomes Primary.
 #;It does not return any value.
 #; invoke the command to select this host for running the crontabtry {
	Set cmd = "/usr/local/sbin/failover-intengtest-vip_SR"d$ZF(-100,"/SHELL /LOGCMD /STDOUT=/archive/logs/failover-intengtest-vip.log""",cmd)
    }
 catch e {
     d
4
0 261
Announcement Olga Zavrazhnova · Jan 15, 2024

Hi Developers,
We will be hosting the first in-person meetup in 2024 in Boston on January 24. Join us to explore the latest trends, tools, and features for innovating with health data.

RSVP here
Presentations:

"Integrate third-party Clinical Decision Support services into the EHR with CDS Hooks" - by Frank Pandolfe, Clinical Product Manager, InterSystems.
"Connecting GenAi into Clinical Workflows" - by Nicholai Mitchko, Manager, Solution Partner Sales Engineering, InterSystems

 

0
0 202
Question Pierre LaFay · Dec 29, 2023

Hi,

Our application needs to create system users from a request form.

To use Security classes, it is necessary to have rights to use the %SYS namespace, which is not the case for users who validate requests.

It is not desirable for these users to have this role permanently, so I proceeded as follows:

I created a facade class for the Security.Users, Security.Roles, Security.Resources classes which allows me to log in with an authorized user on the NS %SYS

Here is an example method:

ClassMethod Modify(name As%String, ByRef properties As%String) As%Status
{
    set who = $USERNAME
7
0 350
Article Nikolay Solovyev · Jun 24, 2020 2m read

ZPM is a package manager designed for convenient deployment of applications and modules on the IRIS platform.

Module developers, in order for their module to be installed using ZPM, need to follow a series of simple steps.

  • Write module code
  • Create a module.xml file that contains the meta description of the module
  • Using the test registry, publish the module, verify that it is published
  • Install the module from the test registry
  • Publish the module. To publish in the public registry pm.community.intersystems.com, you need to publish the module in https://openexchange.intersystems.com, specifying
2
2 633
Question Anthony Ennis · Jan 3, 2024

I need to verify that certain .m files have been compiled and inserted into the VA mumps database.  I need to do it on a schedule and thus I want to automate it.  Because of the automation I'd prefer not to use the IRIS web app. So if there were a similar CLI version that would be great. I see there is something called /usr/bin/iris but this seems to be a maintenance tool, not a IRIS.DAT querying tool.  I'd love to be wrong about that.

Please forgive my lack of proper nomenclature, clearly I'm a n00b.

6
0 384
Question Scott Roth · Jan 11, 2024

I am trying to write a ZMIRROR routine that makes a shell script call using $ZF

Set cmd = "/usr/local/sbin/failover-intengtest-vip"Do$ZF(-100,"/ASYNC /SHELL",cmd)

The script I am calling is returning an output to the screen, how do I get around this using $ZF without having to rewrite the scripts?

Thanks

Scott

2
1 251
Article Megumi Kakechi · Jan 11, 2024 2m read

InterSystems FAQ rubric

This error occurs when an instance of the class is already open at compile time.

There are two ways to deal with this issue:

  1. Terminate the process or application that has the instance open
  2. Compile options in the studio build menu: Check the compile flag “Compile classes in use” and compile.  

If you want to determine which process is using the class, try the sample routine below.

/// Test.mac
search(classname) public {
    Set pid=""
    Set pid=$order(^$Job(pid))
    While pid'="" {
        Do checkVars(pid,classname)
        Set pid=$Order(^$Job(pid
1
0 221
InterSystems Official Benjamin De Boe · Jan 11, 2024

InterSystems is pleased to announce the General Availability of InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML, two foundational services for developing cloud-native solutions powered by the proven, enterprise-class performance and reliability of InterSystems IRIS technology. 

InterSystems IRIS Cloud SQL is a fully managed cloud service that brings the power of InterSystems IRIS relational database capabilities used by thousands of enterprise customers to a broad audience of application developers and data professionals. InterSystems IRIS Cloud IntegratedML is an option

2
0 398
Announcement Larry Finlayson · Jan 10, 2024

Developing with InterSystems Objects and SQL – IN PERSON (Cambridge office) February 12-16, 2024   9:00am-5:00pm US-Eastern Time (EST)

  • This 5-day course teaches programmers how to use the tools and techniques within the InterSystems development environment to build high-performance transactional applications. Learners build a complex application using an IDE, object-oriented design, SQL and unit testing.
  • This course is applicable for users of InterSystems IRIS Data Platform and Caché.
  • Many benefits are offered by being physically in the classroom with our instructors for a more personaliz
0
0 158
Question Lewis Houlden · Jun 30, 2023

Hello

We are in the process of upgrading to 2023.1 for InterSystems Health Connect, and the Business Rule Engine editor is very difficult to use compared to 2022.1. It's difficult to scan over the rules as it all looks the same style with barely any distinction between rules, constraints, conditions, whens etc. There's also tonnes of whitespace, and searching on the page is hit and miss (using Ctrl + F) . I can see the previous editor is still available when you modify the URL, but I'm wondering if we can set it to be the default editor, and if this is something supported.

Thanks

Lewis

7
1 662
Article Muhammad Waseem · Jan 9, 2024 9m read

  Hi, Community!

Since this article is an overview of Flask Login, let's begin with Flask Introduction!

What is Flask?

In the realm of web development, Python has emerged as a formidable force, offering its versatility and robustness to create dynamic and scalable applications. For that reason, tools and services compatible with this language are in demand these days. Flask is a lightweight and easy-to-use web framework for Python. It stands out as a lightweight and user-friendly option. Its simplicity and flexibility have made it a popular choice for developers, particularly for creating smaller-scale applications. It is based on the Werkzeug toolkit and provides a simple but powerful API for building web applications. 
Unlike its full-stack counterparts, Flask provides a core set of features, focusing on URL routing, template rendering, and request handling. This minimalist approach makes Flask lightweight and easy to learn, allowing developers to build web applications quickly and without the burden of unnecessary complexity.

0
1 1949
Question Sylvain Guilbaud · Aug 23, 2023

Is it planned that LOAD DATA takes into account several DATE/DATETIME formats with, for example, a parameter indicating the format used in the source data?

example :

LOAD DATA .../...
USING
{
  "from": {
    "file": {
       "dateformat": "DD/MM/YYYY"
    }
  }
}
3
0 261
Question liu yanjie · Jan 7, 2024

Hi all,
Does anyone have experience with obtaining logs from Caché databases and parsing them now? Please leave me a message.

I ask because my project involves some hospitals that used Caché when creating databases over 10 years ago. Currently, we cannot replace the database, but we need to check and parse the database logs from the Caché.

Thanks.

12
0 290
Article Evgeny Shvarov · Apr 4, 2023 2m read

Hi developers!

As you know InterSystems IRIS besides globals, object, document and XML data-models also support relational where SQL is expected as a language to deal with the data.

And as in other relational DBMS InterSystems IRIS has its own dialect.

I start this post to support an SQL cheatsheet and invite you to share your favorites - I'll update the content upon incoming comments.

Here we go!

26
7 1644
Article Sylvain Guilbaud · Jan 8, 2024 3m read

Hello Community,

When using an SQL type Business Service, it may happen that we need to replay certain rows from the source table.

Let's take as an example the Business Service "from customer SQL" using the generic class EnsLib.SQL.Service.GenericService

Different cases arise, depending on the settings used on this Business Service.

First case :

If the Business Service only uses a KeyFieldName

In this case, to reprocess IDs 123, 456 and 789, it will be enough to delete them from the global ^Ens.AppData for the Business Service concerned on the "adaptor.sqlrow" reference:

kill

0
1 445
Article Luis Angel Pérez Ramos · Dec 29, 2023 6m read

It seems like yesterday when we did a small project in Java to test the performance of IRIS, PostgreSQL and MySQL (you can review the article we wrote back in June at the end of this article). If you remember, IRIS was superior to PostgreSQL and clearly superior to MySQL in insertions, with no big difference in queries.

Well, shortly after @Dmitry Maslennikov told me "Why don't you test it from a Python project?" Well, here is the Python version of the tests we previously performed using the JDBC connections.

First of all, let you know that I am not an expert in Python, so if you see anythin

6
3 1003
Article Evgeniy Potapov · Dec 19, 2023 6m read

In today's digital age, effective data management and accurate information analysis are becoming essential for successful enterprise operations. InterSystems IRIS Data Platform offers two critical tools, ARCHITECT and ANALYZER, developed to deliver convenient data management.

ANALYZER is a powerful tool available within the InterSystems IRIS platform to provide extensive data analysis and visualization capabilities. This tool allows users to create summary tables and charts to analyze data. It also lets you perform detailed studies and analyses based on available data.

One of the most signif

C:\Users\kc\Documents\ShareX\Screenshots\2023-10\D7zPhs3vK3.png

2
1 519
Article Megumi Kakechi · Jan 4, 2024 1m read

InterSystems FAQ rubric

If a relationship is set and there is a large number of n in a 1:n ratio, a large amount of memory may be consumed due to sequential processing of the relationship.

After referencing a many-sided object in a program and internally swizzling it, simply releasing the variable containing the OREF (deleting it, setting another value, etc.) will not free the many-sided object and the relationship object. This is the cause.

To free them completely from memory, you need to explicitly free them by freeing the OREF variable and executing the Relationship object's %UnSwizzleAt

0
0 342