Hi Guys,

is there a way to get an audit or a record of deleted records in a class?

so basically, I'm looking for way to track delete record or from which class or class method call that delete statement was executed,  my understanding is that so for example using %OnfterDelete  I can track any deleted record using %Delete(), so if the user execute a (Delete from myclass)   sql statement can OnfterDelete track that ?

Hi All,

When I log into Backup  mirror member it becomes too slow to load and navigate, I tried to check message log and I saw the error message about Database mirror latency and database disk issue which when I check it looks fine to me. Please have a look at the below screenshots and advise what the issue could be.

When I run df -h through SSH :

200G is the volume size, 194G is used space, 6.5G is available space and 97% IS %Use

Datababase view from management portal for the same db volume

Disk space error message from message log:

The below error shows sometimes when the system tries to load

Hello everybody!

I’m having some odd issues with IRIS for health community edition and creating a new namespace.

Versions 2021, 2022.1 & .2 for Windows and Ubuntu allow me to create a new namespaces and the databases for it.

As you can see above, I’ve enabled the namespace for interoperability productions.

I’ve run this creation process with not copying the mappings, copying everything from user, and so on, with out a difference to the end result.

Hello, would anyone know where in Linux I need to change permissions on this? 

it is running a full Apache install and not what came with Cache.

Hey Community!

If you follow our updates, you should know that several months ago we created a new regional community for all those people who speak (and write) French!

You can find it here: fr.community.intersystems.com

After only three months we already have 25 members (I know, it doesn't sound a lot compared to 11.000 members on English Community, but French Community is a newborn compared to an adult) and more than 140 articles, 3.000 views, and 160 likes. We already have exclusive content not present on other regional Communities and our own "thing" which you may spot in our recaps of different events where moderators and admins from the French Community were present.

Is there any way to dynamically generate the output filename for a schedule task?  For example when running a legacy code task every hour , is there anyway to specify the output file name to be appended with time stamp or some incrementing number to avoid overwriting ? 

Hi

I'm trying to migrate a database from cache to iris but i get this from one of the classes on compiling.

ERROR #9101: Global name 'Jobcosting.JobActivityGroupGroupD' for 'IDLocation' is too long, must be no more than 31 characters in length.
  > ERROR #5030: An error occurred while compiling class 'Jobcosting.JobActivityGroup'

Hi! As a developer who was forced to move from Mac to Windows (temporary) I found some things a bit confusing. In this article I would like to talk about some tweaks I made to make my experience smoother. I think it can help not only Mac users who need to use Windows environment (for ex. in VMs), but also can help some Windows users to make some things more convenient. Of course, all the points are subjective, the best setup is one that works for you.

All the tweaks are related to Windows 10 as I don’t have an access to Windows 11 at the moment.

Hi,
Is there a nice cheat sheet for the IRIS command line (terminal) application?

Hey Community, 

Enjoy watching the new video on InterSystems Developers YouTube channel:

⏯ Multi Model Capabilities of InterSystems IRIS

Hello,

I work on deploying IRIS using Kubernetes operator and Red Hat OpenShift. I encouraged another team working on Java application to consider using IRIS as database. My team deployed IRIS cluster using two mirrored data pods for the other team. The other team asked me for the connection information.

To learn how to use Java with IRIS, I attempted to deploy two apps from Open Exchange:

https://openexchange.intersystems.com/package/CRUD-GLOBALS-IRISNATIVEAP…

Here I got errors like this:

package com.intersystems.jdbc does not  exist

https://openexchange.intersystems.

Does anyone has an ini parser/writer in ObjectScript they can share?

Hi Community!

We're pleased to welcome @water huang as our new Moderator in the Developer Community Team!

Let's greet @water huang with big applause and take a closer look at his bio!

@water huang （黄念刚）is a developer at Southwest Technical Support Center of Mediway（东华医为）.

Here are some words from @water huang:

• Since I joined Mediway in 2012, I started to learn InterSystems technologies and integrated platform. I used the early versions of InterSystems Caché, Ensemble. Ensemble 2016 is my main development tool at present.

Say I have a persistent class in IRIS with an optional property EmailOptIn:

Class Person Extends %Persistent
{
Property Name As %String;
Property EmailOptIn As %Boolean;
}

I later realize that I'm doing a lot of null-checking on this property where I shouldn't need to. The solution is to make this a required property:

Class Person Extends %Persistent
{
Property Name As %String;
Property EmailOptIn As %Boolean [ Required ];
}

When I make this change I'll need to update all the existing data to set a reasonable default where it is null.

Hi Community,

We are excited to announce that InterSystems Developers Meetups are finally back in person!

The first Python-related meetup will take place on July 21 at 6:00 at Democracy Brewing, Boston, MA. There will be 2-3 short presentations related to Python, Q&A, networking sessions as well as free beer with snacks and brewery tours.

AGENDA:

Leet (or "1337"), also known as eleet or leetspeak, is a system of modified spellings used primarily on the Internet. It often uses character replacements in ways that play on the similarity of their glyphs via reflection or other resemblance. Additionally, it modifies certain words based on a system of suffixes and alternate meanings. There are many dialects or linguistic varieties in different online communities. Wikipedia

You'll have to translate a string into a LeetSpeak. As usual shortest solution wins.

As I was thinking what I could develop for InterSystems Full Stack Contest, I saw this post:

https://community.intersystems.com/post/how-access-production-items-through-objectscript

I developed ProductionManager.csp. It displays items in the active production. It also displays the Class in use and the date and time of last message. I believe these data points can help you make decisions which items to remove from the production.

I read that contest asked for apps which insert, update, or delete data in InterSystems IRIS.

I am still working on iris-for-money app: https://github.com/oliverwilms/iris-for-money

Account.csp posts a rest call with _SYSTEM username and the password.

xhttp.open("POST", "/restapi/sql/" + query, true,"_SYSTEM","SYS");
xhttp.send();

/restapi web application has Password Authentication Method enabled.

SYS is the correct password for _SYSTEM user.

I do not understand why I see login failure in Audit database.

I am working on iris-for-money app: https://github.com/oliverwilms/iris-for-money

Account.csp posts a rest call with _SYSTEM username and the password.

xhttp.open("POST", "/restapi/sql/" + query, true,"_SYSTEM","SYS");
xhttp.send();

The error is logged in Riches.REST for this line:

Set tSC = tStatement.%Prepare(pQuery)

ClassMethod PostSQL(pQuery As %String = "", pIndex As %String = -1) As %Status
{
    Do ..DebugTEST("Riches.REST - PostSQL")
    Do ..DebugTEST("pQuery = "_pQuery)
    Set tSC = ..TestQuery(pQuery,.pQuery)
    Do ..DebugTEST("TestQuery = "_pQuery)
    Set tStatement =

Hello and welcome to the 21st InterSystems programming contest! 

🏆 InterSystems Full Stack Contest 2022 🏆

Duration: June 27 - July 17, 2022

In prizes: $10,000

Hi Community,

This post is a introduction of my open exchange iris-climate-change application.

iris-climate-change  web application Imports  The Food and Agriculture Organization (FAO) Climate Change dataset by using LOAD DATA (SQL) functionality and analyze and visualize data with the help of Python Flask Web Framework, Pandas Python data analysis Library, Plotly Open Source Graphing Library for Python and Plotly JavaScript Open Source Graphing Library.

Hi,

I am wondering if anyone would know where I can get a copy of the ASTM E1394 specification for an ASTM-XML file based instrument to LIS interface I am writing?

The instrument vendor refers to ASTM 1394-97.

Cheers,
Patrick

We have the following code, but recently had a few issues with messages sent to downstream systems being rejected. 
After investigating, seems that the message being sent is being truncated, the RawContent that we are pulling from Ens.EnsLib_HL7.

What is the correct way to specify rowspan and colspan in a ZEN PDF report using <Item> <Caption> 

I am specifying rowspan in the <Caption> tag after the <Item> but it's not working.

I haver read $Query and $Order but still not getting the code that i am looking to work correctly. 

I have a global like 

^TestGlobal("Not Configured","Value 1")=""

^TestGlobal("Not Configured","Value 2")=""

Hey Community,
I have an scenario, please advise or suggest possible ways to solve it.
So i have a persistent class to test results of a diagnostic laboratory. The properties are 

• Patient name
• Type of Test
• Order ID

I had a customer the other day ask how GREFs are measured and how the relationship of the host, storage, and DB engine all influence that number measured in hundreds of thousands or millions.  Is there any good documentation that explains this and/or assists with calculating a GREF count?

I am receiving Mirroring updates to an IRIS for Health async reporting server and need to pause the mirroring journal processing to periodically quiesce the database to rebuild cubes and custom staging tables.

What API or web service can I use to quiesce the reporting server and then later initiate catch up?

It's time to announce the Winners for June! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in June:

🥇 @Danny Wijnschenk, Application Developer/Owner, Winfo, Belgium

🥈@Lorenzo Scalese, Solution Architect, Zorgi, Belgium

🥉 @YURI MARX GOMES, Software Architect, YM Services, Brazil

🥉 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

 Learn more about the competition and our awesome winners below.

I've been playing with IntegratedML and have created a model and trained the model.  When I try to use PREDICT or PROBABILITY statements in an SQL query, I get the following error:

[SQLCODE: <-400>:<Fatal error occurred>]

  [%msg: <PREDICT execution error: ERROR #5002: ObjectScript error: <OBJECT DISPATCH>%LoadModel+31^%ML.AutoML.TrainedModel.1 *<class 'AttributeError'>: 'str' object has no attribute 'decode' - >]

Here's an example of the sequence of steps I've followed that lead to the error:

CREATE MODEL MyModel PREDICTING (IsError BOOLEAN) FROM Example3.