I have multiple projects that I utilize when debugging in Cache Studio. One of my projects suddenly lost the ability to step through commands with the yellow box and the cursor moving though code lines. The cursor just sits at the entry line while variables apparently do change. Interestingly enough, if I change the project and the debug target, the "yellow box" ability is still there. Apparently losing this functionality is by project/debug target/whatever. The goal is, of course to return it back but how?

0 24 235

Hi Community!

We are pleased to invite all the developers to the upcoming InterSystems Contest Kick-off Webinar dedicated to the InterSystems Programming Contest: Developer Tools!

In this webinar, we'll talk about the topics to expect from participants and show you how to develop, build and deploy applications on InterSystems IRIS data platform.

Date & Time: Monday, March 29 — 11:00 AM EDT

🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager
🗣  @Raj Singh, InterSystems Product Manager - Developer Experience
🗣  @Bob Kuszewski, InterSystems Product Manager - Developer Experience

0 3 187

Hey everyone.

I'm attempting to convert a date from UTC to my locale, and for some reason I can't seem to get the Ensemble ConvertDateTime Utility Function to detect the timezone to then convert. I'm hoping it's just a syntax issue, and that someone can show me the error of my ways.

0 2 49

If you create your own Language Extensions to Object you mostly have to find the
proper %ZLANGC00 or %ZLANGV00 or %ZLANGF00 and add the extensions manually.
A few utilities do it already automatically (ZPM, ZME, ..)
This utility allows you to add your extensions programmatically. (eg. at first run, or during installation)
I found this quite useful for my Docker-based demos as it all happens at the start time.

It is related to these articles

0 0 75

Want to perform SNMP performance monitoring of cache2010 on AIX 5.3. Since the SNMP service that comes with AIX does not support agentX, it cannot extend the support for cache database. Therefore, I plan to deploy net-snmp on AIX first, then enable agentX, and finally configure cache's subagent. Is this workable? Any documents? Thx!


0 1 63


First of all thanks for your time to read and reply,

We would need some help,

We have an ORM_O01 which has a NTE.3 with a Line Feed

Our Process converts the XML to ER7 using the ITB as follows:

set context.mensajeHL7 = ##class(ITB.HL7.Util.Convert).XMLToER7(hl7,.tSC,"2.5")

When we show the ER7 we observe:

INTE|1||Psa libre\X0A\ Indice psa

We have thought about the following solution, where mensajeXML is the XML representation of the ER7 shown:

0 1 70
alvin tao · Mar 5, 2021

What are the differences among HealthShare Health Connect HL7 Interface Specialist, InterSystems IRIS Core Solutions Developer Specialist and HealthShare Unified Care Record Technical Specialist these 3 certifications? And what are the prerequizites for these 3 exams?

0 3 92
Eduardo Nacimento · Mar 25, 2021
CLOB fields brock


 I need help...rsrs

 I have a query that return only one CLOB field and only one line, of oracle and  in field have a xml.

 if use  pResultSet.Get the string truncate the xml.

 I want display the xml as a service, because have many lines... i don't need iterate in xml, only get to oracle and display as xml soap.
 any tip help. 


0 1 58

We are seeing performance issues in purging objects/tables that have parent-child relationships defined. Due to the number of child objects we're seeing very long duration to purge a single parent and all child tables. Is there a better way to do this and get a more performant purge task? I was thinking to purge the child tables individually first and then delete the parent is one way. Is there any other approach?



0 1 88
Michael Lundberg · Mar 23, 2021
Time in queue


I need to know how long time a message has been in a possible queue before our business service starts handling the message. Is it possible to read with objectscript or another way?

The business service is an EnsLib.SOAP.Service

Grateful for answers

Greetings Michael


0 4 85

Where can I download the Cache ODBC drivers?

Where can I download the Cache ODBC drivers for Windows?

I need to connect to a cache database by odbc but the FPTs that I have found do not work, 
could you tell me where to download the ODBC drivers



0 7 163
Renan Santos · Mar 30, 2021
IRIS and VsCode Questions

Hi Community,


I'm developing an IRIS environment for a project and I would like to take some questions to pass on to the developers that I haven't found yet here in the community:


1. Is it possible to debug the process in VSCode in real time?

2. How can we use the terminal in VsCode for some configuration or just import applications (Example: Web Terminal)?


1 12 177

Background: We have our own SQL map that predates InterSystems'. A program writes an XML file for each table map class as $system.OBJ.Export would. $system.OBJ.LoadDir loads the XML files into .cls files.

The reason is a long story, but we need to update parameter EXTENTSIZE (only) in existing classes. This does not seem to happen. As a test I used $system.OBJ.Export to make an XML file and edited EXTENTSIZE in the two places it appears in the XML:

0 4 98

Hi Developers!

Recently we released the updated version 0.1.3 of ObjectScript Package Manager (ZPM) which comes with the support of simplified ObjectScript sources folder structure.

What 'simplified' does mean?

Before 0.1.3 ZPM expected the following structure:


---/cls  - for ObjectScript classes



---/mac - or Mac ObjectScript routines



---/inc - for ObjectScript macro include files.


1 3 297

Hi Developers!

Many of you publish your InterSystems ObjectScript libraries on Open Exchange and Github.

But what do you do to ease the usage and collaboration to your project for developers?

In this article, I want to introduce the way how to introduce an easy way to launch and contribute to any ObjectScript project just by copying a standard set of files to your repository.

Let's go!

6 21 967

InterSystems states that Caché supports at least three data models – relational, object and hierarchical (globals). On can work with data presented in relational model in a program written on C# the same way one works with any other relational DB. To work with data presented by object model in C# one needs to use .NET Managed Provider or some kind or ORM. And starting with version 2012.2 one can work directly with globals (or use direct access to hierarchical data) via Caché eXTreme for .NET

2 18 1,307
David Loveluck · Feb 25, 2019 4m read
Using Grafana directly from IRIS

There have been some very helpful articles in the community that show how to use Grafana with IRIS (or Cache/Ensemble) by using an intermediate database.

But I wanted to get at IRIS structures directly. In particular, i wanted to access the Cache History monitor data that is accessible by SQL as described here


and didn't want anything between me and the data.

1 4 590
Timothy Leavitt · Jul 8, 2020 7m read
Tips for debugging with %Status


If you're solving complex problems in ObjectScript, you probably have a lot of code that works with %Status values. If you have interacted with persistent classes from an object perspective (%Save, %OpenId, etc.), you have almost certainly seen them. A %Status provides a wrapper around a localizable error message in InterSystems' platforms. An OK status ($$$OK) is just equal to 1, whereas a bad status ($$$ERROR(errorcode,arguments...)) is represented as a 0 followed by a space followed by a $ListBuild list with structured information about the error. $System.Status (see class reference) provides several handy APIs for working with %Status values; the class reference is helpful and I won't bother duplicating it here. There have been a few other useful articles/questions on the topic as well (see links at the end). My focus in this article will be on a few debugging tricks techniques rather than coding best practices (again, if you're looking for those, see links at the end).

8 6 538
Robert Cemper · Jul 4, 2020 2m read
Terminal Multi-Line Command Editor

The Command extension enables the execution of Multi-Line Commands from Terminal prompt.

Terminal Multi-Line Input with Edit, Insert, Delete, Print extension for IRIS and Caché
IRIS and Caché have just single command lines in terminal available
This Multi-Line Commands Editor also will execute the Multi-line Commands.
In addition, it is independent of access to %SYS and can be installed in any namespace

Special thanks to @Jeffrey Drumm  who inspired me to this and supported me as beta-tester.

0 1 313