#InterSystems IRIS for Health

Hi everyone!

Just wanted to share here a quick post about my project for the Grand Prix :)

Hello everyone,

I want to restore a database from an external backup with the journal files.

The manual says I should (in short):

1. Stop journaling with ^JRNSTOP
2. Restore the database file IRIS.DAT
3. Run the journal restore utility with ^JRNRESTO
4. Restart journaling ^JRNSTART

Since I want to restore one database only step 1 would disable journaling for the whole instance, not only for the database to be restored. As I understand, it would be impossible to restore a different database if there occurs a problem while journaling is disabled during the recovery process?

I have successfully created REST service classes on my local IRIS server following this book: Using the /api/mgmnt/ Service | Creating REST Services | InterSystems IRIS Data Platform 2021.2

I am now 1) trying to edit impl.cls in VS Code and 2) export it to my local repo so I can push to the remote repo.

When I click on my project in VS Code and 'Add to project' and choose the new package, spec.cls and impl.cls, I get the following error:

ERROR #5540: SQLCODE: -114 Message: Unable to acquire lock for INSERT of child row for parent table '%Studio.Project' with parent id = 'Default_project'

I have a project that needs to get DSTU2 resources ultimately to CSV files.  My thought was if I could get there Resources to R4 I could use the FHIR SQL builder to help map the data.  Anyone have ideas?  Maybe DSTU2 to SDA to R4... 

Hi:

Had an issue after upgrading to 2021.1 where search bar for interoability will bring up "INVALID ACTION". 

On upgrading to 2022.1 this still occurs. 

It did not occur on another environement that was upgraded from 2017.2 straight to 2022.1 

Is there any solution? Loads up SYS in url rather than customnamespacename

Issue is the url for instance brings through ip/csp/sys/EnsPortal.DTLEditor.zen?$NAMESPACE=X 

ip/csp/healthshare/customnamespace/EnsPortal.DTLEditor.zen?$NAMESPACE=X

I encountered this before and forget if there was a solution for this

We have a downstream application that cannot accept more than 500 messages at a time. They want to restrict the number of messages being sent to them at a time.

Hey Developers,

Learn the basics of HL7® V2 message management in InterSystems IRIS for Health™:

⏯ Introduction to HL7 V2 Integrations in InterSystems IRIS for Health

How do I access items and their settings of production by using Objectscript? I have already tried making SQL queries to Ens_Config.Production table and using methods in Ens.Director and EnsPortal.Utils classes but I just can't get a hang of it.

Good morning. Perhaps someone can tell me if this IRIS health communit version (IRISHealth_Community-2022.1.0.209.0-lnxubuntu2004x64) is supposed

to work in an Ubuntu 20.04 LTS installation in an Oracle Virtual Box .

I am trying to install different versions on Ubuntu . I tried with the 18 version. No luck. Than I've tried with the 20.04 version. No luck either.

The error I am having now is below

///////////////////////// error message from the install ////////////////////////////////

home/epic/epicinstall/IRISHealth_Community-2022.1.0.209.0-lnxubuntu2004x64# ./irisinstall

This is the third in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready.  Many updates, fixes and enhancements have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. Please share your feedback through the Developer Community so we can build a better product together.

I am reaching out to find out if anyone has come across a similar dilemma. 

In my current role, I have been asked around the best way to design some patient labels for a client.

 I primarily would stick to what I know and veered towards designing the label in ZPL and then creating a Abstract Class to call the ZPL code, however I have been asked why not to design via JReport. The patient labels will be processed via thermal ink printers primarily Zebras, I am wondering if anyone out there has come across this or  would recommend to stick to what you know. 

LS, Is it possible to create User Accounts, and assign specific Roles to them, from objectscript?

Hello, I'm using the InterSystems IRIS connector for Power BI to connect to our Iris for Health database, using Direct Query.

I have a column [Company] which is datatype bigint, and as far as I can tell the data is 2 for most (or all?) records.

When I bring the data into Power BI, every row shows as NULL (I think it should be 2 for most)

= Table.SelectRows(Table, each [Company] <> null and [Company] <> "")

-- removes all rows

so instead I use

= Table.SelectRows(Table, each [Company] = 2)

-- the nulls magically become 2s (other numbers I've tried lead to an empty table)

Developer Preview releases are now available for the 2022.2 version of InterSystems IRIS, IRIS for Health, and HealthShare Health Connect.

Hi Community,

Just thought I'd let you know that you can still get a LifeStraw water bottle for completing a Gartner Peer Insights survey. With a built-in filter that removes bacteria, parasites, and microplastics, this water bottle is especially useful for hikers. Plus Gartner will give you three months access to its Peer Insights Plus, "an exclusive service that aims to help tech professionals stay current on technology trends and excel in evaluating software/services."

I did a google search for 'Grafana' and 'IRIS Health'.

This gave these candidates:

https://github.com/caretdev/grafana-intersystems-datasource
https://community.intersystems.com/post/using-grafana-directly-iris
https://grafana.com/grafana/dashboards/14869

Does anyone know which one is 'best'?
If you have used any of these, do you have any detailed instructions on how to install?
Most of these packages assume you know how to install and run them and so are very light on how to install.

I'm using Grafana on a Windows platform (without the use of docker)

There are many ways to generate excel files using Intersystems, some of them are ZEN reports, IRIS reports ( Logi reports or formally known as JReports), or we can use third party Java libraries, the possibilities are almost endless.

But, what if you want to create a simple spreadsheet with only Caché ObjectScript? (no third party applications)

Hello everybody!

I’m having some odd issues with IRIS for health community edition and creating a new namespace.

Versions 2021, 2022.1 & .2 for Windows and Ubuntu allow me to create a new namespaces and the databases for it.

As you can see above, I’ve enabled the namespace for interoperability productions.

I’ve run this creation process with not copying the mappings, copying everything from user, and so on, with out a difference to the end result.

Now after this is done, for some reason, I run in to the issue below,

Is there any way to dynamically generate the output filename for a schedule task?  For example when running a legacy code task every hour , is there anyway to specify the output file name to be appended with time stamp or some incrementing number to avoid overwriting ? 

Hi,
Is there a nice cheat sheet for the IRIS command line (terminal) application?

I haver read $Query and $Order but still not getting the code that i am looking to work correctly. 

I have a global like 

^TestGlobal("Not Configured","Value 1")=""

^TestGlobal("Not Configured","Value 2")=""

I've been playing with IntegratedML and have created a model and trained the model.  When I try to use PREDICT or PROBABILITY statements in an SQL query, I get the following error:

[SQLCODE: <-400>:<Fatal error occurred>]

  [%msg: <PREDICT execution error: ERROR #5002: ObjectScript error: <OBJECT DISPATCH>%LoadModel+31^%ML.AutoML.TrainedModel.1 *<class 'AttributeError'>: 'str' object has no attribute 'decode' - >]

Here's an example of the sequence of steps I've followed that lead to the error:

CREATE MODEL MyModel PREDICTING (IsError BOOLEAN) FROM Example3.ModelTable

Newbie stuck again, hoping this won't be as bad as I'm thinking. In my DTL Editor I've got 

Source.Appointments.(k1).Date = 07/05/2022

Source.Appointments.(k1).StartTime = 14:30

Source.Appointments.(k1).Duration = 30

Looking to Formation a target StartTime and End Time based on the above values (and known time Zone) so they are formatted in this format 2022-07-05T02:30:00Z005:00" as the end goal right now I've got it to where I can get this for a start time as I really want to figure out the duration part before I figure out the format above: 07/05/2022 14:30 

How would you like to be able to access the Web Terminal directly from your VSCode?

Hi developers. I often miss the ZPM program on a clean system. Nothing complicated? Take and install. And in one line? Especially in a docker container. There is a solution. I'm very happy with it;) Maybe the line can be shortened?

Developer Preview releases are now available for the 2022.2 version of InterSystems IRIS, IRIS for Health, and HealthShare Health Connect.

 This is the first in a series of releases that are part of the developer preview program. Future preview releases are expected to be updated biweekly and we will add features as they are ready.  This program allows us to get feedback on capabilities and enhancements as they're available.  You'll see below a list of enhancements that are targeted for 2022.2.  Some these are not included in the first developer preview.  Look for those over the coming weeks.

Hi There,

I'm fairly new to ObjectScript/Ensemble and I'm sure I may be fundamentally misunderstanding how the %JSONImport/%JSONExport and XDATA mapping work and I was hoping you good folks could help me out.  I'm essentially trying to create an object that I can use to translate from one JSON schema to another. 

First my class:

Is it possible to mirror the same database on Iris and an older Ensemble instance?

Specifically to try a zero downtime upgrade

Hello,

I am wondering if anyone can help me with an issue we are facing. We are trying to add a parent-child relationship between 2 tables in the database that already contain data. We are able to add the new relationship property to the required data classes, and set the desired cardinality. We have also included code that will add the relationship using the Insert() method to new data that comes in.

The problem we have is how do we add the relationship to data that already exists in the database?

Couldn't see this on the community, not sure why...

UK & Ireland Summit 2022
Leading Through Innovation

18-19 October 2022 – The VOX, NEC, Birmingham

Join us for a true community event, once again bringing together InterSystems customers and partners – to learn, inspire, and share innovation challenges with each other. To register, please complete the form below.