#InterSystems IRIS

Hello!

We have an integration that reads a file from labresults and needs to be transformed into another file format.

The transformation and incoming file correlate against a schema. In that schema there is a type declared as %xsd.double.
As these values ​​are labresults, we are not allowed to change the expression of the value in any way. For example, 1.0 must not become 1. And 2 must not be written as 2.0. As well as 0.3 must not be written as .3 and so on.
I am not allowed to change the type in the schema to %String. I am not allowed to change anything in the schema at all.

I've tried and

Why I've decided to write this

Once again I had a challenge that costed me some time and a lot of testing to reach the best solution. And now that I've managed to solve it, I'd like to share a little bit of my knowledge.
 

What happened?

In a namespace there were a lot of similar classes, so to make them simpler there were a superclass with comon properties. Also, there are relationships between them. I had to export one of them to JSON, but I couldn't change the superclasses, or I would break down the flow of many other integrations.

What made it all difficult was the problem that my JSON

 InterSystems announces its second developer preview, as part of the developer preview program for the 2023.1 release. Many updates and enhancements have been added in 2023.1 and there are also brand-new capabilities, such as production-ready support for Columnar Storage, ability to use Bulk FHIR, and support to MacOS 13 Ventura. Some of these features or improvements may not be available in this current developer preview.

Future preview releases are expected to be updated biweekly and we will add features as they are ready. Please share your feedback through the Developer Community so we can

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Real-Life Experiences Migrating a Caché Application Portfolio to InterSystems IRIS @ Global Summit 2022

Such most popular nowadays CI platforms as GitHub and Gitlab, offers the ability to run any docker image as a service, mostly useful for integration tests.

And I could define a GitHub workflow like this for instance, for some of my Python project which, requires the connection to IRIS

name:IRIScontainerexampleon:pushjobs:# Label of the container job  container-job:# Containers must run in Linux based operating systems    runs-on:ubuntu-latest# Docker Hub image that `container-job` executes in    container:python:310# Service containers to run with `conta

Any ideas on how this can be solved?

I need to use it with some Unicode text, in Docker image. And get this error. And documentation says nothing about it.

USER>do$zf(-100, "/SHELL", "echo", "test")
test

USER>do$zf(-100, "/SHELL", "echo", "test тест")

DO$ZF(-100, "/SHELL", "echo", "test тест")
^
<TRANSLATE>

I know that it works in some Linux environments without Docker, but no idea where is the difference. 

Morning all,

I got access to the new Bing this morning and thought I would try out some things on it. Below are a series of screenshots of what I searched and the results.
Please share your experiences here too.

   Searching for help with arrays:

  A search for a Python related topic:

Has anyone had experience using IRIS as an SFTP endpoint.  We want to use SFTP to receive files from a bank.

Dear community members!

A very common problem of our users is to use an external database as data source in an IRIS production. As many of you already know, we have two ways to connect directly to an external database, the first one is using an ODBC connection, the second is using JDBC.

In our example we are going to create a connection using JDBC, and we are going to build a simple Docker's project, in this way you will be able to modify the example as you wish.

The code is available from this URL: https://github.com/intersystems-ib/workshop-sql-jgw

In our docker-compose.yml file we are g

is it possible to export a specific data lookup table (Ens_Util.LookupTable) directly into Recordmap or Request message class or just a list of strings for me to loop through them?

Trying to find an optimal solution for a high volume interface.

I have a compactJWE that I want to decrypt using a key. I read the key from a .pem file and create a JWK with "RSA-OAEP" algorithm. I have the code below in a routine (.mac) file.

decryptJWE
    #include %msqls file = ##class(%Stream.FileBinary).%New()
    s file.Filename = "mycert.pem"s rsaKey = file.Read($$$MaxLocalLength)
    zw rsaKey
    s compactJWE = "en.cry.pted.jwe"s jwk = ##class(%Net.JSON.JWK).%New()
    s jwkStatus = jwk.Create("RSA-OAEP", rsaKey , .privJWK, .pubJWK)
    zw jwkStatus

    s jwks = ##class(%Net.JSON.JWKS).%New()
    s jwksStatus = jwks.In

Hi

I am upgrading our application from dotNet Framework to dotNet Core.

Prior to the upgrade I was able to connect to both my Cache & IRIS instances using the IRIS ADO.NET driver.

However, in dotNet Core, whilst I can connect to IRIS, I get the following error connecting to Cache.

InterSystems IRIS Provider is not compatible with Cache xDBC server
 

I am using the IRIS  driver from the Windows (x86-64) 2022.1 distribution (the one in dev\dotnet\bin\net5.0).

The cache version is Cache for Windows (x86-64) 2018.1.2

Thanks

Hi Team,

Here we have requirement to send json data from on-premises iris to business service in cloud iris namespace. we have firewalls opened.

Could you please suggest any other ways with out using WEB Service (soap or rest) solution?

Thanks,

Prashanth

So I have a base string that I want to sign using RSA-SHA256. I have a .p12 file and passphrase to get the RSA Private key using NodeJS (pem.readPkcs12 library), which I don't know how to do that in intersystems as well. (would appreciate if you can include a solution for that too)
The main problem here is I am trying to sign a string and print the result to terminal, using the code below in a routine (.mac file).

SignTest
    s privateKey = "-----BEGIN RSA PRIVATE KEY-----\r\nsomeKey\r\nsomeKey\r\n-----END RSA PRIVATE KEY-----"s myString  = "text to sign"s signedTxt = ##class(%SY

Hi,

I'd like to try out irissqlcli.

My  server, that has IRIS installed on it, is SUSE (SUSE Linux Enterprise Server 15 SP1).

How do install this product from GitHub? Detailed instructions would be great!

It would be best if I can download the software from GitHub and then get pip to install from that downloaded file repo.

The recommended:

pip install -U irissqlcli

does not work and comes back with "

ERROR: Could not find a version that satisfies the requirement irissqlcli (from versions: none)
ERROR: No matching distribution found for irissqlcli
"

Once I have this program installed:

i

With InterSystems IRIS 2022.2, we introduced Columnar Storage as a new option for persisting your IRIS SQL tables that can boost your analytical queries by an order of magnitude. The capability is marked as experimental in 2022.2 and 2022.3, but will "graduate" to a fully supported production capability in the upcoming 2023.1 release. 

The product documentation and this introductory video, already describe the differences between row storage, still the default on IRIS and used throughout our customer base, and columnar table storage and provide high-level guidance on choosing the appropriate storage layout for your use case. In this article, we'll elaborate on this subject and share some recommendations based on industry-practice modelling principles, internal testing, and feedback from Early Access Program participants. 

It's time to announce the winners of the InterSystems Developer Tools Contest! 

But first, we'd like to say Thank you to all our amazing participants who submitted 21 applications 🔥 

We are thrilled to know that you think this subject is important! Now, without further ado, the winners are...

InterSystems periodically updates our software release policies and practices to adjust to customer needs.

We're now changing our maintenance release cadence in order to be more predictable for customers and partners, and tweaking a few other areas.

This article summarizes the release cadence for our Data Platforms products and recent changes to it, and announces a few new updates.

Why change?

• Our customers are taking our new releases more quickly.
• Our customers are adopting new platforms versions (operating systems and orchestrators) more quickly.
• Security issues are arising more

In our latest episode of Data Points, @Brenna Quirk and I had a conversation with @Benjamin De Boe about the all-new columnar storage feature in InterSystems IRIS. Benjamin tells us a bit about what columnar storage is, why it's important for InterSystems IRIS users running analytical queries, and how you can learn more. Take a listen!

Does anyone have experience with installing the Arbiter Container using Podman instead of Docker in a Red Hat environment? I was able to pull down the docker image, but unsure what are the next steps as I am confused on how to start the container using Podman and ensure the parameters are set appropriately? Does anyone have the steps that I should take? Should I go through the WRC? Does the WRC have experience using Podman?

Or should I just install the ISC Agent instead of using the Container?

Please and thanks,

Scott Roth

Hello. 

I'm trying to transfer two connectors from my test env to my production env ( both are IRIS 2021.1 ) 

So i have created an SSL configuration on both :

Test env : 

Production env : 

The connector work well on the test env. When i try the same code in my production env i got this error :
 

Erreur lors de la récupération du token : ERROR #6085: Unable to write to socket with SSL/TLS configuration 'XXXXX', error reported 'SSL/TLS error in SSL_connect(), SSL_ERROR_SYSCALL: I/O error (183)'

I tried to use the advanced debug like this post : https://community.intersystems.com/post/e

Hello,

I read a great article by @Timothy Leavitt here, where he wrote about unit testing and test coverage with ZPM. I am facing a slight problem and was wondering if someone has some insight into the matter.

I am running my unit tests in the following way with ZPM, as instructed. They work well and test reports are generated correctly. Test coverage is also measured correctly according to the logs. However, even though I instructed ZPM to generate Cobertura-style coverage reports, it is not generating one. When I run the GenerateReport() method manually, the report is generated correctly.

InterSystems Supported Platforms Update Feb-2023

Welcome to the very first Supported Platforms Update!  We often get questions about recent and upcoming changes to the list of platforms and frameworks that are supported by the InterSystems IRIS data platform.  This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap.

We’re planning to publish this kind of update approximately every 3 months and then re-evaluate in a year.  If you find this update useful, let us know!  We’d also appreciate suggestions for how to make it better.

With that said, on to the update…

Hi folks!

Have a question for those who are masters of interoperability.

I have a basic task of having one CSV with some data. I need to transform one column in the initial dataset and get the new csv with the same form.

What's the best approach with Interoperability?

Should I user record mapper?

Should I use streams, objects?

What is the best practice?

How source control integrates with your system is imperative in ensuring it works seamlessly behind the scenes without interruption.

Deltanji source control understands the internal workings of InterSystems IRIS and provides a solution that can seamlessly handle its unique needs, with client integrations for VS Code, Studio, Management Portal, and Management Portal Productions.

You can find out more about the benefits of using a source control tailored for InterSystems IRIS at this webinar. 

This demo will show how Deltanji goes beyond the traditional CI/CD pipeline, automating the project lifecycle from development through to deployment, making it the perfect source control companion for organizations with continually evolving systems.

🗓 Thursday, February 23rd
⏰ 4 pm GMT | 5 pm CET | 11 am ET

Sign up here > http://bit.ly/40JOaxo
 

Where are the SQL Show History entries for each user stored?

InterSystems has corrected an issue that can cause InterSystems IRIS® and Caché to not take advantage of large pages for shared memory on Windows, even though these products report that large pages are allocated. This can have detrimental effects on system performance.

The issue results from a change in Windows 10 that requires modification of InterSystems IRIS® and Caché. Note that this issue also affects all InterSystems products that are based on InterSystems IRIS® or Caché. The issue occurs on the following versions of Windows:

            Windows 10 (version 1703 and above)

            Wi

Out of curiosity, I was looking in ^ROUTINE global to see how routines are stored internally.

I found out that lot of nodes are displaying "~pointer" as associated value (eg: instead of a string).

What are those pointers ? My guess is that it references some cache internal structure (eg: some nodes inside a B-Tree).

Is there a easily way to see what is behind ? Are pointers useful for user globals or is this something purely internal to Cache database ?

Hi Community,

A long time ago, I create a package for a String datatype that works with Regular Expression. It is quite a simple solution.

This can work well with packages like the OpenAPI-Suite, where you can then use the "Regular Expression String" as the type for properties of the validator objects where the Swagger contained a Regular Expression.

I am proposing we start a common package of datatypes for use. The package name to use can be provided by the admins.

The old package of mine can be removed, as it is also on a very old git profile on an email I no longer have.
String Regular E

Have a iris.dat file that was zipped in axis but , now I unzipped it and can see the file in my c drive but when I go to iris management console to perform a new db to pull in the current iris.dat file , in the wizard I do not see the iris.dat file listed.

Need some help with getting it restore the Cache backup in my iris community edition. 

thank you,