📜 Santa Tecla, verse 8: "Hover your mouse over the screen, and the sea of data will open a path before you!!"

Hello community, first of all, apologies if anyone was offended by the blasphemy 😔

Have you ever thought it would be interesting to have the source code separated from the database data? Perhaps you'd like to be able to back up your code without copying gigabytes of client data.

Below, I'll explain the steps to separate your sea formed by the source code and data into two different databases within a namespace.

Hi Community!

Our 💡 3rd InterSystems Ideas Contest has come to an end. As a result, there are 🔥 30 new ideas! They all focus on improving InterSystems IRIS and related products and services, highlighting tangible benefits for developers once the ideas are implemented.

And now we announce the winners...

Good afternoon,

I'm trying to start an instance of the Community Edition with Docker and I get the following error.

I tried downloading the object-script template directly from OpenExchange, but one of these two things always happens:

1 - It gets stuck starting up forever

We have a stand-alone web platform (readysetrecover.com) that helps people prepare for surgery focusing on the non-clinical – holistic and logistic aspects (stress reduction via meditation, sleep etc. as well as things like setting up the house, coordinating help from others etc).

As of October 15, 2024, support for Caché & Ensemble on MacOS will be Deprecated.

Caché & Ensemble 2018.1.9 will continue to be supported, however there will be no further maintenance releases for MacOS. This means Caché & Ensemble 2018.1.9 will be the final version of these products on MacOS. 

As a reminder, maintenance releases for Caché and Ensemble on the other supported platforms will come to an end on March 31, 2027.  More details on that can be found in last year’s announcement.

We are constantly running into issues where there are billions of Orphaned messages in our system that cause problems, and we have to manually run a cleanup to fix performance issues.

 In the following article about orphaned messages... https://community.intersystems.com/post/ensemble-orphaned-messages it mentions either programmatically eliminating the Orphaned messages or using a Utility like Demo.Util.CleanupSet in ENSDEMO.

I have had it explained to me is basically all messages have to go somewhere, if they aren't then it creates orphaned messages. 

Could any one tell me, how the index  works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001       ABC            20

002       AAA            21

003       ABB            23

004       BBB           20

005       BDF           24

006        EEE          22

Hi Community!

How can you create a balanced approach to using Generative AI? Get help from InterSystems experts in the latest video from Learning Services:

⚖ Weighing the Benefits and Risks of Generative AI

I have been using embedded python for more than 2 years now on a daily basis. May be it's time to share some feedback about this journey.

Why write this feedback? Because, I guess, I'm like most of the people here, an ObjectScript developer, and I think that the community would benefit from this feedback and could better understand the pros & cons of chosing embedded python for developing stuff in IRIS. And also avoid some pitfalls.

• Feedback : Using embedded python daily for 2 years
• Introduction
• Starting with Python
  • Python is not ObjectScript
    • Pep8
    • Modules
    • Dunders
  • Conclusion
• Embedded Python
  • What is Embedded Python ?
  • How to use Embedded Python ?
  • How I use Embedded Python
    • Use Python libraries and code as they were ObjectScript classes
      • With the language tag
      • Without the language tag
      • Conclusion
    • Use a python first approach
      • Example : iris-fhir-python-strategy
      • Remarks
      • Where to find the code
        • How to implement a Strategy
        • Implementation of InteractionsStrategy
        • Implementation of Interactions
        • Interactions in Python
        • Implementation of the abstract python class
      • Too long, do a summary

Is there a way to capture the SQL command that was sent to Cache ? I need to know how to do this. Any help would be appreciated. It is from an external application using JDBC or OBDC. Thanks

Hello Community

I'm unable to view the  HL7 message field in the Business rules of the latest version of IRIS while tying HL7. syntax

ex: HL7.{PID:PatientName().givenname}

Latest Rule editor

Old Rule editor

Has anyone had experience migrating source control projects from Subversion to Github, particularly when transitioning from InterSystems Studio to VSCode?

We have a requirement where in certain data from IRIS in almost real time has to join with SQL tables and we are trying to avoid linked servers.

Is there a way to achieve this without having to go through ODBC? 

Hi

I get the following error when I am trying to create a linked server connection via MS OLE DB Provider for ODBC Drivers in MS SQL Server Management Studio. The message I get is:

The OLE DB provider "MSDASQL" for linked server "IRIS" reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS". (Framework Microsoft SqlClient Data Provider)

I have setup the InterSystems ODBC setting on the server. Have enabled a number SPN settings but still getting this error

The full error message is :

InterSystems Reports version 24.1 is now available from the InterSystems Software Distribution site in the Components section.  The software is labeled InterSystems Reports Designer and InterSystems Reports Server and is available for Mac OSX, Windows and Linux operating systems.  

This new release brings along some great enhancements from our partner, insightsoftware.  InterSystems Reports 24.1 is powered by Logi Report Version 24.1SP2 and includes:

Using the FHIR DEMO, I have pieced together how to make a FHIR Request using OAuth against an External FHIR Repository. When I execute the Patient search (HS.FHIRServer.Interop.Request), I get a HS.FHIRServer.Interop.Response that has a Quick Stream ID, which I then use to convert the Quick Stream to a JSON Dynamic Object. if I do a trace on the Raw JSON Object, I am able to pull out single elements, however I want to pull the raw JSON into a defined Class Structure. 

I tried using fromDao(dao As %DynamicAbstractObject) As <HS.FHIRModel.R4 subclass> outlined within Working with FHIR Data

Hi Community,

Watch this video to learn about the PainChek artificial intelligence technology, which assesses patient pain at the hospital bedside, leverages InterSystems IRIS interoperability to connect to third-party electronic medical record systems:

⏯ Using Artificial Intelligence / Machine Learning for Pain Assessment in a Clinical Environment @ Global Summit 2023

We recently moved from using the Private Web Server, to using an Apache/Web Gateway setup and moved towards using the built in LDAP functionality within IRIS. Since then, we have 1 user that uses VSCode (/api/atelier) heavily that continues to have issues signing into IRIS through VS Code and the /api/atelier extension.

I am trying to troubleshoot two issues..

• User having login failures with correct password. 

Has anyone had experience using Azure EventHub with IRIS?

I'm working with isc.rest and am going through the tutorial right now. My project directory exists on my IRIS server. When I try to create a module.xml file in the root package, I get a #16006 error. I see that there is a "generate" command for zpm that should create a module.xml for me on my local filesystem. How can I create this module.xml in the same folder that holds my code living on the IRIS server?

HealthShare Patient Index – Virtual July 30-August 1, 2024   9:00am-5:00pm US-Eastern Time (EDT)

Hey InterSystems-Community,

is it possible to get these Property Descriptions via SQL Query for example in the Management Portal?

Best regards,

Florian

Description

This is a template for an Django application that can be deployed in IRIS as an native Web Application.

Installation

1. Clone the repository
2. Create a virtual environment
3. Install the requirements
4. Run the docker-compose file

git clone
cd iris-django-template
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
docker-compose up

Usage

The base URL is http://localhost:53795/django/.

Endpoints

We're looking to create a quick and simple test to see if all firewalls are open on 1972 between a linux based web server VM and a VM running InterSystems IRIS.  Does anyone have any ideas for a quick command that can be run from UNIX console that will provide confirmation that traffic is able to get to 1972 on an IRIS machine?

BTW - I don't think it makes any difference but the IRIS machine is running Windows

Hi,

I'm very new to InterSystems  Health Connect so may be doing something silly...

I'm trying to link to an Oracle DB view using the Link Table Wizard in the Management Portal. The wizard finds the view, but when I select it and click the 'next' button I get an error on the 'Select Columns' screen: 'ERROR #5534: Columns error' (and no columns show in the wizard). I've tried on several views and tables in the same DB but keep hitting the same error.

I have previously successfully mapped a view and table from the same DB and am not sure what I am doing differently. Any suggestions appreciated!

I have an HL7 message that contains NTE segment with line break inside.

when I try to transform it (with DTL) it stops reading the message after the line break inside the NTE because it treat that as "End of Message".

Is there a way to solve this in the DTL or I need to run a pre process on the HL7 message that identify the line break inside the NTE segments and replace it with an escape char?

Bonjour,

Depuis ce matin j'arrive pas à compiler ou lancer mes programmes qui tourne en local sur docker avec l'image : intersystemsdc/irishealth-community:2024.1-zpm

J'ai toujours cette erreur sur le terminal ou le portal de management : request to http://localhost:52773/api/atelier/ failed, reason: socket hang up

Dans mes logs docker aussi j'ai des erreurs en conitnu , voici un extrait ...

Dans le fichier message.log j'ai aussi des erreurs et voici un extrait 

L'erreur semble indiguer une licence et un nombre de core limite ....

Context

The Web Server Gateway Interface (WSGI) is a simple calling convention for web servers to forward requests to web applications or frameworks written in the Python programming language. WSGI is a Python standard described in detail in PEP 3333.

🤔 Ok, great definition and what the point with iris ?

IRIS 2024.2+ has a new feature that allows you to run WSGI applications directly on IRIS. This feature is a great way to integrate IRIS with other Python frameworks and libraries.

I am trying to extract GMHeap, Locksiz values form Config.config using python (imported irisnative for Python) but the below python progam is not returning any value. Please suggest if i am doing any mistake - 

Also, plese suggest how i can set values for GMHeap and Locksiz to a different value through Python.

import irisnative

hostname = "127.0.0.1"
port = 1972
namespace = "%SYS" #change the namespace based on situation
username = "_SYSTEM"
password = "xxxxxxxx"
connection = irisnative.createConnection(hostname, port, namespace, username, password)
dbnative = irisnative.createIris(connection)

Hi Community,

It's time for the new batch of #KeyQuestions from the previous month.

Here are the Key Questions of June chosen by InterSystems Experts within all Communities: