#InterSystems IRIS

Hello developers,

In this article, I'll show you how to run code at compile time with ObjectScript macros.

Here's a use case that recently led me to use this feature:

As part of a medical application developed for more than 20 years, we have a large number of parameters. Although we have procedures for documenting these settings, it can be helpful to have a quick view of which settings are actually used by the application code.

To get this view, we could search the code with regular expressions.

Enhanced Password Management: Edit Passwords Seamlessly

In the ever-evolving landscape of digital security, robust password management tools have become indispensable. Our password management application, designed to simplify and secure your online life, now comes with an enhanced feature – the ability to edit passwords with ease.

Why is this feature a game-changer?

1. Flexibility: Life is dynamic, and so are our online accounts.

When I attempt to start my local IRIS instance (named LATEST) I am getting the below error

"(111) Error starting service: LATEST
Reason: (1069) The service did not start due to a logon failure."

Does anyone have experience with this or know how to resolve the logon credentials associated  with this start? 

native-api-py-demo

This is a demo of IRIS Native API for Python, which uses Python to call the Object Script method and flow the message in production. Python obtains the message after flow and the message in global, and uses ZPM Package deployment.

Firstly, we need to install the Native API package

Enter on the command line

Then, we import the Object Script code into studio

Then, we modify the namespace, uesename, and password to make the information consistent with IRIS

Finally, click Run to use Python to call the Object Script

Hey Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Best Practices for InterSystems IRIS System Performance in the Cloud @ Global Summit 2023

For several years now Visual Studio Code has supported the notebook coding paradigm with a maturing UX and an API that is enabling a notebook extensions ecosystem to grow. One of the best-known notebook platforms is Jupyter Notebooks. A Microsoft team publishes an extension that allows VS Code to handle .ipynb notebook files. These can either work against a local Python environment or connect to a Jupyter Server, which typically hosts remote Python environments with beefier resources.

What if your InterSystems IRIS environments, whether local on your workstation or remote in your organization / cloud, could operate as Jupyter Servers? And not only for Embedded Python but also for ObjectScript and SQL

"If we build it, will they come?"

Have you ever thought of creating your own systems for editing users or, perhaps, even an API that you can call? Today, you’re going to join me in the %SYS namespace and get to know Security.Users! 

This class has forty properties, many of which you’ve seen before in the System Management Portal.

I am very new to IRIS. We are developing a PHP application that connects to an IRIS instance of one of our vendors. This works well most of the time, but when I query a table to get data from particular fields that contain long text strings, it returns `NULL`. These fields are all `VARCHAR(30000)`.

I tried using the `$extract` functionality in the IRIS documentation, but that made no difference. I also tried setting the PHP setting `odbc.defaultlrl` to both 31K and 0. Neither resolved the issue.

I also looked through the internet to try and find a similar issue, but wasn't able to find anything

I

From time to time InterSystems must respin a release to correct 1-2 issues. This process generates new kits called "Point Releases".

A Point Release is distinct from maintenance or feature releases.  Its objective is to correct an urgent issue in the field quickly and surgically.  

Hi Community,

We're pleased to invite you to the upcoming webinar in Hebrew: 

👉 Leveraging Embedded Python in Hebrew 👈

🗓️ Date & time: September 12th, 3:00 PM IDT

InterSystems FAQ rubric

It can be retrieved using the schema INFORMATION_SCHEMA.

INFORMATION_SCHEMA is a system schema and is not displayed by default in the SQL menu of the Management Portal.

The method to display it is as follows.

1. Open Management Portal → System Explorer → SQL menu.
2. Check "System" on the left of the schema drop-down.
3. Select INFORMATION_SCHEMA from the schema dropdown.

The SQL to get the ID, field name (COLUMN_NAME), data type (DATA_TYPE), description (DESCRIPTION) for the specified table (Sample.Human) is as follows.

SELECTID,COLUMN_NAME,DATA_TYPE,DESCRIPTION
FROM

  If you're looking to get started with SQL in InterSystems IRIS or want to make your queries more efficient, try one of these short online learning exercises!

• Running Fast Queries with SQL in InterSystems IRIS (10m)
• Optimizing SQL Queries in InterSystems IRIS (15m)

Both include learning labs, so no need to bring your own instance. 

Still working on my first External REST API call, and I am struggling to find the exact answer I am looking for... I get a JSON response from my API call but I am not quite sure how to dynamically get the JSON response into the Ens.Response Object with its lists of Arrays that I have defined.

  set tSC = ..Adapter.SendFormDataArray(.tHTTPResposne,"POST",tHTTPRequest,,,tURL)

  set pResponse = ##class(User.REST.Epic.Msg.GetPatientLocationResponse).%New()

  set dynObject = {}.%FromJSON(tHTTPResposne.Data)

  set iter = dynObject.%GetIterator()

  while iter.%GetNext(.key,.value){

    $$$TRACE("key =

Hi everyone,

I have a question related to a strange issue I've been experiencing over the last few days.

Context

I'm attempting to create an automatic resending system that, if no reply is received from the server, raises an error and re-sends the message. This process continues for the a duration defined by the FailureTimeout (e.g., 20 seconds), and a new message is being sent every 5 seconds until the FailureTimeout is reached. If no response was obtained from the server, the system returns an error. 

Issue

I've noticed that at times, even with the same input and settings, the outputs displayed

My cluster status is as follows:

when I do journal restore on primary, it says journal restore is not allowed. The DR is also not allowed to do journal restore.

1) Begin Journaling (^JRNSTART)
 2) Stop Journaling (^JRNSTOP)
 3) Switch Journal File (^JRNSWTCH)
 4) Restore Globals From Journal (^JRNRESTO)
 5) Display Journal File (^JRNDUMP)
 6) Purge Journal Files (PURGE^JOURNAL)
 7) Edit Journal Properties (^JRNOPTS)
 8) Activate or Deactivate Journal Encryption (ENCRYPT^JOURNAL())
 9) Display Journal status (Status^JOURNAL)
10) -not available-
11) -not available-
12) Journal

Currently, the SQL privileges (SELECT, INSERT, UPDATE, DELETE) are managed at the tables level, which can be very tedious when you have to administer many roles in an organization, and need to keep them sync with a constantly evolving data models.
By managing privileges at the schemas level, will allow to give SELECT and other DML privileges to *all* or *several schemas* to a role|user, fixing the need to manually synchronize the new tables|views to the roles.

If you agree, I invite you to vote for this idea.

I usually receive complains from our customers about the BPL and DTL web pages automatic refreshes, it's a common problem among newbies users but for veteran developers too, they forget to save the changes regularly and automatically the web page is reloaded, losing all the work done.

Maybe an autosave would fix this problem that produces a deep feeling of hate and resentment against InterSystems technology among our customers. I've added an idea in our portal, so feel free to vote it!

https://ideas.intersystems.com/ideas/DPI-I-452

Suppose I have a PDF and I need to convert it to an IMAGE (it can be a JPG or PNG)

Does anyone have an idea?

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. 

With that said, on to the update…

IRIS Production Operating Systems and CPU Architectures

Red Hat Enterprise Linux

• Recent Changes
  
  • RHEL 9.2 & RHEL 8.8 were released in May, 2023.

In today's landscape, enterprises have grown substantially in scale, amassing vast amounts of data. This data is collected from a plethora of sources including different applications, databases, and other channels. Given the diversity and volume of this data, it's only logical for these enterprises to seek a deeper understanding of what their data entails. Some of the data can be stored in IRIS, and it can be reasonable to be able to add this data to a data lake too.

The Internet now offers many different tools for such tasks, that do not yet support IRIS, but it's achievable. 

What do you

Hello Community,

Anyone who has (near or distant, with a preference for the 1st option) knowledge of the use of Amazon QuickSight with IRIS is invited to share his|her experience in this discussion.

Thanking you in advance.

Hey Developers,

Watch this video to learn how to use Embedded Python using applications from the Open Exchange app gallery:

⏯ Embedded Python Use Cases @ Global Summit 2023

Hi Developers,

We are pleased to invite you all to the new InterSystems online programming contest focused on Python! 

🏆 InterSystems Python Programming Contest 🏆

Duration: September 4 - 24, 2023

Prize pool: $14,000

How to understand what's wrong with compilation if the compilator just hides errors?

Compilation started on 05/15/2023 15:58:11 with qualifiers 'cuk'

Detected 1 errors during compilation in 0.003s.


Compilation started on 05/15/2023 15:58:32 with qualifiers 'cuk'

Detected 1 errors during compilation in 0.002s.


Compilation started on 05/15/2023 15:58:51 with qualifiers 'cuk'

Detected 40 errors during compilation in 0.089s.

40 errors, and what do I have to do with this so valuable information?

I received an ISCLOG errors in my IRIS container, and the processing is very slow because of that. How to solve this problem?

[Utility.Event] ISCLOG: SuperServer Super Server job slave failure ns=%SYS rtn=%SYS.SERVER
[Utility.Event] SuperServer failed to start slave server
 

This question originally appeared in the comments of the post: Using the new InterSystems IRIS Hibernate 6 Dialect for a Springboot Project
 

Hello @Yuri Marx 
greetings for the day!
I am unable to fix this issue (using an enum in the entity class; it's not creating the table).

Can you please any one assist me for How to connect with the InterSystems IRIS in Java(Quarkus) version 3.0. 

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Stepping Out of the Shadows: How the US VA Migrated to Mirroring, InterSystems IRIS & the Cloud @ Global Summit 2023

We continue with the series of articles related to the QuinielaML application. In this article we are going to cover how to prepare the raw data that we have captured using the Embedded Python functionality.

Welcome everybody!

Hi all,
I am trying to execute a query like the below code.
set statement = ##class(%ResultSet).%New("some_class:query_method").   // here query method is empty and with rowspec some columname

statement.Execute(param1)

I want to fetch data type of column value returned from above. eg - Name - VARCHAR, amount - INTEGER etc.
How can I get it. Or if not possible directly. Is there any other way to validate or get datatype of values returned. Line we have type() in python3