I have issue with one of my queries. That query work fine for ages, but suddenly stop works and giving me SQLCODE 100 in the routine.
&SQL(SELECT * FROM (
SELECTeventFROM dhr_log_lasers.production WHERE createDateUTC >= DATEADD(dd, -5, CURRENT_DATE) AND kiosk = :%var("kioskID") GROUP BY machine
HAVING ID = MAX(ID)
) WHERE event != 2
)If I copy this same query to the management portal and replace variable with real ID I will get back 6 or more rows.
✓ 377 new members joined in November
✓ 14,137 posts published all time
✓ 14,326 members joined all time
I want to integrate IRIS with Keycloak OAuth2 provider to use delegated authentication everywhere and to secure everything - sys*/Portal applications, REST services, FHIR server and so on. If an unathenticated user tries to access any IRIS URL - he or she should be redirected to Keycloak. After the user has successfully authenticated, i would like to access his requistes (username, email, roles, scopes) extracted from the JWT token, programmatically. What should be done to achieve that? I found this repo but it seems a bit tricky to implement a custom ZAUTHENTICATE function which has an access
I'm trying to call a SOAP web service which is implemented in .NET Classic and requires NTLM authentication. The client class was generated by %SOAP.WSDL.Reader. The problem is that neither NTLM authentication works nor can I handle the exception since VSCode debugger says that all meaningful fields and properties are empty (the same request works fine in Postman):
Hi Community,
Enjoy the new video on InterSystems Developers YouTube:
Hi Guys,
I have images in my zen report, eg.
<table orient="row" width="100%">
<item value="Images:" style="font-weight:bold;font-size:0.9em"/>
<img src="./images/wo/Bearing.jpg" id="WOImage" align="right" height="20px" width="250px"/>
</table>
and if I run the report to the screen the report with its images comes up fine
but I need to generate and save the report as pdf to a specific path, so I used the below code and it generates the pdf report but the no images, so how can get my report with images?
FYI, I do have those images in a file location and also streamed in a database.
When it comes to build an iris image, we can use the cpf merge files.
Here is an cpf merge example:
[Actions]
CreateDatabase:Name=IRISAPP_DATA,Directory=/usr/irissys/mgr/IRISAPP_DATA
CreateDatabase:Name=IRISAPP_CODE,Directory=/usr/irissys/mgr/IRISAPP_CODE
CreateNamespace:Name=IRISAPP,Globals=IRISAPP_DATA,Routines=IRISAPP_CODE,Interop=1
ModifyService:Name=%Service_CallIn,Enabled=1,AutheEnabled=48
CreateApplication:Name=/frn,NameSpace=IRISAPP,DispatchClass=Formation.REST.Dispatch,AutheEnabled=48
ModifyUser:Name=SuperUser,PasswordHash=a31d24aecc0bfe560a7e45bd913ad27c667dc25a75cbfd358c451bb595b6bd52bd25c82cafaa23ca1dd30b3b4947d12d3bb0ffb2a717df29912b743a281f97c1,0a4c463a2fa1e7542b61aa48800091ab688eb0a14bebf536638f411f5454c9343b9aa6402b4694f0a89b624407a5f43f0a38fc35216bb18aab7dc41ef9f056b1,10000,SHA512
Hi, Community!
Are you using InterSystems Cloud Services? Take a tour of the central hub for managing your services and deployments:
The ability to resend messages easily has always been a strong feature of our Interoperability capabilities.
With v2024.3 coming out soon (available already now as Developer Preview) out already we've made this even easier!
The 2024.3 release of InterSystems IRIS® data platform, InterSystems IRIS® for Health, and HealthShare® Health Connect is now Generally Available (GA).
In this release, you can expect a host of exciting updates, including:
The rise of Big Data projects, real-time self-service analytics, online query services, and social networks, among others, have enabled scenarios for massive and high-performance data queries. In response to this challenge, MPP (massively parallel processing database) technology was created, and it quickly established itself. Among the open-source MPP options, Presto (https://prestodb.io/) is the best-known option. It originated in Facebook and was utilized for data analytics, but later became open-sourced. However, since Teradata has joined the Presto community, it offers support now.
Hi Guys,
I've installed the latest IRIS 24 and trying to setup the Smart Factory Starter pack following the link below and would like to confirm a few things:
GitHub - intersystems/InterSystems-IRIS-Smart-Factory-Starter-Pack: ASP - OEE Dashboard
So I created a new OEESP with its database in IRIS, then the second step is to install PythonGatway but doesn't that come out of the box with IRIS latest versions? if not, it says I must install Python 3.6.7 which doesn't exist anymore
Stay Updated with Notifications on Open Exchange!
You can now view all your notifications directly on the website and choose how you’d like to receive them—on the web, via email, or both.
Here’s what you’ll be notified about:
Hello. On some hosts, IRIS in containers.intersystems.com/intersystems/iris-community:2024.1 falls with a core dump.
auser:~$ docker run --rm -it --entrypoint="" containers.intersystems.com/intersystems/iris-community:2024.1 bash
irisowner@6170dcdbe77c:~$ iris start IRIS
Illegal instruction (core dumped)Coredump stack:
(gdb) bt
#0 0x000055688cf44743 in osregopen ()
#1 0x000055688cf4060a in ListConfig ()
#2 0x000055688cf3dcd7 in main ()Are there some hardware requirements for IRIS docker container? Or maybe some specific settings?
Host details:
What settings do I need to just passthrough an X12 messages from a BS to BO and out the BO without modifying the message?
Currently, we are receiving the X12 messages but, it seems Iris is modifying it by "hiding" some segments like the ISA segment. The message goes out the BO modified and it doesn't reach its destination. Since I just want to pass it through, there is no BP, DTL, or Rule processing the message. Message is received by the BS and sent directly to the BO.
My current settings:
Hi Community,
Enjoy the new video on InterSystems Developers YouTube:
⏯ Adapt AI to your Existing Architecture @ Global Summit 2024
I am working on a product that uses REGEX and matches it.
The regex is tested both on the client-side (using the JavaScript REGEX engine) and both on the server-side.
But I couldn't find one word about the way intersystems parses the regex, It is quite elementary to state which which engine it works with.
from what I could gather from early implementations and such, the engine is based off PCRE, But I need to confirm this somehow, Can anyone give me a definitive answer, Is there any tool to test the regex other than writing it myself??
Hello Community,
I'm starting to explore OAuth2 and, as a first step, I want to set up an OAuth2 authentication with Microsoft. I've created a small sample page that attempts to sign in with Microsoft. However, after entering the user credentials, the redirection doesn't work.
Greetings dear community members!
I have recently been deploying an IRIS for Health image on a Docker with a preconfigured Webgateway image and I have come across the problem of the SSL configurations that allow us to connect to the IRIS instance using HTTPS and going through our Webgateway.
Until now I had always deployed IRIS for Health with a Community license, which still has the Private Web Server installed, so I only needed to configure the Webgateway connection with the deployed IRIS instance:
Good day,
Sinds 20 november 2024 We have getting an error in Production when execute query in Postgres .
FOUT #5023: Fout in Java Gateway: JDBC Gateway getClob(0,2) errorRemote JDBC error: Bad value for type long : Sneeuwheide
Best Regards
Eduard
Hence the question: is there a way to do that?
The goal is to get data (from half a thousand to 3-4 thousands lines) from DB, calculate standart deviation then use it as logical condition in analyzer.
For example IF std > custom_value = show_the_result ELSE null
There is a STDDEV(MDX) method used in Analyzer but it is a measure and it can not be used as logical condition (correct me if i am wrong)
I finally figured out how to get JWT token using set x = ##class(%SYS.OAuth2.Authorization).GetAccessTokenClient("medbank","openid fhirUser",.prop,.err).
I also found iris-fhir-client app on Open Exchange. I registered Epic sandbox server, but I cannot list resources. I suspect I need to integrate authorization / authentication. How do I do this with irisfhirclient py?
Hi, Community!
We've had several new ideas from the Ideas portal implemented and thought that you might be curious to learn more about them in our series of articles dedicated to Implemented ideas 😉
So help us choose the ideas you want us to write about in the poll below.
Working on a project where I'm needing to make FHIR calls from my HealthConnect Interop production to Epic.
My issue is I'm not able to construct a valid JWT for the OAuth token retrieval that Epic will accept. I have the below code where I'm able to create a valid header and payload that I'm base64URL encoding and then trying to sign with my .pem private key file. However, Epic is not liking the signature portion of my JWT.
On 4 December 2024, System Alerting and Monitoring (SAM) will be removed from the InterSystems download sites, the container registry, and documentation site.
InterSystems announced last year that it has ceased further development of SAM and simultaneously labelled it as deprecated. InterSystems will continue to support existing customers using the technology in the same manner as product versions beyond the Minimum Supported Version window.
Hi Community,
Enjoy the new video on InterSystems Developers YouTube:
⏯ Big Data, AI and ChatGPT in Healthcare @ Global Summit 2024
Has anybody encountered this before?
I did a very usual hl7 adt transformation DTL, but it is with a customized schema, like ADT_ALL, it is a structure that tries to cover all the ADT schema scenario so we can use 1 type for all ADT messages.
the DTL tests fine in DTL test, with all the segment transformed correctly, but once I put it to test, to send message through source and the message after transformation can only go to MSH, EVN, but won't transform other segment like PID etc.
Let's say I open a stream/file.
If it's not in UTF8 i need to call $ZCVT, and if it's already in UTF8, then I don't need to call $ZCVT.
Is there any way to determine character encoding for input stream/file?
This demo has an interoperability production with 16 items. 
The first part of this demonstration consists of sending an HL7 SIU file which will be transmitted to the 2 other HL7 flows (HTTP and TCP), and transformed and transmitted to the Kafka server. HTTP and TCP flows will transform HL7 messages in the same way before sending them to Kafka as well.
Hi everybody,
I'm modifying a REST interface for a client but it seems impossible to me to modify HTTP Response Status and including custom HTTP Headers either.
My dispatch class (extending %CSP.REST) is contacted through a POST request and the latter is processed in a custom class (extending %CSP.REST as well) accessed as shown in the example below:
<Route Url="/test" Method="POST" Call="Custom.Test:Process" />
Within the processing class I tried executing the following statements with no success:
Do%response.SetHeader("totalcount",totalcount)
Set%response.Status = ..#HTTP400BADREQUEST
