When there's a performance issue, whether for all users on the system or a single process, the shortest path to understanding the root cause is usually to understand what the processes in question are spending their time doing.  Are they mostly using CPU to dutifully march through their algorithm (for better or worse); or are they mostly reading database blocks from disk; or mostly waiting for something else, like LOCKs, ECP or database block collisions?

Tools to help answer the questions above have always been available in various forms. You start with ^JOBEXAM or the Management Portal's Pro

A nice feature that we recently added to version 2.12.6 of the VS Code ObjectScript extension is controlled by this new setting:

objectscript.serverSourceControl.respectEditableStatus

When set true in JSON, or checked in the Settings Editor, a server-side file will be read-only if the source control class for the namespace reports that it is not editable.

This option may be of particular interest to users of our Deltanji source control product, particularly when used in combination with the Deltanji extension for VS Code. Once set, managed documents have to be explicitly checked out via the

I implemented a Python Flask application for the 2024 Python Contest with a page that provides common form fields for an outgoing email such as the To and CC fields. And it lets you input a message as well as uploading text based attachments.
Then using LlamaIndex in Python, the app analyzes the content you put in and returns to you in a result box if there is anything that should stop you from sending that email.
Take a look at the Github repo here.

when doing ETL process from cache database to mysql database(ods) and to another mysql database(dwd).

There are  lots of DR columns in one table.

In the first step we need two databases to be totally consistent(ods=cache database)

However, the DR column in another database lost its meaning and become to normal number.

In the last step we do the data governance in ODS to DWD. My question is how to write sql without many `join` in this step.

I just installed IRIS 2022.1 onto a new VM in the MAG (Azure Government) cloud. The install was successful. Everything looked fine.

When attempting to stop this instance of IRIS, the system hangs at "Withdrawing from License Domain". Eventually, my session is disconnected. The instance then has a status of "sign-on inhibited". To stop this instance, I need to force it.

Any ideas? Thanks in advance.

Hey Community,

Watch this video to learn how to leverage standard automation tools, scripting, and HealthShare APIs to drive standardized deployments for consistent delivery of HealthShare federations:

⏯ HealthShare Deployment Automation at Warp Speed @ Global Summit 2023

Hi,

we get HL7 ORU messages from a laboratory system. Messages that do not contain an observation date should not be forwarded to the business operation. My problem is that the observation date can be in any repetition of the ORCgrp. How can I loop through the ORCgrps in a business rule?

Regards

Robert

InterSystems FAQ rubric

If you do not specify the option to remove the mirror attribute of the mirror database when deleting the mirror configuration, the database cannot be restored to a normal state and will be mounted read-only the next time it is mounted. To restore the database to a read-write state, you must remove the mirror attribute using the system routine ^MIRROR.

The procedure is as follows (execute in the %SYS namespace):

Hi Community,

Let's meet at the online meetup with the winners of the Python Contest. It's a great opportunity to chat with the InterSystems Experts team and our contestants.

Winners' demo included!

Date & Time: Thursday, August 8, 12 pm EDT | 6 pm CEST

Hi, Community!

How can you get your data ready for generative AI applications? Get some key tips from an InterSystems expert:

Preparing Your Data for Use with Generative AI

Hi,

I created a property in a Business Process class and added that property to the "settings" parameter to display it as a field in production settings.

Property ServerName As %String(MAXLEN = "");

Parameter SETTINGS = "ServerName:Server Config";

Property names cannot contain characters such as underscore or whitespace. Is there any way to change the display name in production so that I can show this setting as "Server Name" and not "ServerName"?
 

Thank you in advance.

Hi All ,

I have a dateTime in the format = "2024-08-07 17:58:51.563"
I need the difference between current date time and above one 
I need it in seconds.

The InterSystems Certification Team is building an InterSystems TrakCare Integration certification exam and is looking for Subject Matter Experts (SMEs) from our community to help write and review questions. You, as a valued InterSystems community member, know the challenges of working with our technology and what it takes to be successful at your job. A work assignment will typically involve writing 15 assigned questions and reviewing 15 assigned directly to you.  

Proposed Project Work Dates: The work assignments will be assigned by the Certification Team through September 15, 2024. 

Here

Hi Guys,

I'm getting "ERROR #6084: Unknown errors detected" when compiling my CSP pages, the pages still works fine in the new 2018 system but can do any changes because of this error?

Thanks

InterSystems API Manager (IAM) versions 2.8.4.11 and 3.4.3.11 are now Generally Available.  These are the latest versions of the two long-term supported versions of IAM. These releases contain important fixes, and all customers are encouraged to upgrade.

Customers on IAM 3.0 or 3.2 are encouraged to upgrade to 3.4.3.11 as support for those versions will soon come to an end.

IAM is an API gateway between your InterSystems IRIS servers and applications, providing tools to effectively monitor, control, and govern HTTP-based traffic at scale. IAM is available as a free add-on to your InterSystem

Hey Developers,

Play the new video on InterSystems Developers YouTube:

⏯ Updating Legacy UIs for Modern Browsers - Lessons Learned & Steps Forward @ Global Summit 2023

As a part of the IRIS Python 2024 contest, my colleague Damir and I went with an idea to build a platform called ShelterShare for connecting victims and volunteers for shelter requests . To do so we chose django as a framework and proceeded to build the first version with 3 different docker containers, django, iris and nginx which would then utilize IRIS as a pure Database engine via the beautifly composed django_iris (cudos to Dimitry). As we were progressing fast, we decided to explore the option of running it within the same container as IRIS by utilizing WSGI added in 2024.1. We knew ahead

Hello Community,

How to convert the IRIS %DynamicArray into python list. I got "<THROW>TestDyncArray+1^MyLearn.Pyth.NewClass1.1 *%Exception.PythonException <PYTHON EXCEPTION> 246 <class 'AttributeError'>: <unknown exception data>" error when passing array values to python class.

ClassMethod TestDyncArray()
{
	Do..DyncArrayInPy([1,2,3,4])
}

ClassMethod DyncArrayInPy(numbers) [ Language = python ]
{
	import iris
	print(type(numbers)) ;<class 'iris.%Library.DynamicArray'> need to be a <class 'list'>for num in numbers:
		print(num)
}

Thanks!

I have an Interoperability Enabled namespace, however, when I try to configure it for production, the Production Configuration page freezes, and, it does not show a listing of my Interoperability Enabled namespaces-

I ran into an issue trying to create new BPL and DTL items. I thought there may be an issue with the fact that my namespace was not cloned from the correct namespace (with all routines/globals/etc); or, that it was not enabled correctly for production, hence, 5002 errors. To try to clear those errors (when attempting to create BPL\DTL items), I attempted to configure the namespace

Hi Community!

Calling all InterSystems IRIS for Health users! We’re looking to gather reviews on G2 about your experience with the platform.

The first reviewers will receive a $25* gift card, so get your review in now! 

There are two great WRC best practice articles Ensemble Orphaned Messages | InterSystems Developer Community | Best
 and the delete helper post DeleteHelper - A Class to Help with Deleting Referenced Persistent Classes (intersystems.com)
that go into orphaned records and how to deal with orphans. This article is not a meaning to replace these written by Intersystems professionals but to build on this and how as a trust we used both of these to help get our database into a more compact size using this information and other discussions, including our methods of actually cl

Hi all.

Recently, I have noticed Scott Roth's mission to resolve issues with Orphaned messages with a lot of focus on prevention, and I envy that level of dedication.

Not wanting to be left out, this has sparked an interest in checking my environments for orphaned messages. Amongst a few different posts on the subject, I came across this post from Suriya Murugan in 2016 that included an interesting class in a Github Gist that seems to be built to do a deep dive into the identification and cleanup of Orphaned Messages.

My question is - is this still considered an appropriate way of cleaning

Does the assign action not work? Why doesn't MSH:7 get updated to the current DT?

Hi we are migrating to Linux from OpenVMS. which includes a new server and SAN. after reading a prior post about the differences with ESX and a VSAN I would think that the a SAN with Virtual disks all SSD type would be similar. which after reading it makes me think that using thick provisioning is the way to go. the 3rd party vendor is arguing this point with me.  is it the same premise?  is non-dedupe the way to go with thick provisioning.  we are currently on 2015.2 of Cache with the plans to go to 2018 until the app vendor is able to certify their product on the latest versin.

thanks

Paul

Frontend development can be a daunting, even nightmarish, task for backend-focused developers. Early in my career, the lines between frontend and backend were blurred, and everyone was expected to handle both. CSS, in particular, was a constant struggle; it felt like an impossible mission.

Although I enjoy frontend work, CSS remains a complex challenge for me, especially since I learned it through trial and error. The meme of Peter Griffin struggling to open blinds perfectly captures my experience of learning CSS.

But today, everything changes. Tools like Streamlit have revolutionized the gam

In PHP, I'm able to utilize the implode and str_getcsv functions to convert a comma-delimited string to a tab-delimited string. The following is an example.

$strtotab = implode("\t", str_getcsv($str, ","));

I am wondering if there is a similar way to do this in Cache and ensure that it takes into account fields enclosed in quotes. I am away of the CSVTOCLASS() method in the %SQL.Util.Procedures class. As I understand it, this is used to convert an entire file rather than a single string. The goal is to be compliant with RFC 4180.

To provide an example, the following comma-delimited string

Hi Guys,

I've configured my web application and set the Path to where my CSP pages and I can login into my application loads fine with a side menu to links to my CSP pages but when clicking to go any CSP page I got kicked back to the Login page so is there a security setting or configuration that I'm missing ?  

Thanks

Hi Guys,

I've created a website and set the path to my csp pages in Web application setting and can populate all my .cls zen pages with no issues but when it comes to CSP pages I always get sent back to login page am I missing something in  security ? 

Thanks 

I have a question about using OnInit() within a Ens.BusinessOperation.

When you include OnInit(), does OnInit() only execute when you start a Business Operation? Or does it execute OnInit () every time you send a REST request to the operation. I am trying to pinpoint when the best time is to execute the POST command to get the Token

I am needing to get a Bearer Token from a REST POST call and return the Authorization key prior to making the rest of the REST calls to pull down data.

When not using OAuth, what have you done to get the Token prior to executing any Requests?

Thanks

Scott

Hi Community,

It's time for the new batch of #KeyQuestions from the previous month.

Here are the Key Questions of July chosen by InterSystems Experts within all Communities: