Hello all,

We have our system with AutoParallel enabled:

USER>w ##class(%SYSTEM.SQL.Util).GetOption("AutoParallel")
1

But whenever I try to run any sql the autoparallel does not work. For example, this simple query:

When I force it with %PARALLEL we can see it will effectively run in parallel:

The total records is bigger than the threshold. So, what can go wrong? Anyone in the same situation?

The following CPF entry:

[Actions]
CreateUser:Name=foobar,Roles=%All,Password=loremipsumdolorsitamet1234,FullName=Foo Bar,ChangePassword=1,Enabled=1,Comment=Testing testing,AccountNeverExpires=1,PasswordNeverExpires=1

Fails with an error:

ERROR #506: Invalid property error at line 19, 'Password=loremipsumdolorsitamet1234', Class Security.Users, Error=<CANNOT SET THIS PROPERTY>zPasswordSet+3^Security.Users.1

A bug or a feature or a stupid user error? The documentation says nothing about the limitations:

• https://docs.intersystems.com/irisforhealth20221/csp/docbook/DocBook.UI…?

Hi, I'm new to the Analytics world in Intersystems and was attempting to print and/or export selected rows from a detail listing in a pivot on a dashboard.  I am able to print and/or export all the rows; but if I select a specific set of rows, it prints out the entire detail listing; not the selected rows. Please advise on the best approach to accomplish this task.  Thanks.

Hi Community!

Ceck out the new video dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Keeping your data private and protected with RAG

Hi Community!

We are pleased to invite all our clients, partners and members of the community to take part in the first InterSystems event dedicated to digital health professionals in Italy - InterSystems Italian Healthcare Conference 2024. The registration is already open!

➡️ InterSystems Italian Healthcare Conference 2024

🗓  December 5, 2024

⌚ 9:30  - 18:00

📍 Excelsior Hotel Gallia, Milan

Hi Community,
I am getting below "The driver cannot be loaded" error on a MacBook.

obdbc8.jar file is present in the mentioned folder.
Looking forward to resolve the above issue or workaround
Thanks

When building a bundle from legacy data, I (and others) wanted to be able to control whether or not the resources were generated with a FHIR Request Method of PUT instead of the hard coded POST.  I have extended the two classes responsible for transforming SDA to FHIR in an Interoperability Production to accomodate a setting that lets the user control the Request Method.

First is the Busines Process class.  This includes a new parameter exposed to the "Settings" tab in Interoperability called FHIRRequestMethod.

Hi Guys,

We are planning to move our system from windows to Linux and I never used Linux before and all I know that is another operating system, so the new server has Linux which looks like just terminal session like Dos and as I ran "uname -r" command to check for the version in it shows some like "6.1.112-124.190.amzn2023.x86_64".

So for the available IRIS distribution and can only found versions for Ubuntu and Red Heat, so do I have to either install one of them to be able to install & run IRIS?

I have just learned about configuration merge. However I see there is no option to configure OAuth2 with CPF. Any hopes to get that covered some day?

Hi Community,

We'd like to thank the participants of our first InterSystems Tech Video Challenge, who created nine interesting videos, wrote five articles, and uploaded two applications. And now it's time to announce the winners!

Let's meet the winners and look at their videos:

Hi Team,

I am converting xml message into HL7 message but the input XML message contains pdf which is converting into base 64 and getting mapped to OBX:5.5 in HL7 message and sending it to downstream 

In Downstream service i am using normal HL7 TCP class EnsLib.HL7.Service.TCPService but the message looks like below i am not sure why stream is taking as another segment in HL7 message,

Any thoughts on this?

Thanks,

Smythee

To transfer data between production components I actively use messages of type Ens.StreamContainer class and its descendants. In many cases the content of the message content is not visualised (the 'Body' tab contains a table with a list of selected message properties but the 'Contents' tab is empty). Response messages are never visualised, and request messages are visualised with a fifty-fifty probability. What do I need to do to ensure that messages are always visualised?

I'm playing with some anayltic queries against FHIR server tables. The HSFHIR_X0002_S_Patient.addressCity table contains a lot of cities which names contain german charachers such as ä, ö and ü.

The following query works fine:

select value from HSFHIR_X0002_S_Patient.addressCity

But this one converts city names to uppercase, and characters with umlauts are lost, so instead of "Köln" or "München" I see KOLN and MUNCHEN:

select ac.value, count(ac.value) as cnt
  from HSFHIR_X0002_S_Patient.addressCity ac
  group by ac.value
  order by 2 desc

I'm using DBeaver with IRIS official JDBC driver.

The InterSystems IRIS for Health v2024.3 is already available as a Developer Preview for some time, and I wanted to highlight new support related to FHIR Search that was introduced.

01/10/24-09:00:54:225 (14316) 2 [Utility.Event] ISCLOG: HttpRequest Error while reading from web server $ZE=<EXTERNAL INTERRUPT>zRead+28^%Net.HttpRequest.1 ns=BDHEALTH rtn=%Net.HttpRequest.1 
01/10/24-09:00:58:210 (5096) 2 [Utility.Event] ISCLOG: HttpRequest Error while reading from web server $ZE=<EXTERNAL INTERRUPT>zRead+28^%Net.HttpRequest.1 ns=BDHEALTH rtn=%Net.HttpRequest.1 

Hi 

We are embarking on a project that we are injesting raw EDI files 837's to start with into HS.

We have and inbound X12 adaptor to take in the raw *.edi file and we have an business process that is mostly pass thru. we have been unable to find any DTL to map X12 to SDA/FHIR ( similar to the ones that exist for HL7 , CDA,CCD). If anybody has done anything on this front,would appreciate any tips.

Santosh 

Hi Community,

A huge thank you to everyone who joined our InterSystems Tech Video Challenge! We’re thrilled to have all these interesting videos.

Don’t forget to check out the bonuses for the videos below:

How to create an ODBC connection on your native Windows laptop to IRIS running on a Windows VM on the same computer, test the connection, and pull data from IRIS into Excel.

Recently I learned that Excel can connect to external databases via ODBC. This includes basically any ODBC data source. Since IRIS speaks ODBC via the ODBC API, we can take advantage of the InterSystems ODBC Driver to establish an ODBC connection to IRIS on Windows that Excel can utilize.

Is there a way to create and establish DICOM Association with Extended Negotiation? 

I have implemented DICOM Query/Retrieve C-FIND, using EnsLib.DICOM.Operation.TCP and EnsLib.DICOM.Process base classes. My application, acting as an SCU, needs to query by Study Date-Time (combined date-time matching) range with timezone query adjustment. For this, I need to use Extended Negotiation.

I've checked the IRIS Manual - Creating DICOM Associations section but there is no mention of this.

Customer is trying to use Veeam as backup of Cache database and we need a script to freeze (quiesce) the database for a clean snapshot. i am looking if there is a script already done.

The IRIS Installation Guide for Linux, Installation Directory section, says "Do not choose the /home directory, any of its subdirectories, or the /usr/local/etc/irissys directory." but there are no suggestions or any default.

What are your opinions on this? For example, I see that IRIS in a Docker container is installed in /usr/irissys. I'm wondering why that directory was chosen.

The official Linux filesystem docs say:

• /usr is the second major section of the filesystem. /usr is shareable, read-only data.

I HAVE A NEW SQL CLASS THAT DISPLAYS ENTRIES BASED ON THE FIRST 2 NODES OF A GLOBAL. I FOUND OUT THAT THE CLASS ALLOWS FOR AN ADDITIONAL NODE(s) TO BE INSERTED IN THE "User Specification Node:" along the delimiter and the Piece in the NewStorage Map1 for "ModifyDDDD" shown below. it is not working.

^GBL("AA","SSSSSS")="1:1:1:1:"

^GBL("AA,"MD",1,1)="1:"

^GBL("AA,"MD","A",1)="0:"

I HAVE USED THIS:

<Data name="ModifyDDDD">
<Delimiter>":"</Delimiter>
<Node>"3,4"</Node>
<Piece>1</Piece>
</Data>

WHILE IT COMPILES IT DISPLAY NOTHING. MY QUESTION IS WHAT IS THE RIGHT SYNTAX AND PUNTUATION FOR THIS, PLEASE?

Hi, Community!

Are you using InterSystems Cloud Services? See how to get support directly in the app:

Using iService for Cloud Product Support

InterSystems FAQ rubric

By default, the order of columns in a table is determined automatically by the system. To change the order, explicitly set the order for each property using the property keyword SqlColumnNumber when defining the class.

Example:

Property Name As %String [SqlColumnNumber = 2];

Please see the documentation below.

SqlColumnNumber

If you want to change the SQL table name, specify SqlTableName. If you want to change the column name (field name), specify SqlFieldName.

Both apply only to persistent classes.

New to Python.  Attempting to use pypyodbc to select data from a table in one Cache database, and inserting into a similarly configured table in another.  Process works fine except for tables containing Date types.  NULL values in date columns are handled without issue, but when data is present, insert fails with:

An error occurred: argument 7: TypeError: 'NoneType' object cannot be interpreted as an integer.

Source table:

CREATE TABLE "SAT"."AuditAttribute" (
    "ID"                 INTEGER NOT NULL PRIMARY KEY DEFAULT $i(^SAT.

I'm trying to get the python external language server started up in a container I am starting. The container is up and running but I cannot get the python language server to start.
This is the error that is coming back when trying to start the language server. I have tried creating a custom image with that package installed but it still does not work. Is there something specific that needs to be done to to get this working? (FYI, I have the dotnet version working but creating a custom image and installing the dotnet runtimes via a docker file)
Base iris container:containers.intersystems.

I'm using a server side fonts control, with the userAction method, i'm using the action 3 (to open a zenPage). passing some info on the URL.

on Studio, the new windows opens fine and blurs the url values:

But doing this with the vs code server side command, the url keeps the values:

i can't have the same behavior on the vsCode and Studio.
The method Link on CSP.Page  doesn't work.

I'm trying to rewrite a legacy portal created with all .csp files into a portal written in .cls files. The problem I have is that the old cap pages use "csp:include page='page.csp'> tags. I'm trying to use the Include method  that is in the %CSP.Page master page. It doesn't seem to insert the required file. Any suggestions?
 

Hi,

A customer today asked whether we could offer anything like the nice lineage charts that dbt offers, based on SQL view metadata. They are very much aware of our dbt-iris adapter, but were asking in the context of their landing area, which combines foreign tables and views, ahead of possibly using dbt for onward transformations.

I just restarted an AWS instance that have been dormant for 6 months (license still valid) only to find that the web application on there doesn't work and that I cannot connect to the management portal. I can however connect to the web gateway fine but it reports the "Server is currently unavailable". 

Grateful any for any advice.

Fred Gustafsson