#InterSystems IRIS

When using CallableStatement to call a stored procedure, the log shows an error. SqlCode-400.

This is my calling statement.

CALL web_DHCENS_CDSS.patadviceinfo_patadviceinfo(?,?,?)

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Diving into InterSystems Cloud Technology

Hi Community!

We're pleased to invite you to the "Online Meetup with IRIS Programming Contest Winners" on April 3rd at 11:00 EDT! 

It's a virtual Meetup with some of the winners of the past InterSystems IRIS Online Programming Contest. 

What awaits you at this virtual Meetup? 

• Our winners bios.
• Short demos on their applications.
• A short interview with all the winners about the past contest. Plans for the next contests.

IRIS 2010.1 brought us a new feature: %Net.WebSocket.Client

As a continuation of my series of WS Clients I just couldn't resist to try it.
Well, this is the result and it was rather simple in the end.

• After I succeeded in my personal fight against Windows Firewall ;-)

You basically need to prepare 3 classes:

• Credentials for User, PW, SSL
• an Event Listener
• the Client (Could be a .MAC routine as well)

The example uses the WSS.EchoServer (a derivate from former SAMPLES in Caché).
The default assumption is to have Client and Server on the same system & namespace.
But if you have some o

In Caché you had an example of a WebSocket Server in namespace SAMPLES
With IRIS the samples are gone and require additional installation effort.

So I refurbished the code with some useful additions:

• independent of namespace
• timeout control from client
• readable communication log

This contains 2 classes:

• rcc.EchoServer.cls
• rcc.WSScsp.cls for testing. Called from Browser by (http://localhost:52773/csp/user/rcc.WSScsp.cls)

The server is essential for the 'native' WebSocket Client Demo

GitHub

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in March 2020!

22 New applications in March 2020

isc-generate-db by Henrique Gonçalves Dias

Creating a new database, namespace, CSP/REST Application never been so easy.

cmPurgeBackup by @Alexey Maslov

 cmPurgeBackup is an utility that can be used to erase old Online Backup files.

Hi guys,

Couple days ago, a customer approached me with the wish to enhance their existing legacy application, that uses SOAP (Web)Services so it shares the same authorization with their new application API based on REST. As their new application uses OAuth2, the challenge was clear; how to pass access token with SOAP request to the server.

After spending some time on Google, it turned out, that one of possible ways of doing so was adding an extra header element to the SOAP envelope and then making sure the WebService implementation does what is needed to validate the access token.

GA releases are now published for the 2020.1 version of InterSystems IRIS, IRIS for Health, and IRIS Studio!

A full set of kits and containers for these products are available from the WRC Software Distribution site, including community editions of InterSystems IRIS and IRIS for Health.

The build number for these releases is 2020.1.0.215.0.

InterSystems IRIS Data Platform 2020.1  makes it even easier to develop and deploy real-time, machine learning-enabled applications that bridge data and application silos.  It has many new capabilities including:

• Kernel Performance enhancements, inclu

InterSystems has corrected a defect that can result in data integrity issues on systems using mirroring.

This defect affects:

• All currently released versions of InterSystems IRIS and IRIS for Health, except 2020.1
• Caché and Ensemble versions beginning with 2011.1.1
• All HealthShare products based on the above Data Platforms versions

This defect is more likely to be encountered in IRIS and IRIS for Health 2019.4. It is highly unlikely to have occurred on deployed systems running any other version.

The issue can only occur in a situation that meets all of the following conditions:

1. A database

Hi Community!

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ A Skeptics Guide to Containers

Hi Developers!

InterSystems Online Programming Contest is over. Thank you all for participating in our IRIS Competition!

As a result - 20 great apps! And now it's time to announce the winners! 

Hey Developers!

Want to beat the COVID-19 pandemic with InterSystems and MIT? Please take part in the MIT COVID19 Challenge!

It's a 48-hour virtual hackathon with the goal to develop solutions that address the most pressing technical, social, and financial issues caused by the COVID-19 outbreak.

And it's your chance to build a solution on InterSystems IRIS for the COVID-19 crisis! 

I know that collection is instance of %AbstractList.

But what about $listbuild? Does it possible to detect that given variable is instance of $lb?

I am glad to say that VSCode-ObjectScript reached 4000 installs. Thanks to all of you who use it in their work.

VSCode-ObjectScript is an extension for VSCode which allows you to develop InterSystems based applications on ObjectScript using the modern code editor developed by Microsoft. Choice #1 editor amongst all developers worldwide by Stackoverflow survey 2019.

Some short notes about how to install and configure it you can find here.

If you need any help with a migration process of your development team to VSCode, please contact us by info@caretdev.com.

Hi developers!

When @Evgeny Shvarov announced the first InterSystems IRIS Programming Contest, I started looking for new ideas.  

I put together a few ideas, and that's what isc-utils is about.

•  Conversions
  • Temperature
  • Length
• Exchange Rate
• Weather

Temperature Scale Conversion

IRISAPP>write ##class(diashenrique.Utils.Temperature).CelsiusToFahrenheit(28)
82.4

IRISAPP>write ##class(diashenrique.Utils.Temperature).CelsiusToKelvin(28)
301.15

IRISAPP>write ##class(diashenrique.Utils.Temperature).FahrenheitToCelsius(82.4)
28

IRISAPP>write ##class(diashenrique.Utils.Tem

Hi Developers!

Create Database, Namespace, REST Applications using Portal Management is an easy task. You just need a few clicks or maybe more clicks than you expect.

But, what if you traded all those clicks for a simple command-line ?!

IRISAPP>do ##class(diashenrique.Utils.GenerateDB).CreateNew

You just need to answer a few questions: 

Do you want to create a new Database/Namespace? (Y/N) : 

Choose your Namespace name : 
Choose the Dataset location <Path Default is mgr directory> :
Make this an Interoperability namespace? (Y/N) : 
Do you want to split the database into CODE/DATA? (

Hi Community!

The registration phase for InterSystems Online Programming Contest ends today and we will start the voting week!

Now we have 20 applications - so you have a set of applications to choose from!

How to vote?

This is easy: you will have one vote, and your vote goes either in Experts nomination or in Community nomination.

Hello,

I got the idea for this application, because for my work we have a process that currently uses legacy Vista code called MailMan to transfer files using email. I thought I could create a process in HealthConnect (IRIS Interoperability) to replace the need for having the legacy code. I have seen File Passthrough and TCP Passthrough Operations that can transfer a stream (file content) into a file or through TCP connection. I did not find Email Passthrough Operation, so I decided to create it. It receives request with a stream that has the content of the file. I want it to send an email me

This code snippet changes all passwords in a system to a specified string. The two literal strings at the beginning of the snippet can be adjusted to edit the system or password string. The class method "test" runs the code:

Class eduardlebedyuk.changePasswords Extends %RegisteredObject
{
	ClassMethod test()
	{
        set ns = $namespace
	    zn "%SYS"
	    set NewPass = "NewPassString"
	    set rs=##Class(%ResultSet).%New("Security.Users:List")
	    set st = rs.Execute()
	    while rs.Next() { set st=$SYSTEM.Security.ChangePassword(rs.Get("Name"),NewPass)}
        zn ns
	}
}

(Originally po

DISCLAIMER: I am not an InterSystems engineer or a professional ObjectScript developer.

I just want to share my opinion about some things I am really miss in ObjectScript.

I really appreciate everyone who support my project (Declarative ObjectScript) in contest

but the post is not about "why you should support me" on contest.

I faced with ObjectScript in the university while was working on my diploma (in 2013).

Very good mentor @Evgeny Shvarov helped me to get started with ObjectScript development.

In those days I was surprised about ObjectScript doesn't support passing methods to an

Hey Developers,

New "Coding Talk" video was specially recorded by @Maks Atygaev for the IRIS Programming Contest: 

⏯ Declarative ObjectScript Promo

Starting in March 2020, Microsoft plans to release a series of security updates that will cause Windows Active Directory (AD) servers to reject unencrypted simple binds. For more details on the changes to Active Directory, see Microsoft’s Security Advisory ADV190023.

Instances of all InterSystems products using LDAP with Windows AD servers for user login can be impacted if they are not already properly configured to use TLS/SSL. The impact is not limited to instances running on Windows versions. The potential impact exists whether instances perform LDAP authentication directly or via the Dele

Hi Community,

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ Understanding System Performance Metrics

I hope you already know one of my projects Cache Blocks Explorer. I've recently renamed it to Blocks Explorer.

For the recent contest, I've added a new feature, the ability to generate a static picture of any Cache or IRIS database. Like below. Where unique globals have a unique color. This is how looks like inside 9.5GB database. Where 1 pixel represents one block. By link on image you will get even bigger image, with more detalization.

In Episode 6 of Data Points, certification manager Jamie Kantor joins the podcast to tell us all about the InterSystems Certification program, what exams are currently being offered (and what ones are in development), and why it matters for developers and enterprises. Check it out!

InterSystems IRIS 2020.1 brings a broad set of improved and new capabilities to help build important applications. In addition to the many significant performance improvements accrued through 2019.1 and 2020.1, we are introducing one of our biggest changes in recent SQL history: the Universal Query Cache. This article provides more context on its impact to SQL-based applications at a technical level.

InterSystems has corrected two defects that, in rare circumstances, can result in data integrity corruption after running global compaction, database compaction, or database defragmentation. InterSystems recommends avoiding these utilities until after applying the corrections listed below.

1. The first defect is caused by database compaction, defragmentation, or global compaction, and can result in database corruption. If you have used one of these utilities on a database, InterSystems recommends that you perform an integrity check on it. This will identify any data corruption that has occurre

For standalone installations I always recommended to use custom namespaces and not the USER namespace.

However, what about Docker?

In many Dockerfiles I see the creation of additional namespace, but why, if only one namespace is required?

What do you think?

We have a data transformation where source is object collection (populated from a json file)  and target is EnsLib.EDI.XML.Document.

If source file is large enough, transformation fails and we get <store> error and I quickly found this:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=EBPLR_DTL_foreach which at the bottom in "Avoiding <STORE> Errors with Large Messages" section tells to: 

"As you loop over segments in a message or object collections, they are brought into memory. If these objects consume all the memory assigned to the current process, you may get

Hi Community!

Enjoy watching  the new video on InterSystems Developers YouTube:

⏯ InterSystems IRIS and Node.js Overview