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=1
			WHILE $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(INSERT INTO Yan.

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 value='source.

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.

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?

Hi Guys,

I've a task scheduler that is stuck in Running is there a way for force stopping it?

Thanks

Hi Community:

Thought you might be interested in this new partner we just signed in Sydney -- PainChek® Ltd , the Australian-based developer of the world’s first pain assessment and monitoring application for smartphones. Its software-as-a-service, artificial intelligence platform uses smart devices with cameras to accurately evaluate pain levels. 

PainChek is using InterSystems IRIS for Health™ and integrating its application with electronic medical record (EMR) systems – including InterSystems TrakCare®.

How do I create recursive classmethod which stop all methods from running when condition are meet?

ClassMethod workpieceUnit(mainArticle As %String, article As %String) As %String
{
	
	&SQL(SELECT unit->unitCode INTO :unitCode FROM production_article.composition WHERE mainArticle = :mainArticle AND article = :article)
	
	IF SQLCODE = 0
	{
		W !, "Has Value"
		QUIT unitCode
	}
	ELSE
	{
		SET sql = "SELECT article, unit->unitCode,  production_article.composition_sqlArticleCode(article, type) AS articleCode FROM production_article.

Hi Community,

I am working on sending Gmail with error details when any errors occurs in the ensemble production.

I am facing the below issues while doing it

1.I have Ens.Alert (Business process) using the class Ens.Alerting.AlertManager and Emailoperation (Business operation) using the class EnsLib.EMail.AlertOperation. here my business process is not sending the Alarm request to business operation eventhough i am using rule to connect the business operation 

2.What are SMTP server details needs to given for Gmail?

Please let me know how to resolve these issues

Thanks,
Smythee

Hi,

I want to know how to add a class to IRIS namespace 'USER' using terminal.

How do I do this?

I know you can add this class using Visual Studio Code with the Intersystems extension installed on my PC and connected to an IRIS instance.

Is it possible to do this with terminal? From this prompt:
BASETC:USER>

I have a class like in this example:

Class ObjectScript.RightTriangle
{

/// Compute area and hypotenuse of a right triangle
ClassMethod Main()
{
    write !, "Compute the area and hypotenuse of a right triangle",
          !, "given the lengths of its two sides."
    ....
}
}

Hi Team,

How InterSystems cache calculate the license count based on process?

How to we determine the product required license count ?

Thanks

Rathinakumar

Hi, I have a laptop with a Core i5 processor, a workstation with AMD Athlon 3000G processor, and another workstation with AMD Ryzen 3900 onboard. I was succeded to install IRIS Health community on the laptop. On both AMD workstations the install process hangs. I've waited for 8 hours but with no avail. What could be wrong with AMD?

This is not an issue in ObjectScript, due to its typeless nature. But it's essential for external programming languages that care a bit more about types of variables.

And in any case, it's still reproducible in ObjectScript. I have table

CREATE TABLE some_table (
        id INTEGER NOT NULL, 
        x INTEGER, 
        y INTEGER, 
        z VARCHAR(50), 
        PRIMARY KEY (id)
)

And data

INSERT INTO some_table (id, x, y, z) VALUES (1, 1, 2, 'z1');
INSERT INTO some_table (id, x, y, z) VALUES (2, 2, 3, 'z2');
INSERT INTO some_table (id, x, y, z) VALUES (3, 3, 4, 'z3');
INSERT INTO some_table (id, x, y, z) VALUES (4, 4, 5, 'z4');

Hi, devs!

In ObjectScript I can refer to a class parameter as:

write ..#ParameterName

How do I do the same in Embedded Python?

Hi Developers,

This October, you posted 80 new questions on the Developer Community:

Here are the Key Questions of October chosen by InterSystems Experts:

Hi Developers! 

InterSystems continues the Developer Meetup event series. The next one will happen on November 17th from 5:30 pm-8 pm ET in Boston, MA, USA.
At this meetup, you will learn more about Kubernetes, Mirantis Lens tool, and how to run Lens with InterSystems IRIS IKO (InterSystems Kubernetes Operator).

Food and drink will be provided. 

> Register here <

Agenda:

Hi,

I would like to use the XML Schema Wizard / %XML.Utils.SchemaReader to generate the Cache classes.

It seems Xerces has trouble with xs:import. XSD Source - DMP_Rheumatoide_Arthritis.xsd

Fehler: FEHLER #5373: Klasse 'DMP.cda.dmpclinicaldocumentheadertyp', von 'DMP.cda.levelone:property:clinicaldocumentheader' benutzt, existiert nicht
Abgeschlossen bei 2022-11-05 22:17:18

Maybe I can solve this problem by enabling this feature in Xerces somehow?

http://apache.org/xml/features/honour-all-schemaLocations

Is there any other way to work around this problem?

Best regards

Ruiyan Yu