I was using VSCode to edit a DTL because it seemed easier to copy/paste code from parts of the DTL I was editing. I tried to add <sql> tag and code to call a SELECT statement, but when I compiled I got the following error...

ERROR <Ens>ErrInvalidDTL: Invalid DTL

> ERROR #5490: Error running generator for method 'GetSourceDocType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

0 2
0 116
InterSystems Developer Community is a community of 25,283 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

🚨 Planned Maintenance Notice 🚨

The InterSystems Developer Community will undergo scheduled maintenance tomorrow (March 22, 2025) from 10:30 AM to 12:30 PM EST (16:30 to 18:30 CET).

During this time, the platform may experience intermittent downtime. We apologize for any inconvenience and appreciate your patience as we work to improve our services.

Thank you for your understanding!

1 0
0 91

Hey Community,

Recently, @Dean Andrews, Head of Developer Relations, sat down with Instruqt to share how InterSystems is transforming developer engagement:

>> Unlocking Hands-On Learning with Instruqt <<

“Instruqt is useful for interactive tutorials where we are sharing specific use cases of our technology with our customers, partners and developers around the world... It's such a powerful way to show our customers and partners how easy InterSystems technology is to use.” - Dean Andrews

https://www.youtube.com/embed/3w5psZdZYjA
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 169

Introduction

This is a quickstart guide to IRIS for Linux systems administrators who need to be able to support the IRIS DB as well as other normal infrastructure tasks.

IRIS is a DB system from Intersystems. An IRIS DB can hold code (in the form of a Class) or data (in the form of Globals). IRIS DB are Linux files called IRIS.DAT.

6 1
0 488

Once upon a time in Ensemble Management Portal the pool size of each component (Business Host) within the production was displayed in the Production Configuration page.

This information was very useful, especially when a production have tens or hundreds of components.

4 0
0 94
Question
· Nov 30, 2022
Clear SDA field

Perhaps this is an issue that has long been discussed somewhere. I have searched for it but still could not find the solution anywhere. In our environment, we send a container of SDA objects to UCR from HealthConnect. To populate the container we do a SQL query on a source system and then populate the appropriate SDA objects. Sometimes it happens that I want to do an update of a field and I want to empty the corresponding SDA field. In other words, send an empty string. The Alert.toTime field of the object in question is filled with the date '2022-11-29Z13:00:00'.

0 3
2 352

Hi, Community!

Looking for a safe space to create interface components outside your live environment? See how interface branches can help:

Using Interface Branches in Health Connect Cloud

https://www.youtube.com/embed/mHEUTuTH_CE?utm_source=youtube&utm_medium=social&utm_campaign=mHEUTuTH_CE
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 79
Question
· Feb 5
How to delete account

Help!

I want to get rid of this account but there seems to be no way to do this by myself. Whom can I write to, to have my account deleted? Thank you in advance...

0 2
0 128

I am starting a conversion project for a health system that is currently migrating to Health Connect. They have their DEV and TST environments in one production and their PRD in another. What is the best practice for standing up conversion environments...separate name spaces in the two productions or separate productions? Keep in mind the interfaces are temporary?

Mike

0 3
0 94

Hello there 🙋‍♂️,

I'm looking towards a functionality alike Python's difflib, but made with Intersystems products. I already know could embed Python code within IRIS but thought maybe there was a development already done for handling deltas, with a different approach or extra utils.

Even if I find such a library after comparing both might still go with difflib or any other more suitable. Intend to use it for a cross-environment checklist/check tool.

Please find below a sample of HTML rendering computed and made with difflib, with a few lines of code:

0 0
0 80
Article
· Mar 10 5m read
FHIR SQL Builder: step by step

The FHIR standard establishes a powerful but flexible data model that can smoothly adapt to the complexities of operational healthcare data management. This flexibility comes at the cost of a data model with many tables and relationships, even for simple data such as the patient's record of telephone numbers, addresses, and emails. It would easily require querying 4 different tables. However, FHIR SQL Builder eliminates this problem, allowing you to create visual projections (mappings) in web wizards.

9 2
3 301

Hey Community!

We're happy to share the next video in the series dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Is your data ready for AI?

https://www.youtube.com/embed/vKPUhiSYbQk
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 95
Question
· Mar 18
SLF4J error

Hi Guys,

I get the attached error when trying to populate JSON string into a textarea, I'm running IRIS 2024 in a container in Ubuntu, any clues what could be the problem?

Thanks

0 2
0 60

I have two instances of IRIS, one is Production and another one is Staging (both managed by Docker) and I want to set up a full daily recover of the Staging server from a full backup of the Production server. I know how to do this manually using the DBREST utility, as well as how to make a copy of the database by making a full copy of the durable directory (however this option requires a full stop of the Production-database). What is the best way to automatically restore all databases from a full backup using scripting?

0 1
0 83

Hello Community!

We are delighted to invite all our customers, partners and community members to participate in the InterSystems UK & Ireland Data Summit 2025! The registration for the Summit 2025 is already open.

This year’s InterSystems UK&I Data Summit event will focus is on empowering our partners to harness the transformative power of innovative technology to drive business growth and success. At this event, we'll explore how you can build and deploy innovative new solutions to stay competitive and achieve sustained growth.

➡️ InterSystems UK & Ireland Data Summit

🗓 Dates: March 26 - 27, 2025

📍 Place: Hyatt Regency, Birmingham, UK

3 0
0 161

Hi,

We’re launching an Early Access Program for an upcoming Table Partitioning feature that will help IRIS customers manage very large tables, and distribute row data and associated indices across databases and storage tiers. Table Partitioning cuts deep into the core of IRIS relational data management, so we want to make sure we get things right through working with a few engaged customers who can provide feedback on the initial deliverables, and fine-tune as needed.

8 11
1 284

Hi ,

I am creating a report on Trakcare with the help of Jreport. But the date parameter from trakcare is not reading on Jreport and the report is blank.

If I hardcode the date on Jreport,it is displaying on Trakcare but not taking report from Trakcare.

Parameter used on report manager on Trakcare is $g(%request.Data("DateFrom",1)).

Can anyone please tell me any change of settings on Trakcare or Jreport will help to work ?

Thanks for the help

Jude

0 8
0 181

Hi,

My HL7 interface in production is outputting messages to a HL7 File Operation and a EnsLib.HL7.Operation.HTTPOperation. There is no errors in the File Operation, but the HL7 HTTPOperation is giving ERROR #5911: Character Set 'iso-8859-4' not installed, unable to perform character set translation. Both the HL7 File Operation and HL7 HTTP Operation are using latin1 for Default Char Encoding.

What is ERROR #5911 about? Is something missing in the IRIS installation?

1 5
0 95

Hi Community!

Thank you to everyone who participated in the "Help Us Improve the DC Search" sweepstakes! Your feedback is invaluable in making the Developer Community better, and we will use it to improve our search. Now, it's time to announce the winner - watch the video to see the sweepstake drawing:

https://www.youtube.com/embed/SXS9F0McVsM
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

4 0
0 170

Have you ever been editing files in VS Code, but needed to check a global value or run a few ObjectScript commands? Now you can, with no setup required! If you have vscode-objectscript extension version 2.10.0 or later and are connected to InterSystems IRIS 2023.2 or later, you can now open a terminal connection to your server, regardless of where it's located.

There are three ways to open this new terminal:

21 7
11 1.8K

I have the need to query an external database and write the result set/snapshot to an internal %Persistent [ DdlAllowed ] table that I built. I have built inbound SQL Services before and write them externally to replace SSIS jobs, but how would querying a database via a Service and writing the data to an internal table work?

Can I just take the inbound query structure and write it to the class file of the internal table in a DTL? If so, what would be the Target? Or does this need to be done within a BPL as a Code block?

0 2
0 89