Calling @Luca Ravazzolo 
 

Check AbortMessage method here.

First query your messages to  find the correct id set and after that call AbortMessage for each header.

The reason SQL did not work is that your messages are enqueued.

1. Install public web server (Windows, Linux).

2. Connect it to InterSystems IRIS.

2. Enable HTTPS there. Easiest way is Let's Encrypt.

Docs specify that Connect should come before Authentication.

Try this code:

Try {
    Set ssh = ##class(%Net.SSH.Session).%New()

    Set sc = ssh.Connect(host)
    Write:$$$ISERR(sc) "Connect:", $System.Status.GetErrorText(sc),!
    
    Set sc = ssh.AuthenticateWithUsername(username, password)
    Write:$$$ISERR(sc) "Auth: ", $System.Status.GetErrorText(sc), !
    
    #dim sftp As %Net.SSH.SFTP
    Set sc = ssh.OpenSFTP(.sftp)
    Write:$$$ISERR(sc) "SFTP: ", $System.Status.GetErrorText(sc), !
    
    Set sc = sftp.Dir("/", .contents, , $$$YES)
    Write:$$$ISERR(sc) "Dir: ", $System.Status.GetErrorText(sc), !
    
    Zwrite contents
    
    //If 'sftp.Disconnect() Write "Failed to logout",!

} Catch ex {
    Set sc = ex.AsStatus()
    Write "Exception: ", ex.DisplayString(), !
}

Is your app in that Namespace an Interoperability production?

Great reference!

&sql(SELECT Name, DOB, Gender INTO :Name, :DOB, :Gender FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

%JSON.Adaptor does not construct an intermediate dynamic object. You can use %ObjectToAET to convert normal object into dynamic object:

set dynObj = ##class(%ZEN.Auxiliary.altJSONProvider).%ObjectToAET(obj)

There are two approaches:

1. Create a "result set" class to hold the results (interestingly, InterSystems provides %XML.DataSet and other tools for this specific use case with XML/SOAP. Docs):

Class Test.JSONRS Extends (%RegisteredObject, %JSON.Adaptor)
{
Property count As %Integer;
Property results As list Of Book;
}

2. Simple approach:

• Output header {"results": 3, "items": [
• Call %JSONExport on each book (don't forget the comma at the end)
• Output footer ]}

Despite being hacky, the second approach is better:

• If JSON export on each individual object is successful it works every time and if some object fails we won't get valid a JSON anyways
• It can be easily generalized to use with any type of result
• It does not hold a large structure in memory as each object is loaded/displayed individually.

That said, I generally recommend against supplying count in query results because of many reasons:

• Users do not care for thousands of results
• It's slow - we need to know how much results there are
• Use pagination instead - if a current page has a max number of results, display the link to the next page

You'll need a Custom Function.

If the lookup field is indexed (Location in your case) you can use this function for all Lookup checks:

ClassMethod Exists(class As %Dictionary.CacheClassname, index As %String, value As %String) As %Boolean [ CodeMode = expression]
{
$classmethod(class, index _ "Exists", value)
}

Interesting.

Can you please add source code for java classes, such as ParseXML.Parse?

You need to write an Alert Processor. Monitoring Alerts.

Calling @Benjamin De Boe.

Awesome!

If you're interested in monitoring, try brand new System Alerting and Monitoring. There was also a Tech Talk about it recently.

Interesting article!

I encountered Business Process variation of this issue recently and would like to add that setting  SKIPMESSAGEHISTORY parameter is not always a complete solution. It disables sent/received reference history, but pending messages are still stored in a collection (no way around it).

In cases where one BP instance waits on more than ~10 000 messages simultaneously same issue occurs (I got a journal file per minute on 50 000 pending messages).

The recommended approach would be to change architecture layout so that one process would wait on a more reasanable amount of messages.

Classes:

• Config.ECP
• Config.ECPServers
• SYS.ECP

I would recommend creating mirror manually, checking values in Config classes and moving from that.

Again, ICM can do that automatically. This is a preferred alternative.