Hello,

I'm looking for a way to write a stored procedure or something to return a ResultSet with Embedded Python.

My goal is the following:

I have a Goal table with a Text field that is free text.

CREATE Table Goal (
    Id int,
    Text VARCHAR(5000)
);

I would like to create a procedure that returns all the entities (in the iKnow sense) in a new Entity column.

Python code, i would like to use :

import iknowpy

engine = iknowpy.iKnowEngine()

# Row to parse
text = 'This is a test of the Python interface to the iKnow engine. another sentence to test this program with.'
engine.

Welcome to the next chapter of my CI/CD series, where we discuss possible approaches toward software development with InterSystems technologies and GitLab.

Today, let's talk about interoperability.

Issue

When you have an active interoperability production, you have two separate process flows: a working production that processes messages and a CI/CD process flow that updates code, production configuration and system default settings.

Clearly, CI/CD process affects interoperability. But questions are:

• What exactly happens during an update?
• What do we need to do to minimize or eliminate production downtime during an update?

Trying to identify which records in the %SYS.Audit table are fails.

Eg, as user "WORKER", I run an attempted a grant, the terminal returns:

SQL> GRANT SELECT ON newschema.patients TO COORDINATOR
[S1000][Iris ODBC][State : S1000][Native Code 112]
[libirisodbc35.so]
[SQLCODE: <-112>:<Access violation>]
[Location: <ServerLoop>]
[%msg: <User WORKER does not have required privileges to grant the privilege(s)>]
[ISQL]ERROR: Could not SQLExecute
 

but the record in the audit table gives

Description: "SQL GRANT Statement"

EventData: "GRANT SELECT ON newschema.

Hey Community,

Join us to have a look back at recent developments in care planning and coordination and a look forward at what is on the horizon:

⏯ Unified Care Record: New & Next 2022 @ Global Summit 2022

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems Interoperability Contest – a great opportunity to have a discussion with the InterSystems Experts team as well as our contestants.

Winners' demo included!

Date & Time: Thursday, September 22, 09:00 AM EDT 

>> Register here <<

As the title says, when I use the "Go To Definition (F12)" option, it opens the definition in read only mode. Is there some way to either directly make the go to option editable or can i turn the read only version into an editable version? I end up needing to open the file directly and then manually going to the method definition myself.

For quite some time InterSystems IRIS supports such thing as Merging CPF. So, with help of this it should be possible to define only desired changes in configuration. And get them applied even with vanilla Docker image. 

And I though it could be useful when used with Dockerfile. Use this way to configure IRIS during docker build instead of using Installer manifest.

While the documentation of configuring authentication with Kerberos for IRIS on Linux servers is sparse, for docker i found no docs at all. Assuming I would be able to adapt the requirements from linux to docker (on linux host) I had no success at all. Has anyone successfully done this?

Even with "do ^REDEBUG" set to FFFFFFFF the log did not help much, I always get "Kerberos error getting initial credentials with password; KDC reply did not match expectations". Since I moved the iris.

If I'm using an objectgenerator, is there a way to check the compile flags and have it behave differently based on which flags are set?

And as a tangent, is there a list somewhere of what compile flags there are?

With iris session <instance>:

Is it possible to tell the program to read commands & other inputs from a file and when it reaches end of file

return control back to the physical terminal? 

Hi Community,

We are super excited to announce the winners of the InterSystems Interoperability Contest: Building Sustainable Solutions! 

Thank you all for participating in our coding competition! Without further ado, the winners are...

Experts Nomination 

🥇 1st place and $5,000 go to the Sustainable Machine Learning app by @Lucas Enard

🥈 2nd place and $3,000 go to the iris-energy-isodata app by @Muhammad Waseem

🥉 3rd placeand $1,500 go to the iris-megazord app by @José.Pereira

🏅 4th place and $750 go to the n8n-nodes-iris

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Analytics with InterSystems New and Next 2022 @ Global Summit 2022

SQL obtains the user's operation permission on the database

Hi Community! 
Are you in Dubai on October 10-13? Join us at the Global DevSlam conference for developers with 15,000 participants expected in person!
📍Let's meet here: Hall 9, Stand № H9-E30
🌟 We will host the event: "The hands-on workshop on InterSystems IRIS Data Platform"
Speaker: @Guillaume Rongier, Sales Engineer at InterSystems
October 10, 2pm - 3:30pm 
Register here 
❕We have free promo passes for our Community Members, partners, and customers. Please drop me a line if you are willing to attend!

Put the InterSystems FHIR Server to work at the HL7 FHIR Connectathon in Baltimore last weekend, posting bundles, getting all RESTy with resources, and interrogating the Vulcan Implementation Guide We straddled the Real World Data (RWD) and Schedule of Activity (SoA) projects for Vulcan IG folks moving the ball forward connecting clinical research and healthcare data.

This is a self contained class that can be run from the Intersystems Task Scheduler which records peak usage details for databases and licenses built up throughout the day and retaining 30 days history.

To schedule the task to run every hour:  

d ##class(Metrics.Task).Schedule()

You can also specify your own start time, stop time, and run interval:

d ##class(Metrics.Task).Schedule(startTime, stopTime, intervalMins)

Metrics are stored in ^Metrics in the namespace that the class resides in/is run from.

I've installed the latest version of IRIS using Minimal settings as I'm just looking for some basic IDE without connecting to anything.

After install, I see all the files in the Intersystems folder, however there is no "IR" in the system tray. I don't see any executables to launch either. System restart did not populate the system tray either.

Is there any other way to launch Studio?

Hey Community,

We greatly appreciate all your feedback on the InterSystems Interoperability Contest! Please take a short survey and answer a few questions to help us improve our contests.

👉 Quick survey: Interoperability Contest Survey 2022

Feel free to share your feedback in the comments of this post as well!

Hi Friends,

In my production already we have business components (business service , process, operations) and all are working fine.

Now I have change the package structure of few classes and want to update the references in settings for Business components in Management portal.

As this class field is read only , Any other way to update the class reference, instead of creating new business component?

Hi Friends ,

Here I have imported object script cls classes form local file to studio , As a result new package created and all the cls files showing inside the package.

Now When I comple newly imported classes , it is thows compilation error because , each cls is already compiled in source system.

I'm trying to send a message into a production on change a persistent object. 

And when I change an object using SQL - I get an error, 
when change the object using objectscript - I get  a message (but not an error or exception) 
But the most interesting - everything works fine (the object has been changed, and business service receives data) 

Persistent class

Class Demo.

I have migrated one project from CACHE to IRIS that contains lot of classes that inherit from BI (Business Intelligence).

Usually it looks like this : 

Class User.Foo Extends (%Library.Persistent, %XML.Adaptor, %BI.Adaptor)
{
}

I was wondering if there is an equivalent of those classes in IRIS, and, if not, if there is a workaround that would allow me to at least le me compile those classes.

I tried to create an empty class like that : 

Class %BI.Adaptor
{
}

But I got the following error in Studio : 

5883    Item '%BI.Adaptor' is mapped from a database that you do not have write permission on.

Hi Community,

It's voting time! Cast your votes for the best applications in our Interoperability Programming Contest focused on building sustainable solutions:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

Hey Community, 

Don't miss the new video on InterSystems Developers YouTube channel:

⏯ Working with ObjectScript Classes in VS Code for Client Side Editing

I cloned iris-interoperability-template for my app interoperability-test. I wanted to develop an app to test interfaces in Interoperability productions.

I have never run a container in Docker Desktop. I always run containers in AWS. My first problem was that I got an error when I tried to build the image using docker-compose. The error was about BuildKit. I worked around the error by building the image with a docker build command relying on DOCKER_BUILDKIT environment variable:

DOCKER_BUILDKIT=1 docker build --progress=plain --no-cache --tag testint .

Next I updated docker-compose.

Hi all. Today we are going to install Jupyter Notebook and connect it to Apache Spark and InterSystems IRIS.

Note: I have done the following on Ubuntu 18.04,  Python 3.6.5.

Introduction

If you are looking for well-known, widely-spread and mainly popular among Python users notebook instead of Apache Zeppelin, you should choose Jupyter notebook. Jupyter notebook is a very powerful and great data science tool. it has a big community and a lot of additional software and integrations.

Great news, the extension to Docker Desktop for InterSystems Container Registry is now publicly available for everyone.

It is already available in the marketplace in Docker Desktop. It was published today, and it requires restarting Docker Desktop to see it.

Let's consider these two ways of passing an obj to a function:

//var is a structured obj
(1) do ..methodX(var)
(2) do ..methodX(.var)

In c++ if we pass an obj by reference like in (2) we save a lot in computation because we are not copying the whole object, and when the object is modified within the function it is modified also for everyone.

In this case does (2) achieve any better performance than (1)? Is passing with the "." save any computation? the object is copied anyway?

Is there a simple way of passing obj to a function?

Hi developers!

Here is the score of technical bonuses for participants' applications in the InterSystems Interoperability Contest: Building Sustainable Solutions 2022!

I am trying to pull the status of operations in health connect. I'm successfully pulling if it's enabled/disabled, but I'm not getting access to where the current item status is held (for example, items in error). I found "##class(EnsPortal.Utils).ItemStatuses", but I can't retrieve data from that. Is this data readily accessible via another means?

Thank you!