#Ensemble

Post a job Follow
23 Followers · 2.4K Posts

InterSystems Ensemble is a complete and easy-to-use integration platform that enables users to connect people, processes, and applications in record

time.

Learn more

Documentation

Post a job Follow
Article Anssi Kauppi · Jun 30, 2020 3m read

Replicating Audit Log Near Real Time

Many organisations implement centralised log management systems to separate and centralise the log data in order to e.g. automate threat detection (and response) and to comply with regulatory requirements. The primary systems of interest are the various user facing applications, but increasingly also other kinds of systems including integration platforms.

What comes to the data platform (not the user facing application) most of the the events of interest/required are available as predefined system audit events in audit log - out of the box. They just need to be enabled.

#Ensemble #InterSystems IRIS #InterSystems IRIS for Health #Data Import and Export #Interoperability #JDBC #ODBC #Security #System Administration #Tips & Tricks
2
2 578
Question water huang · Jan 15, 2024

parse XML to object

hi there,when i use %XML.Reader parse XML to object,if the element value is null,the data in the table is $c(0),how avoid this？

my class file like this:

Class M.PATLIST Extends (%RegisteredObject, %XML.Adaptor) [ Inheritance = right, Not ProcedureBlock ]
{ Property Data As list Of PAT(XMLPROJECTION = "ELEMENT"); Parameter XMLIGNOREINVALIDTAG = 1; Parameter XMLIGNORENULL = 1; Parameter XMLNAME = "DATALIST"; }

Class M.PAT Extends (%Persistent, %XML.

#Ensemble #XML
3
0 322
Question Scott Roth · Jan 13, 2024

Accessing EnsLib.HL7.Message Header properties within a DTL

Within a DTL is it possible to access and update the Message Header properties of an EnsLib.HL7.Message?

Currently we have multiple EMR Services for each environment sending to 1 Business Process to Normalize the data, then it is sent to another Business Process to route the data. 

Since the SourceConfigName changes with every send to a Business Process, I am looking for a way to maintain the SourceConfigName of the SessionID so I know how to direct the message.

#Ensemble #Health Connect #InterSystems IRIS for Health #Business Rules #DTL #HL7
7
0 750
Article Megumi Kakechi · Jan 11, 2024 2m read

What to do with the error 5369: Class is currently being compiled by process

InterSystems FAQ rubric

This error occurs when an instance of the class is already open at compile time.

There are two ways to deal with this issue:

  1. Terminate the process or application that has the instance open
  2. Compile options in the studio build menu: Check the compile flag “Compile classes in use” and compile.  

If you want to determine which process is using the class, try the sample routine below.

/// Test.mac
#Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health #Tips & Tricks
1
0 248
Discussion Stefan Cronje · Dec 15, 2023

CSP Pages versus Classes extending from %CSP.Page

Hi all,

The last time I used CSP was back in 2008, so I am very rusty on it.
This question might have been asked many times, and the answer probably is that it is a matter of preference.

Are there scenarios to which CSP pages is easier/better to use than classes extending from %CSP.Page?
I want to build a little thing and don't want to start at the wrong end.
Doing an API-based, heavy client-side framework is not a requirement, and I would prefer not to do it that way.

Some of the criteria

  • Users need to do a login.
#Ensemble #CSP #JavaScript #ObjectScript
4
0 442
Question Stefan Cronje · Dec 15, 2023

%PARALLEL and Per Process Memory issue

HI *,

So last night I was doing a deployment which had a query to select from a large dataset of joined tables, to iterate through and populate data in a new table.

This was done in a classmethod using embedded SQL and the %PARALLEL keyword.
On a testing environment with the same dataset, this worked perfectly a few days earlier.

It was going to be a long-running process, so we started it from a csession using the JOB command.
Then get the PID with $zchild, go to Processes and monitor it there.
It would terminate after a minute or so with a <STORE> error.
The per process memory is set at 1GB.

#Ensemble #ObjectScript #SQL
2
0 373
Article Megumi Kakechi · Jan 4, 2024 1m read

What to do when a large amount of memory is used while processing relationships

InterSystems FAQ rubric

If a relationship is set and there is a large number of n in a 1:n ratio, a large amount of memory may be consumed due to sequential processing of the relationship.

After referencing a many-sided object in a program and internally swizzling it, simply releasing the variable containing the OREF (deleting it, setting another value, etc.) will not free the many-sided object and the relationship object. This is the cause.

#Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health #Tips & Tricks
0
0 392
Question Mark Scicluna · Jan 3, 2024

CSP variable interaction with JSP

I wish to retrieve data from a cache table and then chart the results using javascript/chart.js.  I have had numerous iterations of the code attempting to do this (none of which worked) and my latest iteration is shown below.  

<html>
<head>
   <title>Cache Server Page</title>


   <!-- Include the Chart.js library -->
   <script src="chart.umd.min.js"></script>
   
<csp:SQLQUERY NAME='resultSet' P1='A'>
select Value, StatsDate from Stats 
</csp:SQLQUERY>


<script LANGUAGE="JavaScript">
// Initialize arrays to store data
var xValues = [];
var yValues = [];
</script>

#Ensemble #InterSystems IRIS #CSP #JavaScript
8
0 436
Article Mihoko Iijima · Dec 28, 2023 1m read

Recompilation of routines after version upgrade

InterSystems FAQ rubric

There is no need to recompile the routines after the version upgrade, but since the version update overwrites %SYS, user-created INT and OBJ format routines (*.INT,*.OBJ) in %SYS will be deleted. Therefore, you need to be careful. 

MAC, INT and OBJ routines with the following names are not deleted.

%Z*.INT, %z*.INT, Z*.INT,z*.INT
%Z*.OBJ, %z*.OBJ, Z*.OBJ,z*.OBJ

Please note that classes/CSPs need to be compiled after upgrading.

However, if you are upgrading to a maintenance release, no compilation is required. For details, please refer to the document below.

#Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #System Administration #Tips & Tricks
0
1 291
Question Jimmy Christian · Dec 21, 2023

How to see complete message in EnsLib.HL7.Message. RawContent is truncated

Hello community,

I am trying to see the complete HL7 message for the class  EnsLib.HL7.Message.

But it is showing the truncated version only.

I also tried to convert to stream

d msg.OutputToLibraryStream(.streammsg)
s newmsg=##class(EnsLib.HL7.Message).ImportFromLibraryStream(streammsg)

While (streammsg.AtEnd = 0) {
     Set len = 1000
        Set tPrintMessage=newstream.Read(.len)
     Write tPrintMessage
}

But when i print it, its not showing complete message.

Any idea or suggestions?

Thank you in advance.

Jimmy Christian.
 

#Ensemble #InterSystems IRIS #HL7 #Message Search
2
1 405
Question Jon Astle · May 5, 2023

Healthshare File Adaptor Don't Delete Source File from Server

Hi I want to utilise the file adaptor to pick up some PDF documents however I must not delete the source files from the server.  I can see that there is a setting in the FTP adaptor to not delete from server but not in the file adaptor.  Is there an easy way to do this or do I just need to create a custom adaptor that copies the files to a working location and records in a tracking global when I have done this so that I don't process the same file twice?

#Ensemble #HealthShare
5
0 510
Question Nimisha Joseph · Dec 22, 2023

Trouble Accessing SendRequestSync() in BPL Code Activity

Hi ,

I'm currently working on a BPL (Business Process Language) in InterSystems Ensemble, and I'm facing an issue when trying to call the SendRequestSync() method within a code activity. My understanding is that SendRequestSync() is part of Ens.BusinessProcess, and since extends , I believe it should be accessible.

However, during compilation, I'm encountering an error stating that the method doesn't exist in the class.

Am I missing something here? Is there a specific way to access in the BPL code activity?

Any guidance or insights would be greatly appreciated!

#Ensemble #Business Process (BPL)
4
0 364
Question Stefan Cronje · Dec 21, 2023

Determining all contending processes on exclusive lock issues

Hi,

The system I am working on processes large numbers of records. Inserts, updates and so forth. There are multiple processes that can potentially work on the same table at the same time. 

It is an almost impossible task to try and time these processes to not run at the same time, due to volumes, SLAs, etc.

Every now and then there are a few locking issues, Not many considering the volumes. It is just a bit of a nuisance as we need to reprocess these records later.

All the selects on the processes run at IsolationMode 0 and the transactions are kept as short as possible.

#Ensemble #Database Transaction Processing #ObjectScript #SQL
6
0 476
Article Mihoko Iijima · Dec 21, 2023 1m read

How to switch between ODBC drivers in an environment with multiple versions installed

InterSystems FAQ rubric

If multiple InterSystems products are installed on the same system, the latest version of the InterSystems ODBC driver among the installed products will remain registered in the driver manager.

You can change to any driver by changing the registry entry below.

 Please note that running RegFiles.bat does not change the ODBC driver.

The registry entry is as follows.

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\InterSystems ODBC35 key Driver
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\InterSystems ODBC35 key Setup
#Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #ODBC #Tips & Tricks
0
0 466
Question Nimisha Joseph · Dec 19, 2023

##Class(%SQL.Statement).%ExecDirect(,,,) in BPL

Hi,

I'm currently working on a Business Process Language (BPL) project where I'm using ##Class(%SQL.Statement).%ExecDirect to execute a SQL query. The query returns more than one row, and I'm facing an issue in handling the result set.

I'm setting the result of the query to context.tResult, but the loop through the result set processes only a single row. I need assistance in correctly setting up my context property or any other approach to iterate through all the rows returned by the query.

Thank you in advance

#Ensemble #Business Process (BPL)
4
0 428
Question Nezla · Dec 17, 2023

Getting free disk Space

Hi Guys,

How to get free disk space, I found that I could use GetDirectorySpace but not sure how to use it in getting free space in my D drive?

Thank 

#Ensemble
2
0 325
Question Colin Brough · Nov 21, 2023

Scheduled task or scheduled message to run a BPL

How do we trigger a BPL Business Process on a time schedule?

We are building a production that takes a steady stream of (HL7) lab results messages, processes them and stores them in a temporary database table. At scheduled points during the day (eg 0800, 1300, 1600) the database is queried and messages sent on to the downstream system. Aiming that the Processes to be implemented in BPL if possible - but we are having trouble triggering code in a BPL as a scheduled job.

#Ensemble #Business Process (BPL) #Key Question #ObjectScript
12
0 804
Article Megumi Kakechi · Dec 7, 2023 2m read

What to do if a <PROTECT> error occurs when importing a routine with %

InterSystems FAQ rubric

To resolve the error <PROTECT>, remove the read-only attribute of the system-wide library database (IRISLIB for InterSystems IRIS, CACHELIB for Caché/Ensemble/HealthShare (Caché-based))

Once you have finished importing the routine, remember to change it back to read-only.
 

[Version 2013.1 and above]
[Management Portal] > [System Administration] > [Configuration] > [System Configuration] > [Local Database] Uncheck "Mount read-only" from the database name link.

[Version 2011.1 - Version 2012.

#Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health #System Administration #Tips & Tricks
3
0 662
Question water huang · Dec 5, 2023

use %XML.Reader to parse XML to object

hi there,when object export to xml,i know that,it will call propertynameLogicalToXSD method,but i can`t find out that use %XML.Reader to parse XML to object  witch method will be called before ,

simple code like this:

Class Samples.NewClass2 Extends (%Persistent,, %XML.Adaptor)
{
Property OPDT As %Library.DateTime;
}

my xml is 

<NewClass2><OPDT>2023-11-30 11:07:02</OPDT></NewClass2>

and how parse it to object ,and not modify the xml?

#Ensemble #XML
4
0 560
Question Glenda Anaya · Jun 9, 2016

Ensemble 2015.2.3 - Certificate is not valid for TLS Web client authentication

Hi,

We recently updated Ensemble, on our Unix DEV server , from version 2013.x to 2015.2.3 (Build 855U) and when we test our SSL/TLS configuration we get the following error:

ERROR #729: Certificate /qmd/ens_chldev_1/mgr/SILCert/SILCSSSJR-CER.cer is not valid for TLS Web client authentication .

The certificate was working fine before the update in DEV and it is working fine in our PROD Unix server with Ensemble 2012.x.  Any ideas why we are getting this error?

Regards

#Ensemble #SOAP
5
0 2406
Article Mihoko Iijima · Nov 30, 2023 3m read

How to programmatically retrieve a list of user-created classes

InterSystems FAQ rubric

Class definitions created by users are stored in class definition classes. They can be used to obtain a list of class definitions from a program.

Note: Class definition classes refer to all classes contained in the %Dictionary package.

In the sample code below, a list of class definitions is obtained using the query Summary of the class %Dictionary.ClassDefinitionQuery.

ClassClassMethod#dim

An example of execution is as follows.

#Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #Object Data Model #Tips & Tricks
2
0 668
Question Nezla · Dec 3, 2023

Getting posted JSON in a service production

Hi Guys,

I have a client posting me JSNON file using a Get action and I'm using the below code to retrieve the data:

Class SX3.Production.HTTP.GetPSRequest Extends Ens.BusinessService [ ClassType = "", ProcedureBlock ]
{ Parameter ADAPTER = "EnsLib.HTTP.InboundAdapter"; Method OnProcessInput(pInput As %CharacterStream, Output pOutput As %CharacterStream) As %Status
{
    Set pOutput=##class(%GlobalCharacterStream).%New()
    Set tSC=##class(Ens.Util.JSON).ObjectToJSONStream(pInput,.tJsonPayload,"aceloqs")
    set jsonString = tJsonPayload.

#Ensemble
6
0 336
Question Nezla · Nov 30, 2023

Production allowed ports

Hi Guys,

Do we need to configure something in ports so that we can use it in a production?

I've a production with 8 running services and recently added a new service with new port but unable to get it working  

raising error 404.

When using an existing port that is used by current running service, my new service works fine but not when using a new port, I've added the new port to inbound rules in the firewall bit still no luck, so is there something I need to do to in Ensemble ?

Thanks

#Ensemble
3
0 288
Question Nimisha Joseph · Nov 23, 2023

SQL Query in BPL

I'm pretty new to ensemble.I'm working on a BPL process where I need to retrieve a result set from an SQL activity, loop over the results, and call a web service. I'm having trouble passing the request parameter(Labtype) into the SQL query for the WHERE condition .Can any one suggest how to loop over the result set as well.Any suggestions on how I can achieve it?

#Ensemble #Business Process (BPL)
7
0 565
Article Enrico Parisi · Nov 18, 2023 3m read

Add OS command execution to WebTerminal

 I think WebTerminal is an outstanding project, kudos to @Nikita.Savchenko7047

One useful functionality is missing, the the ability to run Operating System (Linux or Windows) commands.
In many cases WebTerminal is used when access to the OS is difficult, so having the ability do run simple OS commands from WebTerminal would be a big advantage.
Using "normal" terminal, be it Windows IRIS console, Windows Telnet or within "iris session" in linux is simple, from the IRIS terminal prompt just precede the OS command with "$" or "!".
See the article "Terminal tip: Running OS-level commands" from @John.

#Caché #Ensemble #InterSystems IRIS #Terminal
1
0 447
Article Megumi Kakechi · Oct 19, 2023 2m read

How to know the size of database cache (global buffer) in use

InterSystems FAQ rubric

A tool (^GLOBUFF utility) is available to check the database cache usage for each global variable.

You can run the utility directly or programmatically in the %SYS namespace.

Here's how to run the utility directly:

USER>zn "%SYS"
 
%SYS>do ^GLOBUFF
 
Find which globals are using the most buffers.
 
Display the top <25>:     → Press Enter  // Default is to display top 25 globals
 
Total buffers: 102400     Buffers in use: 6926     PPG buffers: 77 (1.
#Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health #ObjectScript #Tips & Tricks #Tools
5
1 995