Question Oliver Wilms · Jan 11 Convert HL7 message to JSON Hello, I tried to convert HL7 message to JSON in a business process and I got errors. Has anybody converted HL7 to JSON? Are certain characters not allowed in JSON? I just tried to set a property to quote request.RAWContent and quote. I will try to put example in GitHub and share here later. #HL7 #JSON #InterSystems IRIS for Health 0 5 0 306
Question Oliver Wilms · Jan 10 When we deploy IRIS cluster using IKO, can we add async IRIS instance outside of the cluster? Hello, we deploy IRIScluster using IKO on Red Hat OpenShift deployed in AWS. For DR, we have another AWS region on stand by. We do daily backups. I run a standalone IRIS in the second region. I want to add it as async member to the mirror to have some essential data available in the standby region. Is this possible? #Kubernetes #Mirroring #InterSystems IRIS 0 5 0 162
Question Oliver Wilms · Dec 27, 2023 Does InterSystems REST service creation support swagger API version 3? Does Using the %REST.API Class work with Swagger OpenAPI version 3? I got an error when I tried it on IRIS 2022.2 ERROR #8738: Correct OpenAPI 2.0 version was not specified: . <$.swagger> #API #InterSystems IRIS 0 1 0 134
Question Oliver Wilms · Apr 13, 2023 Read a long Stream into JSON Dynamic Object - MAXSTRING error I am trying to read binary data from HTTP Request Stream and build a Dynamic Object with multiple properties. I am getting MAXSTRING error with this code: #JSON #InterSystems IRIS 2 5 0 448
Question Oliver Wilms · Mar 21, 2023 ERROR <Ens>ErrBPTerminated: Terminating BP JSON2HL7 # due to error: ERROR #5035: General exception Name 'Parsing error' Code '3' Data '' > ERROR #5035: General exception Name 'Parsing error' Code '3' Hello, I want to show a fellow DC member how to convert JSON file into HL7 message. I personally do not work with HL7. I set up a production with EnsLib.File.PassthroughService. It passes Ens.StreamContainer to BPL process. I call a DTL to transform StreamContainer to HL7 message. I run into an error: ERROR <Ens>ErrBPTerminated: Terminating BP JSON2HL7 # due to error: ERROR #5035: General exception Name 'Parsing error' Code '3' Data ''> ERROR #5035: General exception Name 'Parsing error' Code '3' Data '' The code is in this GitHub repo: #Business Process (BPL) #DTL #HL7 #JSON #Ensemble 0 2 0 425
Question Oliver Wilms · Feb 5, 2023 Error reading messages.log file using Embedded Python in iris-log-viewer I copied a 5 MB messages.log file to AWS where I have iris-log-viewer app deployed. I ran the test to see how it takes in IRIS code to import the lines into a persistent table: IRISAPP>set m5mb="/home/irisowner/irisdev/messages.old_20221231.log" IRISAPP> IRISAPP>do ##class(otw.log.irislogreader).Test1(m5mb)Test1 begins at 02/05/2023 12:49:30ReadLogLines/home/irisowner/irisdev/messages.old_20221231.logOpenTest1 ends at 02/05/2023 12:49:34Test1 execution time: 3.500789 select count(*) from otw_log.Log 63239 #Embedded Python #InterSystems IRIS 0 7 0 198
Question Oliver Wilms · Jan 6, 2023 IRIS Interoperability shutdown Has anybody tried to write custom code to empty out queues when Interoperability shuts down? We run IRIS in Kubernetes cluster and we have compute pods scaling up and down. We have Message Bank operation to keep all messages in one place. We want to see all messages in Message Bank. #Ensemble 1 3 0 236
Question Oliver Wilms · Nov 23, 2022 What is the likelihood of encountering "missing messages" in message bank? My team works on implementing an Interoperability solution utilizing InterSystems Kubernetes Operator on Red Hat OpenShift container platform. We are trying to determine how many messages we can process in any given time. We have a Feeder app running in 10 containers sending 50k messages each to a load balancer all beginning at the same time. Messages are received via HTTPS protocol by webgateway containers. Interoperability production runs in compute pods with persistent data, journals, and WIJ volumes. #Containerization #Enterprise Message Bank #InterSystems IRIS 1 1 1 389
Question Oliver Wilms · Sep 11, 2022 BuildKit does not work in Online demo Hello, Community, I tried to deploy online demo for interoperability-test app. I see it errored because BuildKit is not available. Can the Docker be configured to support BuildKit? #Contest #Docker #Open Exchange 0 3 0 152
Question Oliver Wilms · Aug 12, 2022 Password requirements Many password requirements can be enforced using a password validation routine which is available to implement in System Management Portal. But how about this one: Check that at least 50% of the characters changed from old password to new password. We need to have access to the old password to check this, currently password validation routine only gets the new password. #Access control #Authentication #InterSystems IRIS 0 1 0 267
Question Oliver Wilms · Jul 12, 2022 IRIS as a backend database for Java application Hello, I work on deploying IRIS using Kubernetes operator and Red Hat OpenShift. I encouraged another team working on Java application to consider using IRIS as database. My team deployed IRIS cluster using two mirrored data pods for the other team. The other team asked me for the connection information. To learn how to use Java with IRIS, I attempted to deploy two apps from Open Exchange: https://openexchange.intersystems.com/package/CRUD-GLOBALS-IRISNATIVEAPI... #Application Server #Java #JDBC #InterSystems IRIS 2 1 0 207
Question Oliver Wilms · Jul 10, 2022 login failure I am still working on iris-for-money app: https://github.com/oliverwilms/iris-for-money Account.csp posts a rest call with _SYSTEM username and the password. xhttp.open("POST", "/restapi/sql/" + query, true,"_SYSTEM","SYS");xhttp.send(); /restapi web application has Password Authentication Method enabled. SYS is the correct password for _SYSTEM user. I do not understand why I see login failure in Audit database. #Authentication #CSP #REST API #InterSystems IRIS #Open Exchange 0 1 0 243
Question Oliver Wilms · Jul 9, 2022 ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation I am working on iris-for-money app: https://github.com/oliverwilms/iris-for-money Account.csp posts a rest call with _SYSTEM username and the password. xhttp.open("POST", "/restapi/sql/" + query, true,"_SYSTEM","SYS");xhttp.send(); The error is logged in Riches.REST for this line: Set tSC = tStatement.%Prepare(pQuery) #Authentication #REST API #InterSystems IRIS 0 3 0 600
Question Oliver Wilms · Apr 29, 2022 PoolSize System Default Setting Hello, I tried to define Pool Size in System Default Settings, but it is not being used. I see I am not the first to try this without success: Define PoolSize as system default value | InterSystems Developer Community Any suggestions? #Business Operation #InterSystems IRIS 0 3 0 370
Question Oliver Wilms · Jan 8, 2022 SQL LOAD DATA date values I have csv date file with date values like this "4/10/2021" for April 10, 2021. I defined a table with this property: Property TranDate As %Library.Date. I capture error [SQLCODE: <-104>:<Field validation failed in INSERT, or value failed to convert in DisplayToLogical or OdbcToLogical>] [Location: <ServerLoop>] [%msg: <Field 'dc_data_finance.transact.TranDate' (value '4/10/2021') failed validation Field ... I do not really want to change TranDate to %String. How can I import "4/10/2021" into %Date property? #Data Import and Export #SQL #InterSystems IRIS 0 10 0 406
Question Oliver Wilms · Oct 21, 2021 Ensemble Data Lookup Tables - SQL query Hello, I wonder if we can run SQL queries to find data in Lookup tables? #SQL #Ensemble 0 1 0 433
Question Oliver Wilms · Oct 4, 2021 CSV Record Wizard has a bug? I tried out CSV Record Wizard with my dat file from Analytics contest: https://raw.githubusercontent.com/oliverwilms/iris-analytics/master/data... #CSV #Ensemble 0 1 0 211
Question Oliver Wilms · Aug 22, 2021 Web Gateway Error "Invalid Request : Cannot identify application path" I want to try SAM in AWS. I followed these steps: docker pull store/intersystems/sam:1.0.0.115 #CSP #SAM - System Alerting and Monitoring #Web Gateway #InterSystems IRIS 0 7 0 566
Question Oliver Wilms · Dec 7, 2020 Record Maps - is message required to be in a file? Hello, I like to know if we need to have the message in a file to process a Record Map? I am working with Interoperability Production that processes files /messages using Record Maps. My team was asked to redesign the solution for deployment in AWS. We use containers. We had problems with having multiple containers processing files from the same directory. We are considering Amazon Simple Queue Service instead of having files on a shared file system. #AWS #Business Service #Interoperability #Mapping #InterSystems IRIS 0 1 0 211
Question Oliver Wilms · Nov 5, 2020 ECP Data Server - Allow Incoming Connections - Add ClientIP with code Hello, I am working with Elastic Container Service in AWS running IRIS for Health containers 2020.1. We have an ECP Data Server. I like to be able to add a new host IP on the data server when a new client starts up. What table are the Allowed ClientIPs stored in? Thanks, Oliver #ECP #InterSystems IRIS for Health 0 1 0 259