The latest "Bringing Ideas to Reality" InterSystems competition saw me trawling through the ideas portal for UI problems to have a go at. 

Hello Community,

Is there any way to permanently clear all the commands displayed in the line recall History. The :clear deletes all the commands in that particular process/recall buffer.

Thanks!

Hello All,

I am facing an issue where the vendor seems to be sending two structures of JSON messages, but only one of them seems to work in my code.
I need help in allowing both the JSON structures to parse into the engine.

Working Example:

{
    "data":
        {
            "idNumbers":
            [
                {
                    "type":"322","number":"123456"
                }
            ]
            ,"0":
            {
                "con_type":"210"
            }
        }
    ,"meta":
    {
        "secret_key":"","origin_url":"url.co.uk"
    }
}

Not Working:

Context: Extra Square Brackets causing

Hello, 

We noticed from the integrity logs that some of the namespaces in our integration engine are using large amount of space ( ~380GB ) for the global ^EnsHL7.Segment. 

We have culling implemented for large globals like MessageHeader and MessageBody.

Is it a standard process to implement culling for ^EnsHL7.Segment global and any idea about what will be the impact of adding culling to this global?

Not sure if it is possible to implement normal culling task on this Global as I noticed this global content is not accessible via SQL functionality in Management page but only via the Globals in

Like many others probably find themselves, we were stuck doing live data mapping in our Interface Engine that we really didn't want to do, but had no good alternative choice. We want to only keep mappings for as long as possibly needed and then purge expired rows based upon a TTL value. We actually had 4 use cases for it ourselves before we built this. Use cases:

By "unsuccessful installation" I mean IRIS Community Edition for Healthcare is not running and the server won't start after a fresh installation.

The events in the Events Viewer are not particularly informative, but the messages.log file suggests it's shutting down on start up because the laptop has "too many Cores" - which it true, it has 24 of them (it's pretty beefy, a Lenovo Legion gaming PC that I use on account of its specs for AI development).

I'm trying to project a series of objects and nested objects to XML, and I'm having difficulties getting the XML representation exactly the way I need it to be. Here's what I'm working with, nothing complicated:

Class XMLTest Extends (%RegisteredObject, %XML.Adaptor)
{
    Property Id As Id;
}

Class Id Extends (%RegisteredObject, %XML.Adaptor)
{
    Property Value As%String (XMLPROJECTION = "attribute");
}

By default it seem closing tags are used with all elements, as such:

<XMLTest><IdValue="D1949EE1-7D03-4666-9548-D1A949E10327"></Id></XMLTest>

Whereas I need these elements

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Copilot for Flask FHIR SQL Builder

InterSystems is announcing an end of maintenance event for Zen Reports beginning in Intersystems IRIS and IRIS for Health 2025.1.  This follows the deprecation notice made when InterSystems IRIS was introduced in 2018 and subsequent inclusion of InterSystems Reports in 2020 to provide replacement reporting functionality.  An overview of the timeline is:

March 2018.   InterSystems IRIS 2018.1:  Announcement of Zen Reports deprecation, continued shipment to provide continuity for existing applications

April 2020.

Hi Community!  We’ve added some new rewards on Global Masters — just in time for the holiday season!
Take a moment to explore the Rewards section and see what’s new 🎅
 
Not a Global Masters member yet? Join here using your InterSystems SSO credentials.

I need to do an audit of Linked tables which are using a specific SQL Gateway connection, and there are many.

This is defined by the parameter CONNECTION contained within the table class which extends Extends %Library.Persistent

Is parameter exposed within a table somewhere?

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Boost Your Productivity with Command History & Shell Aliases in InterSystems IRIS

I am developing locally on my IRIS instance using VSCode and client-side editing approach. How can I automatically export a single .cls file/a whole package to a remote TEST/PREPROD server using a script or command line and recompile the unit remotely? Are there any more simple and straightforward ways than CI/CD explained in the series of articles by Eduard?

Hi everyone,

I’m using EnsLib.SQL.OutboundAdapter in my InterSystems Ensemble operation to execute an insert statement in Sql Server Management Studio 20. While inline queries (e.g., constructing the query string with _ concatenation) work fine, I'm facing issues when trying to use parameterized queries.

Serialized JSON: {"CHI":"2894","Forename":"Janis"}

Include Ensemble

Class TNHS.Operation.RDS.PatientOperation Extends Ens.BusinessOperation{

Parameter ADAPTER = "EnsLib.SQL.OutboundAdapter";Property Adapter As EnsLib.SQL.OutboundAdapter;
Method OnMessage(pRequest As

We have error - ERROR #5821: Cannot instantiate query: 'SQLCODE = -146, %msg = Error: '' is an invalid DISPLAY Date value' not able to see what is causing:

CASE When P.PatReltoGuar->Name = 'SELF' then  P.Lnm  Else  Substring(P.GuarNmIfNotPat, 1,Charindex(',',P.GuarNmIfNotPat)-1) End  as DemoGuarLastName,

CASE When P.PatReltoGuar->Name = 'SELF' then  P.Fnm  Else Substring(P.GuarNmIfNotPat,Charindex(',',P.GuarNmIfNotPat)+1,LEN(P.GuarNmIfNotPat)) End  AS DemoGUARFIRSTNAME,

CASE When P.PatReltoGuar->Name = 'SELF' then P.StreetAddrL1 Else P.GuarStreetAddrL1 End as DemoGuarAddresslineOne,

CASE When

s connection = ##class(%Net.Remote.Java.JavaGateway).%New()
s sc = connection.%Connect("127.0.0.1",53274)
s classpath="C:\Users\ME9Y1PM\Downloads\wrapper_jar\wrapper-drools-1.0.0-20241127.071529-1.jar"
if (sc=$$$OK) {
s SCJavaDroolsObj.connection=connection
s sc = SCJavaDroolsObj.connection.%Import("com.lca.smc.drools.DroolsRules")
s SCJavaDroolsObj.drools = ##class(com.lca.smc.drools.DroolsRules).%New()
d SCJavaDroolsObj.drools.applyRules(patientjson)

Class com.lca.smc.drools.DroolsRules Extends %Net.Remote.Base [ ProcedureBlock ]
{Parameter IMPORTTIMESTAMP As STRING = "2024-11-29 09:14:27.992";

I installed IRIS 2024.3 on Oracle Linux 9, but I have a problem accessing HTTP://myip/csp/sys/UtilHome.csp. I received the FORBIDEN from Apache.

I tried to configure a Directory block on httpd.conf, the login page was opened but images didn't show and the login doesn't work

<Directory "/InterSystems/iris/csp">
        CSPFileTypes csp cls zen cxw
        AllowOverride None
        Options MultiViews FollowSymLinks ExecCGI
        Require all granted
        <FilesMatch "\.(log|ini|pid|exe)$">
                Require all denied

        </FilesMatch>
</Directory>
Can you help?
 

Ho Ho Ho, Community!
The integration between Global Masters, the Developer Community, Open Exchange, and the Ideas Portal has now been restored!
The points should now be updated for all contributions made during the downtime of Global Masters.
Please note that we’ve made several adjustments to the awarding system, we will announce the changes soon.
A bug affecting badges for the number of views was detected, so we had to manually update the points for some of you.
If you have any questions about your points or notice any discrepancies, please don’t hesitate to reach out.

 
Not a Global Masters

Iris for Health is sending back ACKs back to the vendor for incoming X12 messages but, they are not making it there. Instead, the vendor is getting Reset packets and it seems they are coming out from Iris for Health. 

Questions:

1. Does Iris indeed generates Reset Packets? 
2. What causes Reset Packets to be triggered?
3. What settings does InterSystems recommend to not send Reset packets? 
4. Are settings needed in the BS to prevent Reset Packets?

I already tried different settings unsuccessfully, and read much of the instructions provided by Intersystems but, we still can't resolve this issue.

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ How to Reach 99.99% Uptime on the Cloud @ Global Summit 2024

Interoperability of systems ensures smooth workflow and management of data in today's connected digital world. InterSystems IRIS extends interoperability a notch higher with its Embedded Python feature, which lets developers seamlessly integrate Python scripts into the IRIS components, like services, operations, and custom functions.

Why Embedded Python in IRIS?
Embedded Python brings the flexibility of Python into the powerful world of InterSystems IRIS and provides the following: Access to Python Libraries: Leverage popular libraries such as pandas, NumPy, and requests for advanced data

InterSystems Package Manager 0.9.0 Beta

I am excited to announce the upcoming release of InterSystems® Package Manager (IPM) version 0.9.0. This has possible impact for all users of IPM and we would welcome the community’s feedback prior to release.

How can I get involved?

As an important note, this is a beta and not yet recommended for use in production. You can find the latest v0.9.0-beta.x release at https://github.com/intersystems/ipm/releases. Under assets, there’s a file named zpm-0.9.0-beta.x.xml.

When making calls through the Dev Portal, we have observed that port 8003 is being used in the construction of URLs, as demonstrated in the attached image. However, requests should be directed to port 8000. This behavior consistently results in the error shown in the image.
Is it possible to change the port generated in the URL?

About Kong Version 3.2.1.0  

In principle I'm looking in forward direction.
Though from time to time it makes sense to turn back and see the full path taken.

• I started reporting my reviews almost 4 years ago. 
• I just reviewed packages that I could reproduce in my environment.
• Skipping items beyond my physical or mental capacities.
• So some great packages might not be present here
• But I added also 139 contributions of other reviewers
• It was anyhow a total of  769 reviews published
• Meeting over this time 191 different authors

So, we have docker image webgateway-nginx, marked as latest-em, which means supposed to be extended maintenance

$ docker run -it --entrypoint bash containers.intersystems.com/intersystems/webgateway-nginx:latest-em

root@9ca3373fe980:/# /opt/nginx/sbin/nginx -V
nginx version: nginx/1.21.5
built by gcc 11.4.0 (Ubuntu 11.4.0-1ubuntu1~22.04) 
built with OpenSSL 1.1.1n  15 Mar 2022
TLS SNI support enabled
configure arguments: --prefix=/opt/nginx --with-pcre=/opt/pcre-src --with-zlib=/opt/zlib-src --with-openssl=/opt/openssl-src --with-http_gunzip_module --with-http_ssl_module

Is there any mechanism already implemented in IRIS to prevent XSS exploits ? 

This case happen when user input html/javascript content into fields and submit the page. If saved content is rendered as is, it's going to be executed by anyone visiting the page.

What I am looking for : 

• Built-in protection mechanisms that can be enabled globally (eg: per web application) or per CSP page. Something similar to a web application firewall.
• Functions to call manually that can detect such content in fields or sanitize them (remove unwanted content).

Hey Community,

It's time for the new batch of #KeyQuestions from the previous month.

If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you made a major change and expect a changed review just let me know.

First time trying to use Foreign Tables/Servers instead of Linked Tables...

Within the SQL Editor inside of the Managment Portal, or connecting through DBeaver JDBC how we can see what Foreign Servers have been defined? Is there a way to query and verify structure of the Foreign Server connection to know that we are building the correct Foreign Tables?

I attempted to create my first Foreign table but it failed when I tried to query the tables because it said the table could not be found. But when I sign into the Database via SQL Management Studio, I can see the table.