Hi there have been various posts around how to clean up globals without parent data but none have gone into how you solve these issues.

Our database is approaching 600gb in size so i am looking into how to reduce this.

We use standard purge tasks.

Our cache stream class has a global size of 2463243 from running global size so it is what i would like to tackle first.

1) is there any way i can find based on my oldest message session for where most of these globals

Healthcare interoperability is instrumental in improving patient care, decreasing healthcare provider costs, and providing a more accurate picture to providers. However, with so many different systems, data is formatted in many different ways. There are many standards that have been created to try to solve this problem, including HL7v2, HL7v3, and CDA but each one has its drawbacks.

Hi，guys

My client is using IRIS 2021.1 Interoperability and they want to highlight the sessions with unresolved(without resent and completed operations) errors so their maintenance team can have a list of unresolved sessions to check against.

When I'm working on it, it seems to be it is is difficult to decide whether a session have unresolved errors. For example,

I running a query and get the results inside a result set. Now I have to iterate through the result set many times. From the doc I've seen only the Next() method. Is there a way to reset the cursor? Otherwise what is a good data structure to save multiple rows of a table?

My code in this case is something like this:

set sql = "SELECT * FROM MY_TABLE WHERE X= '"_Y_"'"
set status = ..Adapter.ExecuteQuery(.rs, sql)
// somehow iterate the rs more than one time

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

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

🥇 @YURI MARX GOMES, Software Architect, YM Services, Brazil
🥈 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria
🥉 @Sergei.Sarkisian , Sales Engineer, InterSystems Corporation, UAE
🥉 @Irène.Mykhailova, Associate professor, Igor Sikorsky Kyiv Polytechnic Institute, Ukraine

Learn more about the competition and our awesome winners below.

I am trying to avoid parsing the SDA3 stream in each process. I am doing some section wise validation in different processes so i need to pass the SDA3 to each process.

When i pass that SDA3 stream that takes a lot of space in HD and takes a lot of time to parse the SDA3 object.

Is there any way that once i parse that SDA3 i can pass the same object to other processes, and i can save my storage and process that fast.

I cannot pass this by default to other process as non persistent object cannot be passed to another job(as per my finding).

Hey DC Members,

You have ideas on how to make the Tech Article contest even better?

We want to hear from all of you: both from our participants and from those who were unable to participate! Please answer some questions to help us improve our writing contest:

👉 1-min survey: InterSystems Tech Article Contest #3 Survey

I've faced a problem that happens while debugging a process in VSCode. It doesn't seem to matter if this is in a container, on my development VM, or against a locally installed version of IRIS. The problem seems to be mostly with X12 Documents.

So, in a debug session, I can dump out a value to the debug console and it loos correct. The same variable in VSCode appears to be some uninitialized memory location.

In the interactive debugger window:

I want to get Mirror Status and copy this report into a file for audit purposes.

I have a Linux servers for IRIS DB with this layout:
LIVETC01 Backup
LIVETC02 Primary
LIVEDR Async Copy
ARBITER

I understand that this will get me the mirror status
# sudo -u irisowner iris session LIVETC01
LIVETC01:USER>zn "%SYS"
LIVETC01:%SYS>do ^MIRROR

1) Mirror Status
2) Mirror Management
3) Mirror Configuration

Option? 1

Has anyone had any success reading barcodes from PDFs or images in a Cache/IRIS application? I've been looking at some possible solutions for this, including the open source ZXing libraries. I know we have the ability to create them in Zen and Intersystems Reports, but as far as I know, there's nothing built in to actually read data from a barcode. If anyone has suggestions on how to go about this, I'd love to hear them.

Hi,

I have a problem with the recent update 4.9.4 of the WebTerminal.

This message appeared after the loading of the page :

Hi

I created a password validation routine for the management portal, which is called from the System-wide Security Parameters.
The validation process works correctly, but the error message that is displayed to the user when the entered password fails validation, consists of two separate error codes and messages

I am doing a HL7 data transformation with object script but need to only write a substring from the first "(" of the NTE-3 field to the end.

example

Input: NTE|1|||Some text (HI) (321)|ABC

Desired Output: NTE|1|||(HI) (321)|ABC

Basically I'd like to delete "Some text ".

If I were writing a shell script I would use sed 's/^.*(/(/' with perhaps a modification to get only the first.

I use the function wizard but can't seem to get the right code.

Kindly help me on the below points

1)Concatenate the Date column and Time column.

2)Get the current date only without time.

3)Find the current age using DOB column.