All
Accepted answers
Luis Angel Pérez Ramos · Aug 28, 2024 go to post

I install it directly from the intersystems_irispython-3.2.0-py3-none-any.whl file (here):

pip install intersystems_irispython-3.2.0-py3-none-any.whl

Luis Angel Pérez Ramos · Aug 28, 2024 go to post

Hi @Timo Lindenschmid ! Thank you for your answer, I've tried disabling that option but it doesn't work:

And the result for the query: 

[SQLCODE: <-230>:<Foreign table query Execute() failed>]

  [%msg: <Foreign Tables - ERROR #8104: Gateway Exception: <GATEWAY> java.sql.SQLSyntaxErrorException com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112) Remote database reported error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"patient" T1' at line 1>]

Luis Angel Pérez Ramos · Aug 12, 2024 go to post

In this article @Eduard Lebedyuk creates a production monitor to check the inactivities for the different components

You can modify the following code:

If (tDiff > tTimeout) && ((lastActivityReported="") || ($system.SQL.DATEDIFF("s",lastActivityReported,lastActivity)>0)) {
    Set tText = $$$FormatText("InactivityTimeoutAlert: Inactivity timeout of '%1' seconds exceeded for host '%2'", +$fn(tDiff,,0), tHost)
    Do ..SendAlert(##class(Ens.AlertRequest).%New($LB(tHost, tText)))
    Set $$$EnsJobLocal("LastActivity", tHost) = lastActivity
}

Replacing the SendAlert by:

If (tDiff > tTimeout) && ((lastActivityReported="") || ($system.SQL.DATEDIFF("s",lastActivityReported,lastActivity)>0)) {
    Set tText = $$$FormatText("InactivityTimeoutAlert: Inactivity timeout of '%1' seconds exceeded for host '%2'", +$fn(tDiff,,0), tHost)
    Set tSC = ##class(Ens.Director).EnableConfigItem(tHost,0) 
    Set tSC = ##class(Ens.Director).EnableConfigItem(tHost,1) 
    Set $$$EnsJobLocal("LastActivity", tHost) = lastActivity
}
Luis Angel Pérez Ramos · Jul 31, 2024 go to post

IRIS 2024.1 has no web server (but community version has). The fastest way to configure a web server is to install an IIS or Apache before to the IRIS installation and IRIS will detect and configure it.

Luis Angel Pérez Ramos · Jun 12, 2024 go to post

The only way to insert info into a different database is to configure a sql gateway connection by JDBC and execute the SQL with the insert.

Luis Angel Pérez Ramos · Jun 12, 2024 go to post

Just the first line?

set str=##class(%Stream.FileCharacter).%New()
do str.LinkToFile("c:\myfolder\file.csv")
set $listbuild(VALUE1,VALUE2,VALUE3)=$listfromstring(str.ReadLine())
Luis Angel Pérez Ramos · Jun 12, 2024 go to post

%Stream.FileBinaryGzip extends %Stream.FileBinary, so they are practically equals, the only difference is the gzip compression and maybe a read process a bit slower with Gzip than just with FileBinary (and this is more a feeling than a fact).

Luis Angel Pérez Ramos · Jun 10, 2024 go to post

Hi @Michael Wood ! What is the type of context.FHIRResponse.Body? Interoperability with FHIR usually works with HS.FHIRServer.Interop.Response class in wich the JSON FHIR is saved as a Stream.

Could you tell us something else about what are you doing?

Luis Angel Pérez Ramos · Jun 7, 2024 go to post

I'm assuming that every new patient received in a HL7 message has to be created as IRIS user so in the BP I'm creating the user and assigning it to the new task.