In this article, we will discuss about Orphaned Messages.

What is an Orphaned Message

Every message body is associated with a message Header which holds the metadata. The Header holds information like source configuration name, target configuration name, time created, time processed, associated message body reference, session information, message body class name, message status. When there are message body records that do not have their corresponding Header records those are called Orphan message bodies. We will discuss possible causes which could end up with orphan message bodies.

Purging only

If you want prepare yourself or test a programmer for a job, this is my tip: https://www.hackerrank.com

Hi Developers!

Here're the technology bonuses for the InterSystems Women’s Health FHIR Contest 2022 that will give you extra points in the voting:

• Women’s Health Topic
• Women’s Health Dataset
• IRIS For Health FHIR or FHIR Cloud Server Usage
• Healthcare Interoperability
• Embedded Python usage
• Docker container usage
• ZPM Package Deployment
• Online Demo
• Code Quality pass
• Article on Developer Community
• The second article on Developer Community
• Video on YouTube
• First Time Contribution

See the details below.

I am trying to work with Java Selenium through Cache  my java programme works fine but I would like to pass parameters to the jar file form my Ensemble production. I followed this Tutorial here, For starters I wanted to copy it as it is and run that as an example but the (Stateless Service Mode Example) is not working within my eclipse environment with errors on the com.intersys.complaining about the service class.

Hi Community,

Watch this video to get a brief overview of the near- and long-term plans for HealthShare containerization and Kubernetes adoption, as well as a preview/demo of our current progress.

⏯ The Future of HealthShare in the Cloud: Containers/ Kubernetes @ Global Summit 2022

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on Github when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you did a major change and expect a changed review just let me know.

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

https://community.intersystems.com/post/apm-using-cach%C3%A9-history-mo…

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

I already had class queries that returned the data i wanted, so i just needed to embed them in a REST class that returned JSON.

do httpRequest.SetHeader("organization-identifier","myName") will never set a header

If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.
​​​So @Evgeny Shvarov  suggested publishing my monthly summary of reviews here in DC.
It reflects my experience with the status I found at the time of my review.

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

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

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems

🥈 @Sergey Mikhailenko, Chief Specialist, AO Mosvodokanal

🥉 @henry, Technical Leader, BPlus Tecnologia
 

  Learn more about the competition and our awesome winners below.

InterSystems is proud to announce the developer preview program for the 2022.3 releases. Many updates and enhancements have been added in 2022.3 and there are also brand new capabilities, such as the new FHIR SQL Builder, improvements for Columnar Storage, and support to Oracle Linux 9 (not in this first preview).

Future preview releases are expected to be updated biweekly and we will add features as they are ready. Please share your feedback through the Developer Community so we can build a better product together.

The build number for this developer preview release is 2022.3.0.539.0.

As usual,

Developers, we have prepared a tutorial to get you started with InterSystems Adaptive Analytics powered by AtScale. In it, in addition to setting up AtScale and working with data cubes, we will also touch on methods of working with InterSystems Reports and other analytical systems.

Now the course is ready and we want to conduct a pilot training course on a small group of volunteers (3-5 people).

The course will be held in the form of two-hour classes for three consecutive days from 11/14/2022 to 11/16/2022.The time range is approximately 2pm to 6pm UTC+4 (Dubai).

Hello,

searching messages in our Message Bank is quite slow, often runs into timeout.

I wanted to perform a tune table on Ens_Enterprise_MsgBank.MessageHeader because this apparently has not been done yet - the Tune Table utility shows no entries for selectivity, etc.

I tried

w $SYSTEM.SQL.Stats.Table.GatherTableStats("""Ens_Enterprise_MsgBank"".MessageHeader")

and got this error message

Table 'Ens_Enterprise_MsgBank.MessageHeader' is mapped to a readonly datababase.No tuning will be performed.0 ЉpTable 'Ens_Enterprise_MsgBank.MessageHeader' is mapped to a readonly datababase.

Hello fellow developers!

When developing with ObjectScript Package Manager, one crucial thing is the package version, which we place in the module.xml file. When we add changes to the package and are ready to publish a new version of the package in the registry, we also need to increase the version number. This is clear, but it is annoying, and we can often forget to do that. 

This small article will help you to automate such a process.

want to use IIS as a web server and has configured both IIS & CSP Gateway unfortunately getting this error message . 

Hi,

when I using ObjectScript Trigger Code , I want to get whether the fields has changed by using "{fieldName*C}" ,  actually, fieldName in "{fieldName*C}" is a real field name ,but in my code, fieldName is a variable as follows:

SET stat=##class(%SYSTEM.SQL).GetColumns(tableName,.byname,.bynum,1)
		IF stat=1{
			SET i=1WHILE$d(bynum(i)){
				SET xColName=bynum(i)
				SET valComp={xColName*C}
				
				IF valComp=1{
					SET oldVal=1//{xColName*O}SET newVal=2//{xColName*N}
					&sql(INSERTINTO Yan.LogTableExt(Parref,ProperName,OldValue,NewValue) VALUES

InterSystems is pleased to announce the release of System Alerting & Monitoring (SAM) version 2.0.

What is SAM?

SAM marries IRIS’s standards-based Monitoring API and Log Monitor with familiar industry standard tools like Grafana and Prometheus to create a basic monitoring and alerting solution for IRIS clusters.

For more on SAM, see the System Alerting and Monitoring Guide.

What’s new in SAM 2.0?

The industry standard tools that SAM relies on have all been upgraded. 

Configuration Export & Import – You can now export your SAM configuration and re-import it into another SAM instance.

Hi Everyone! 
Join us on Global Masters for a fun and spooky celebration of the Halloween season. 
Complete all challenges in "It's a Halloween season 🎃" channel to enter a raffle for our new prizes 🎁 - a plush blanket and a laptop desk. 

> Go to Global Masters <

<assign value='source.{ORC:FillerOrderNumber}' property='target.{OBR:FillerOrderNumber}' action='set' />
<assign value='##class(%IO.FileStream).%New()' property='tempStream' action='set' />
<assign value='tempStream.Open(,"NEWR")' property='Status' action='set' />
<foreach property='source.{OBXgrp()}' key='g1' >
<foreach property='source.{OBXgrp(g1).OBX()}' key='s1' >
<if condition='source.{OBXgrp(g1).OBX(s1):ValueType} = "ED"' >
<true>
<assign value='SetID + 1' property='SetID' action='set' disabled='1' />
<assign value='"1"' property='target.{OBX(1):SetIDOBX}' action='set' />
<assign

Hi Guys,

My understanding is that SQL gateway connection is a way where you can have two ensemble instances where in instance A you can have a class and then you create a connection from instance B and you can run queries for that table from instance A into B?

But as I checked the doc, it says that SQL gateways is a way to just import data from an instance to another?

Thanks

Hi developers!

As a follow-up to my previous post on the Node.js Native API, I created a quick poll because it may be interesting to see what technologies developers are using in their applications around the world with IRIS & Caché. I put a poll below, just check all boxes you have used or plan to use with InterSystems technology.

Thank you all for your cooperation!

I would like to access discarded messages from a specfic process, is there any method that allows for this?

Alternatively what table holds this info so I can query it?

Hey Community,

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

Hi,

I have installed Visual Studio on my PC and connecting to IRIS on my Linux server.

I have installed the InterSystems extensions.

I click on the InterSystems icon on left->Click on "Choose Server and Namespace" -> Pick my server myTrak.

However I get this error:
request to https://mytrak:52773/api/atelier/ failed,
 reason: write EPROTO 18648712:error:100000f7:SSL routines:OPENSSL_internal: WRONG_VERSION_NUMBER:../../third_party/boringssl/src/ssl/tls_record.cc:242:

Does anyone know how to fix this?

----

Visual Studio 1.69.2
Extensions
==========
InterSystems Language Server 2.1.3
InterSystems

Hello DC Members,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Ten Times Faster Queries with Columnar Storage @ Global Summit 2022

HealthShare Patient Index November 29-December 1, 2022   9:00am-5:00 US-Eastern Time (EST)

• This 3-day course teaches the installation, configuration, and use of HealthShare Patient Index.
• Day one focuses on patient identification issues, and the tools that can be used for reviewing records identified by the system for human attention.
• This session is appropriate for both technical staff and administrative staff who manage patient identification issues.

Building and Managing HL7 Integrations November 28-December 2, 2022   9:00am-5:00 US-Eastern Time (EST)

• This healthcare-focused five-day course teaches implementation partners, integrators and analysts how to rapidly build HL7 integration solutions.
• Students build a production that processes and routes HL7 messages.
• Students learn how to work with the pre-built HL7 business services, business processes and business operations to receive and send HL7 messages.
• Students also learn how to transform HL7 messages using graphical tools in the Management Portal.

Hi

Can anyone explain how to display custom icons in a TablePane?

Andy

Recently there was an internal email thread on which SMTP server to use in demos. I thought I'd share the comments from that thread:

• Person 1: I tried gmail  (smtp.gmail.com, port 465) this morning, it works fine.
  To use gmail, you must enable 2-step verification for your google account and generate App password. https://support.google.com/mail/answer/185833?hl=en

• Person 2:  I use https://www.hmailserver.com 

• Person 3: I, too, use hMailServer as a local SMTP server on my demo VMs, with a mail client (usually Outlook) also on the VM.So no need to connect out to an SMTP server on the Internet.

Can you get a boolean response in the same way you can with a Business component using ##class(Ens.Director).IsItemEnabled(component).

Or even use this method for getting the adapter state?