Does IRIS for Health support Java 21?

Is there any recommended KPI's we should be using to monitor our IRIS configurations in Azure?

Does InterSystems have any best practices for deploying IRIS into Kubernetes? For example one question we have is should IRIS have a dedicated AKS cluster or can it be added to an existing cluster?

David

Has anyone integrated IRIS with Azure AD? Any tips or guidelines you can provide are appreciated.

David

We are seeing performance issues in purging objects/tables that have parent-child relationships defined. Due to the number of child objects we're seeing very long duration to purge a single parent and all child tables. Is there a better way to do this and get a more performant purge task? I was thinking to purge the child tables individually first and then delete the parent is one way. Is there any other approach?

David

Is there an undocumented class method that will output the FQDN?

$SYSTEM only reports the part of the name concatenated with the namespace. Checking $SYSTEM.INetInfo doesn't provide the full DNS name, only a partial value that matches $SYSTEM.

I can do a call out to the OS to get that value which seems to be the only way I can get the value.

I have a class that has 2 different cursors for different queries, audit1 and audit2. which are in 2 different methods. The first query runs fine, but the second one generates a 102 error.

Is there an issue with having more than 1 cursor in a class?

Has anyone seen this before?

I have a couple of questions regarding /api/monitor and configuring it to use with SAM. In our environment we only expose port 443, so even though I define the Web Application to use unauthenticated, SAM is unable to make a connection. Is there any alternatives to get this working?

Also, even if  there is a way to configure using port 443, unauthenticated access will never fly in our environment. Are there any plans to enhance SAM so it you use OAuth or even mutual TLS?

Dave

Is there a helper class available that will import an XML class and convert the class to UDL?

David

Will the Atelier plug-in work with newer versions of Eclipse?

Photon is getting a bit old and I'd like to use the latest version.

One additional question; Does Atelier work with JDK 11?

Dave

Is there a way to get a good performing index on a date field? I have tried various date property indexes and the query plan is always in a pretty high range. Below are query plan result values I have observed:

   StartDate > '2019-12-01'  --cost = 699168
   StartDate = '2019-12-21'  --cost 70666
   StartDate between '2019-12-21' and '2019-21-28' --cost = 492058

The query plans above were for type %TimeStamp.

Prior to IRIS, using ECP to share databases under heavy I/O load has known latency issues (in our environment), which pretty much restricted using shared database with relatively static or slow-changing data. In IRIS, will sharding mitigate the latency issue and allow any table to be shared?

David

Is %CSP.BinaryStream compatible with %StreamGlobalBinary because reviewing the classes this doesn't look to be the case?

What I am trying to do is zip large documents before sending over a REST interface. I compress the file and add that to an Ens.StreamContainer which is then passed to the operation to build the REST payload. We are using %Net.MimePart class to build the payload and use the BodySet method to add the zipped Ens.StreamContainer.

The issue is when the REST interface receives the POST, it doesn't recognize the data as a zip compressed item.

Is there any issue with setting the Pool Size > 1 on components using EnsLib.FTP.PassThroughOperation? I have a component that has 60,000 documents in the queue and looking for way to process this output quicker.

Has anyone done any integration with Kafka, especially prior to IRIS? If yes what was your experience such as specific pain points to be overcome.

David

For the FIleSpec on a file service can you use a multiple wildcard values like *CLINICALENCOUNTER*.xml?

It seems like you are restricted to a single wildcard value.

I am trying to use %INLIST in  SQL query using a cursor and the query fails to return results. It appears that the variable I use against %INLIST returns an empty string. All the examples I have seen use result sets and build the query as a string. Is it possible to use %INLIST in a cursor-based query? Below is a a snippet of the code I am using:

Property mylist as %String (MAXLEN="") [InitialExpression = "route1, route2, route3"];

set routeList = $LISTBUILD(mylist)

&sql(DECLARE MyReport CURSOR FOR

SELECT

      ProcessStartDate,

      ProcessCompleteDate,

      ProcessName,

     RouteName

FROM

I have created a view to stage some data in a different format and then want to reference that view in a SQL query from a table that filters the data from the view using a property of the table. 

Example:

select
   MsgId,
   FileName,
   (select
      ReportName
     from
      custom_view
     where
       MsgId = ReportId
    ) as ReportName
from
   main_table

Is this even possible? When I try this, I get an error table not found for the view?

David

Is there a way to use linked tables between 2 discrete Cache databases or is linked tables just for access to an external RDBMS?

David

Is there any out of the box capability in Ensmeble to remove an FHS segment from a batch file? We have a client that is creating a batch of HL7 messages and they insert an FHS but there is no trailing FTS.

We are hoping to avoid custom COS code to handle this scenario.

Atelier is no longer working for me. I am getting the following error: Could not create the view: com.intersys.eclipse.ui.views.CacheExplorer.

Expanding the details available shows the following below. Has anyone seen this and know how to fix it? I uninstalled and reinstalled the Atelier plug-in but that did not help.

I have a need to restrict some developers access to Message Viewer in a namespace without restricting their ability to create or modify productions components. Is there a way to do this? It's not clear from the documentation.

Has anyone done any kind of integration with Dynatrace, which is a JVM transaction monitoring tool? Our organization uses this extensively with our Java and .Net applications and we wanted to know if it is even possible.

Is there anything native in Ensemble that will support converting HL7 to PDF?

I see there are numerous examples in .Net and Java for this capability.

Dave

Just starting to use Atelier and having problems with making server connections. I have tried both the super server port and the web server port and both fail with either Unexpected end of file from server (Secure connection disabled) or PKIX path building failed (Secure connection enabled). On a different server I get Connection refused: check the web server configuration.

Anyone run into this before?

Has anyone done an ebXML implementation using the out of the box classes?

I would like to hear about your experience and any issues you encountered using the classes provided.

I am getting the following error periodically:

CP: Pausing users because the Write Daemon has not shown

Is there any issue with using a pool size setting greater than 1 for an  inbound file service? The reason I ask is we can easily dump 100k+ files to a folder in minutes, but using a pool size of 1 can take hours for that backlog to clear.

If our SVN repository already is storing discrete .cls files, does Atelier do any conversion when we load from SVN into our server instance? 

At what point would I see .udl files? I am thinking I would only see that if SVN was storing .xml and each of those would be converted to .udl.

Can you assign the SessionId to a target field in a DTL. There is a %Ensemble("SessionId") variable that looks like it would be available to use.