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.ModelTable

TRAIN MODEL MyModel AS

Hi Guys,

I've a zen report that populate as excel to the screen using DEFAULTMODE = "xlsx" is there a way that I can run send that zen report to a file in a specific path all in the background rather to the screen?  

Thanks

Hi Community, 

We are glad to announce that Developer Community in French is now connected to Global Masters, which means members of DC FR will automatically get points & badges for their contributions.

Check out the number of points you get on Global Masters: 

Check out the

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in June 2022:

Hey Community, 

Learn how you can develop a Node.js application and connect to InterSystems IRIS data platform through the Native API:

⏯ Using Node js to connect to InterSystems IRIS

Hi Guy,

is there like a utility or a function that convert from UTC to Locale time?

Thanks

Newbie stuck again, hoping this won't be as bad as I'm thinking. In my DTL Editor I've got 

Source.Appointments.(k1).Date = 07/05/2022

Source.Appointments.(k1).StartTime = 14:30

Source.Appointments.(k1).Duration = 30

Looking to Formation a target StartTime and End Time based on the above values (and known time Zone) so they are formatted in this format 2022-07-05T02:30:00Z005:00" as the end goal right now I've got it to where I can get this for a start time as I really want to figure out the duration part before I figure out the format above: 07/05/2022 14:30 

In the Data Transform Builder I've

Question:

What version of Caché supports TLS v1.2? 

Answer:

Caché 2015.2 announced support for TLS v1.1 and v1.2.  In this version, the SSL/TLS configuration page provides checkboxes for TLS v1.1 and v1.2, which allows the versions to be configured individually.  This allows sites to, for example, require TLS v1.2 only.

Additionally, some earlier versions of Caché provide undocumented support for TLS v1.1 and v1.2, specifically Caché 2014.1.3 and above and 2015.1, on Windows, Linux and Unix.

Here’s why:  Caché uses the openssl library for SSL/TLS.

Hello, today we had another freeze in the system. It was close to 09:55. Logs follow for analysis. Following are MSM/MUMPS logs with about 1050 active connections at the time of the freeze. Does anyone see something different?

#Active connections
^CONNECTIONS("66281,35364")="1110|21/06/2022|09:49:24"
^CONNECTIONS("66281,35374")="1103|21/06/2022|09:49:34"
^CONNECTIONS("66281,35384")="1098|21/06/2022|09:49:44"
^CONNECTIONS("66281,35394")="1100|21/06/2022|09:49:54"
^CONNECTIONS("66281,35404")="1094|21/06/2022|09:50:04"
^CONNECTIONS("66281,35414")="1091|21/06/2022|09:50:14"
^CONNECTIONS("66281,35424")="10

InterSystems Native SDK for Python is a lightweight interface to InterSystems IRIS APIs that were once available only through ObjectScript.

I'm especially interested in the ability to call ObjectScript methods, class methods, to be precise. It works, and it works great, but by default, calls only support scalar arguments: strings, booleans, integers, and floats.

But if you want to:

• Pass or return structures, such as dicts or lists
• Pass or return streams

You'll need to write some glue code or take this project (installs with pip install edpy). edpy package gives you one simple signature:

call(iris, class_name, method_name, args)

which allows you to call any ObjectScript method and get results back.

Hi developer folks!

Thanks to all of you who start the development with InterSystems IRIS from the basic development template!

Recently, thanks to @Dmitry Maslennikov's contributions I've updated the Dockerfile to make the development simpler, images lighter and the building process faster. And it looks more beautiful too ;)

Here is what changed:

Hi,

I am in a situation where my container is on UTC time (as is the host). But I need to send a datetime to a machine in a specific time zone. Various languages have constructs for doing that, sometimes you need a library

python has the pytz library.

We prefer a solution which is ObjectScript only.

Hi I've got a service setup to query a sql server via ODBC.

I've got all the parameters etc setup and everything is ok

My Query is

SELECT TOP 1
CI.ClientID, 
Gender, 
DateOfBirth, 
MaritalStatus AS MartialStatusCode,
(SELECT CodeDescription FROM GenMaritalStatus WHERE Code =  MaritalStatus) AS Martial,
Ethnicity AS EnthnicityCode,
(SELECT CodeDescription FROM GenEthnicity WHERE Code = Ethnicity) AS Ethnicity,
Nationality AS NationalityCode,
(SELECT CodeDescription FROM GenNationality WHERE Code = Nationality) AS Nationality,
DateOfDeath,
CN.Surname AS Surname,
 ISNULL (CN.GivenName1, '')
 + ISNULL(

Hi Guys,

I'm using the below to export a query result to excel file and the only file type is .csv (100) but the resulting has two problems,

first the row header is including the field type and second the resulting file is a tab delimited so columns aren't properly separated (see attached below) 

set st = ##class(%SQL.Statement).%New(2,"Sample")
set sql = "select ID, name from MyClass"
do st.%Prepare(.sql)
set type="csv"
  set rs = st.%Execute()
  do rs.%DisplayFormatted(type,"C:\Temp\report")
 

Thanks

Is it a good practice to set the MAXLEN value of %Library.String property type?  Will it lead to wasted storage if its not really using it?

For example, I have to store a 5 characters long string into the below str field. Which of the statement is recommended? 

Property str As %String;

vs

Property str As %String(MAXLEN="5");

UPD: check out the Greetings video here
Hi Community!
As you know, this year Global Summit is back in-person. We really want to see everyone there! 

Not all of the Community members can attend (me either!), so we decided to produce a cool VIDEO with Greetings from Our Community Members 🎥 
Let's join virtually this great event from all around the World!🌏 

⬆️ Upload in this challenge a short (2-3 sec) VIDEO of you saying "Hi from your country🙌" to our Community Members. So, we could combine it with the other videos from our members and present it on Global Summit 2022. You can also just send me a link to a shared file in DM.

Deadline: June 18, Friday, till the end of the day!

See you there!

Hello guys!

The Global Summit 2022 in Seattle ended just over a week ago but keynotes are already available for those who missed them while being on the premises or who couldn't attend this in-person event at all for some reason or another (or just for those who wish to refresh their memory and listen to them again).

Without further ado, the beginning of the Global Summit AKA the Greetings from the Community:

Enjoy watching all the keynotes from all three days of Global Summit 2022 via this YouTube playlist: 

Hi,

I am using IRIS for Windows (x86-64) 2019.1.1

I have.

1. Created a BS with SQL Inbound Adapter which successfully connects and gets rows from DB .

2. Created a request message is populated with results of SQL query.

3  Created a BP with HL7 Router + Routing Rule + Transformation + Send to Target (BO).

4 . Created BO sending HL7 to file.

i am getting the following error.

ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zOnRequest+1^EnsLib.MsgRouter.VDocRoutingEngine.1 *DocType,Test.SQLtoHL7Req -- logged as '-' number - @''

What am i missing

Thanks.

I just met a personal challenge translating my article to French.
Tough I had to learn it at school and could read and understand
famous literature (Sartre, Molière, Mauriac, Proust, Saint-Exupéry, Anouilh, ...) 
I missed the specific terms used with ISC technology.
Thanks to @Lorenzo Scalese my errors were corrected.
But no dictionary was able to answer. 
Especially as English is gender-neutral the individual gender in other languages is just undefined.
QUESTION:
- Is there anywhere a Dictionary in ISC to cover this issue?
What I'm looking for may look like this table

After a short (or too long) pause from the previous part here is a short recap of the next few days of the Global Summit 2022 in Seattle!

As before, each day started with the keynotes (which you should be able to watch tomorrow ). But unlike the keynotes on June, 21 the following day they were dedicated to Data Platform IRIS. As before, you can find the topics and the presenters in this announcement. Some of the notable speeches were delivered by Geoffrey Moore, Bestselling Author, Consultant, and Disruptive Technology Specialist

How would you like to be able to access the Web Terminal directly from your VSCode?

If you do your IRIS development in Visual Studio Code and wish you had a convenient way to get a terminal session on your server, take a look here:

A new VS Code extension leverages the popular and well-established WebTerminal package to bring you this experience.

If you like it, please vote for webterminal-vscode in the current contest. Voting closes at midnight on Sunday 5th.

Hey Developers, 

See how you can develop a .NET application and connect to InterSystems IRIS® data platform using one or more APIs:

⏯ Using  NET to Connect to InterSystems IRIS

Hello everyone! Don't miss the Developer Community Post Digest for June 2022.

Hey Developers! Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in June 2022.

The InterSystems IRIS has excellent support for encryption, decryption and hashing operations. Inside the class %SYSTEM.Encryption (https://docs.intersystems.com/iris20212/csp/documatic/%25CSP.Documatic…) there are class methods for the main algorithms on the market.

IRIS Algorithms and Encrypt/Decrypt types

As you can see, the operations are based on keys and include 3 options:

• Symmetric Keys: the parts running encrypt and decrypt operations share the same secret key.
• Asymmetric Keys: the parts conducting encrypt and decrypt