I am trying to do a INSERT OR UPDATE SQL query, but the query always inserts new rows to table. Is it how I defined the table or am I mising something in the query?

table defines as,

Class AH.AHCOMMON.Tables.HospDepartmentData Extends %Persistent [ Language = objectscript ]
{

Property Tablespace As %Library.String(MAXLEN = 50) [ SqlColumnNumber = 2 ];

Property DepartmentId As %Library.String(MAXLEN = 50) [ SqlColumnNumber = 3 ];

Property TimezoneName As %Library.String(MAXLEN = 100) [ SqlColumnNumber = 4 ];

Property PatientDepartmentName As %Library.String(MAXLEN = 100) [ SqlColumnNumber = 5 ];

Prope

Last Friday November 17 suddenly ran into an error where ZPM would issue an error saying:

ERROR! Object open failed because 'Name' key value of 'xx' was not found

I googled but found no specific help. Step by step I was able to conclude that:

1. This is the error message for error 5770, also known as $$$KeyValueNotFoundOpen.

2. In objectscript, this error can be raised by calls to NameOpen, where 'Name' is the first quoted part in the error message.

3. The error status is raised when there is a call to ##class(yy.zz).NameOpen("xx", , .sc) where yy.zz inherits from %Persistent and has an index

Does anyone have any trick to get the raw text out whenever you run a DTL test in the DTL editor? 

If not is there any plans to add this to a later version?It would help certain workflows where you just want to run a transform in the DTL to then copy and paste the message to send into a test on the operation.I am aware you can set up a file and rule to then go out to a file or operation but seems like additional workflows when there are scenarios you just want a quick copy of the message text after doing transform.

Hello,

I am trying to use the %ToJSON method on my dynamic object, calling it with a "DO" and not passing in outstrm parameter.

We are trying to avoid MAXSTRING errors that we get with some of our abnormally large messages.  In order to do this, I am trying to update my code to not call the socket's "Write" method after converting the dynamic object to a JSON string using the %ToString method's output.  Per the documentation on the %ToJSON method:
    If outstrm is not specified and the method is called via DO, the JSON string is written to the current output device

The previous code (extending

We are running Batch job in scheduled task and the messages are picking in single session and it is not easy to trace the record.

I used the Set ..%SessionId= "" at before sending the message to BP but I see the session Id is '1' created for each message.

Is there anyother way to create new session for each message sending to BP?

Thanks,

Hello, I tried to read a XML list from a web service into a response class by creating a custom collection subclass as described in this documentation page

Here's the XML file I am trying to read:

<Suppliers><Supplier><row>1</row></Supplier><Supplier><row>2</row></Supplier></Suppliers>

And the different classes I defined to project the XML into:

Class App.Messages.GetSuppliersResponse Extends (%Persistent, Ens.Response)
{
Property Suppliers As App.Objects.Suppliers;

Method Deserialize(stream as%Stream.Object) as%Status
{
    set reader = ##cla

InterSystems FAQ rubric

If you need to migrate your server for some reason, you can reduce the setup work by copying configuration information from the pre-migration environment to the post-migration environment.

The following setting information can be migrated.

• iris.cpf
• SQL gateway settings
• web gateway settings *Note 1
• user-created routines etc. stored in the IRISSYS database *Note 2
• security settings
• task settings

Note 1: If a password has been set, only the password needs to be reset manually.
Note 2: Preferred connection server settings such as ^%ZSTART, ^ZMIRROR routines, etc.

In this article,  I walk through the %JSON.Adaptor class. This class is extremely useful in exporting data into serialized JSON and importing the JSON objects and saves into class object.

I'll start with the %JSON. Adaptor parameters. The parameters are crucial part of the JSON import and export operations.

If your property name is not the same as the actual JSON key name for export to external or load the data’s into object through import, you should use the%JSONFIELDNAME parameter to define the alias name.

IAM 3.4 Release

InterSystems API Manager (IAM) version 3.4.2 is now Generally Available.  In additional to bug fixes and minor improvements IAM 3.4 includes several features that might be of interest to IRIS customers.

Hi,

I see the following error when importing the Custom ASTM Schema in ASTM SCHEMA STRUCTURE page of Management Portal.

ERROR #6301: SAX XML Parser Error: zfieldDescToName+1^EnsLib.EDI.ASTM.SchemaXML.1 while processing MY_PATH\LCA1394_Schema.AST at line 8 offset 80

The line 8 is copied from ASTM E1394

Any advice?

-William

Hi All, 

I have recently uninstalled and re installed my ensemble and then are facing issues reconnecting VSCode to the local server.

The steps  taken: 

- Opened the project folder

-Tried to connect to the server and namespace.

-Encountered a "NOT FOUND" error after providing the password.

Any leads are highly appreciated!

Thanks,

Hi,

I've created an Object Gateway via the System Management Portal, and installed the following Java classes to allow connectivity between the IRIS server and RabbitMQ ...

RabbitMQ.jar

amqp-client-5.18.0.jar

slf4j-api-1.7.36.jar

slf4j-simple-1.7.36.jar

I've used the Java Gateway wizard via Studio and compiled the java classes that this would refer to, and a quick test worked on Day 1.  However, on Day 2, on trying to connect, I got this error :

<ZJGTW>%ProcessErrorNew+11^%Net.Remote.Proxy.1

However, if I go back into the Java Gateway wizard in Studio, and 're-create' the classes 

It works, even

In VSCode using the InterSystems extensions, I now have an almost working environment where routines can be created or modified on disk and these are pushed to the developer's IRIS instance.

One issue I'm finding whilst testing is that if I rename or delete a routine from disk, the change isn't pushed to IRIS and I can't work out how to make this happen.

This means that a developer can have renamed or deleted a file on disk, but can still call functions within the renamed/deleted routine within the IRIS instance and not experience any NOROUTINE errors.

I am trying to pull out something similar to an HL7 date/time stamp in a custom zen page , in a javascript code section.

var d = new Date();

(Fri Jan 12 2024 16:58:30 GMT-0500 (Eastern Standard Time)

but,
var year = d.getFullYear();

<Error>

d.<formatcmd>  doesn't seem to work.  (d.getmonth, etc.)

Is there and date formatting I can use inside a javascript routine?

The company I work for have a repository for one of our products which already contains both InterSystems and non-InterSystems source code. I'm in the process of trying to migrate us over to using VSCode to edit the InterSystems source but am stuck on some issues surrounding the files on disk and the routines in the IRIS instance.

The folder structure inside the repo is \appname\src\database.Directly underneath the database folder is all of our InterSystems source code.

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 the server (telnet

Customer has a connection set up to connect to an ISC sftp server but it keeps failing the connection with:

ERROR <Ens>ErrOutConnectFailed: SFTP Connect failed for sftp.il.intersystems.com:22/NPPES/SSL='!SFTP'/PubKey=''/PrivKey=''
with error ERROR #7500: SSH Connect Error '-2146430933': SSH Error [8010102B]: Failed getting banner [FFFFFFFF8010102B] at Session.cpp:238,0

A manual connection can be made successfully and I have verified that the credentials are correct. The Connection Settings are:

SSL Configuration - !SFTP

UsePASV - checked

I'm not sure how to interpret the error.

Thanks,

Steve

The 2023.1.3 extended maintenance releases of InterSystems IRIS, InterSystems 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:

• InterSystems IRIS
• InterSystems IRIS for Health
• HealthShare Health Connect

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.

Full

As you set learning goals for 2024, make sure you haven't missed our most popular resources of 2023!

• Get an introduction to InterSystems products and technologies(online course, 30m), or learn about InterSystems product architecture(video, 4m).
• Learn how to build basic integrations in HL7® V2 or HL7® FHIR®(learning paths, 4–7h).
• Start learning InterSystems ObjectScript, or begin developing in ObjectScript with VS Code(learning paths, 2–4h).
• Find out how to build a server-side application(learning path, 6h) or set up RESTful services(online course, 1h 30m).

Hi everyone,

I'm facing issues uninstalling Ensemble software from my system. I've tried using the command first ensemble-2018.1.0.184.0-win_x64.exe /instance LOCALENSEMBLE /qn REMOVE=ALL. Additionally, when I try to uninstall it through Settings > Apps and Features, it doesn't get removed and lists the app again there.

Has anyone encountered a similar problem or could provide guidance on the proper uninstallation process for Ensemble? Any help would be greatly appreciated.

Thanks!

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 make

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? 

Hey Community,

Do you want to get help, discuss an interesting feature, make an announcement or share your knowledge? In this post, we will tell you how to do it all.

To make it easier to navigate this "how to" just follow the contents:

• General guidelines
• Question
• Article or Announcement
• Discussion

General guidelines

To begin, you need to click on the "New post" button in the top menu of the Developer Community site:

After that, you will see the editor that will give you the choice of creating a Question, an Announcement, an Article, or a Discussion. Different types of posts have their own sets of mandatory and optional fields. 

Hey Developers,

Watch the latest video on InterSystems Developers YouTube:

⏯ Working with InterSystems IRIS Cloud SQL

Hi,

Im using an ORU_R01 2.3.1 message for converting to pdf. For the stylesheet, i need all the OBX segments under each OBR segment with  custom table headers. Can anyone help me with the xslt?

eg msg:
MSH|^~\&|WinPath|WinPath|EDT|TAY|202311262232||ORU^R01|49960|P|2.3.1|1||AL|||||
PID|||||TEST^CLINISYS||19740415|F||||||||||||||||||||||
PV1|||ZZZZ4^^^GP&GP^^^^^Virtual GP Practice||||||ZZZZ1^Dr Virtualone|E1||||||||NHS||||||||||||||||||||||||||||||||||
ORC|RE||23H00000055||CM||||202311131544||||||||||||NHS Tayside|||
OBR|1||23H00000055|HIST^HISTOLOGY^WinPath||202311131543|202311131045|||||||20231113154

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 about to take off!

Yet,

In the context of HL7 FHIR (Fast Healthcare Interoperability Resources), the terms "id" and "identifier" refer to specific elements used for identifying resources within the FHIR data model. For a newbie, these terms can be confusingly similar, but they serve distinct purposes.  

Look at the below Patient resource for August T. Faulkner:

The resource has an id of “1” — generated by the FHIR server when the resource was created.
Patient August T. Faulkner also has a identifier (Medical Record Number) — possibly provided by the hospital — of 78510398960

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.

Hey Developers,

Do check out our list of most popular videos of the year 2023 from our InterSystems Developers YouTube Channel: 

Hello, I tried to convert HL7 message to JSON in a business process and I got errors. Has anybody converted HL7 to JSON? Are certain characters not allowed in JSON?

I just tried to set a property to quote request.RAWContent and quote. I will try to put example in GitHub and share here later.