InterSystems FAQ rubric

When you run a routine in the terminal and an error occurs in the program, if you have not set the error trap properly, the program will enter debug mode as shown below.

Hi everyone.

I have a function that may end up being called from a number of transformations at the same time, and within the function there's some Embedded SQL to first check if a local table has an entry, and then adds the entry if it doesn't exist.

To prevent a race condition where the function is called by two transformations and they both end up attempting to insert the same value, I'm looking to use the table hint "WITH TABLOCK" on the insert, but this seems to be failing the syntax checks within vscode.

Are table hints supported with embedded sql?

Hi,

I'm currently working on configuring an Ens.Alert component within Ensemble 2018, and I'm looking to set up a system default settings for it.

Could anyone guide me through the process of setting up these default setting for the Ens.Alert component?

Thank you in advance!

Hi,

i have this simple json structure:

{
"nTypeTrigger": "ATR",
"sDate": "2024-04-17 15:29:16",
"tRefArray": [{"sID":"132"},{"sID":"151"},{"sID":"233"}],
"tCountries": []
}

I can't find an example to iterate on tRefArray.

I've tried to create a secondary iterator but it doesn't work. Here is my current code:

Hello!

I wonder if anyone has a smart idea to extract an XML fragment inside a text document (incoming from a stream)?

The XML fragment is surrounded by plain text.

Example:

text...........
text...........
<?xml version="1.0" encoding="UTF-8 ?>
<Start>
...etc
</Start>
text...........
text...........

The XML is not represented by any class or object in the Namespace.

The XML can look different from time to time

Hi

Some of our integrations use a system DSN to interact with our Data Warehouse (built on Microsoft SQL Server). We've recently migrated from SQL Server 2016 to 2022 and on the day of go-live we changed DNS cname records as a mechanism for redirecting everything to the new server. This worked great for users and reports, but for some reason we found that HealthShare clung onto the old server name even after several days.

Hello everybody,

I've been experimenting with Embedded Python and have been following the steps outlined in this documentation: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

I'm trying to convert a python dictionary into an objectscript array but there is an issue with the 'arrayref' function, that is not working as in the linked example.

This is a snapshoot of my IRIS terminal:

Hello developers!

We invite you to a new Spanish webinar "SMART on FHIR, extending the capabilities of HealthShare"

📅 Date & Time: Thursday, April 25th, at 4:00 PM (CEST).

🗣 Speaker: @Rubén Larenas , Sales Engineer at InterSystems

Hey Community,

Play the new video on InterSystems Developers YouTube:

⏯ Unleashing the Power of Machine Learning with InterSystems @ Global Summit 2023

https://www.youtube.com/embed/X5VqUGVFcdM
[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]

Hi Guys,

I'm trying both of these methods to get a JWT token but none is working for some reason and not sure what I'm missing?

it works when I tested it from Postman

Thanks

Hello community,

in addition to HL7 V2 interfaces mediated via TCP/IP, we have been implementing more and more HS.FHIRServer.Interop.Service based services that are addressed via port 57772.
We would like to secure access to the Management Portal now and have come up with a procedure that I would like to discuss.

What user can be used to initiate IRIS container in emergency access mode on startup?

Hi,

I recently moved to a Mac M2. I was already using VSCode on my intel-based Mac, and used the plug "objectscriptQuality for VSCode". It installs nicely, but it does not seem to do anything, not even an error. I installed the same java version (but ARM based) as on my old machine so that prerequisite is met. Also set the path to java in VSCode.

Any clues/has anyone got this working on a Mac based on Apple silicon M1/M2 chips?

Thanks.

Hi,

I have created view from External table joins internal persistent table. Create VIEW worked but Select * from Viewxxx throwing error.

"References to an SQL connection must constitute a whole subquery"

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...(SELECT%20*%20FROM%20Mylink.