Question Scott Roth · Mar 30, 2023 Business Process vs Business Process Component I had an interesting scenario come up, as when we moved from eGate to Ensemble and we will be moving to IRIS here in the near future I was taught to create Business Processes for writing to and extracting data from outside MS SQL Databases. #Business Process (BPL) #HL7 #Ensemble 0 2 0 309
Question Scott Roth · Mar 28, 2023 Using JDBC Gateway to call External SQL Calls - Best Practices??? I am trying to pinpoint and troubleshoot an issue we have been seeing lately. We have several SQL Outbound Adapter Operations that are seeing issues trying to connect to our MS SQL Servers using the JDBC Gateway for calling insert, select, update, and stored procedure calls. #JDBC #SQL #System Administration #Caché #Ensemble 0 0 0 275
Question Scott Roth · Mar 15, 2023 Business Partner (Contact Information) We are migrating to new servers, and I need to copy the information from Business Partner's over to the new server. Is this information in a Global or SQL table somewhere that I can export and import into the new IRIS environment? Thanks Scott #Globals #SQL #System Administration #Ensemble 0 2 0 241
Question Scott Roth · Mar 10, 2023 ZSTOP - Type of Shutdown that occured I am looking into creating a ZSTOP as you probably have seen from my previous posts, is there a way to capture the type of shutdown that occurred? So say if there was an unknown hardware failure (forced), vs a user shutdown? Mainly looking for user or system shutdown when we force another destination to become the primary in the mirror. So if a user shutdown the production to do.,... Task A, Task B etc.. Thanks Scott #High Availability #ObjectScript #System Administration #InterSystems IRIS 0 3 0 407
Question Scott Roth · Mar 8, 2023 Suspension of Messages during Shutdown We have messages that are in a queued state for various reasons and when we do a manual shutdown of the instance, they are moved to a Suspended state. I thought I saw in the documentation somewhere a setting to make sure these messages stay in a queued state and not suspend them. Can someone confirm and point me in the correct location for that documentation, as I am trying to ensure that if we do have to manually shutdown a instance, someone doesn't have to remember to go back in and check for suspended messages and resubmit them? Thanks #System Administration #InterSystems IRIS 0 4 1 426
Question Scott Roth · Mar 7, 2023 Questions about using ZSTOP I am working on setting up our Failover techniques as we move to a Mirror Environment with a Arbiter, 2 Failover Nodes, and a Async (DR) Node. There are some system commands that I would like to call when the Mirror moves, and I am working on a ZMIRROR routine for that, but I also wanted to create an additional step if we wanted to manually shutdown and for the Mirror to move. So I was looking at using ZSTOP to call a couple of different items while shutting down, while the documentation has an example a couple of questions come to mind about using ZSTOP. #Mirroring #ObjectScript #System Administration #InterSystems IRIS 0 3 0 299
Question Scott Roth · Feb 21, 2023 Question about setting up Failover/Async Mirroring I am new to setting up a mirror environment.... We will have a Arbiter, Two Failover members (A,B), and a Async (DR) member (C). I have the two failover members in sync and are configured for Arbiter Control. My question is about the Async member, when I initially set it up I pointed it to the mirror on the primary node A. Is that correct? #High Availability #Mirroring #System Administration #InterSystems IRIS 0 8 0 288
Question Scott Roth · Feb 16, 2023 HealthShare Health Connect version Can someone confirm that HealthShare Health Connect 2022.2 is the correct latest release that is available via the Online Distribution? I tried looking at the HealthShare Health Connect on WRC and now do not see a 2022.2 or 2022.3 version. Is this correct? So I shouldn't be running 2022.2? Did Health Connect get renamed? A couple of months ago I downloaded HealthConnect-2022.2.0.368.0-lnxrh8x64 but not seeing it now on the WRC site. #Continuous Delivery #System Administration #Health Connect #HealthShare 0 2 0 263
Question Scott Roth · Feb 14, 2023 Installing/Running Arbiter Container using Podman Does anyone have experience with installing the Arbiter Container using Podman instead of Docker in a Red Hat environment? I was able to pull down the docker image, but unsure what are the next steps as I am confused on how to start the container using Podman and ensure the parameters are set appropriately? Does anyone have the steps that I should take? Should I go through the WRC? Does the WRC have experience using Podman? Or should I just install the ISC Agent instead of using the Container? Please and thanks, Scott Roth #Containerization #Mirroring #InterSystems IRIS 0 7 0 513
Question Scott Roth · Feb 6, 2023 Changing from Client Side to Server Side Source Control in VSCode I am trying to adjust my VSCode settings.json to make my repository to Server Side Source Control. When Adding "uri" to the settings.json to change the setting but VSCode is telling me that the Property uri is not allowed. Why is this happening? #Source Control #System Administration #VSCode 1 1 0 249
Question Scott Roth · Jan 27, 2023 Account for different parsing technique in EnsLib.HL7.Service.FileService?? I have a system that is sending Line Breaks\Carriage Returns within the text of a field that is breaking the parsing of the message. Does anyone have a way to get around this? here is what I receive... #Business Service #ObjectScript #Caché #Ensemble 0 5 0 232
Question Scott Roth · Dec 16, 2022 Simple way of calling EnableConfigItem from within an Operations/Service Was wondering if anyone had a simple way of calling ##class(Ens.Director).EnableConfigItem() within a Business Process or adding code to a Custom Service to start or stop the object? The use case is that I have a Process that uploads a file into a external SQL table. When it is finished I want it to kick off another Service that does the processing of the data that it just uploaded. Once it is finished the response is sent back to the service and when the service receives the response from the process, I want to stop that service from running. so... #Business Process (BPL) #Business Service #ObjectScript #Caché 0 8 0 359
Question Scott Roth · Dec 14, 2022 Data Export/Import of %SYS.%Library.sys_SQLConnection I am trying to migrate our SQL Connections from HealthShare Health Connect 2018.1.3 to IRIS HealthShare Health Connect 2022.2 using the Data Export/Import Wizard through the Management Portal. I am able to export the data fine, but I am running into issues trying to Import it into 2022.2 using the Data Import Wizard. When I run through the steps it is not importing everything from the txt file I created from 2018.1.3. I would rather not have to rekey all the connections if possible. Here is the Background Task Error Log #SQL #System Administration #Health Connect #InterSystems IRIS 0 2 0 350
Discussion Scott Roth · Oct 13, 2022 Docker help - Idea a thon I do not know about others, but Docker and the intro of Docker was not a forte of mine coming into trying out new components of InterSystems IRIS. We are moving to IRIS and with that we want to incorporate into our upgrade. I have been struggling with trying to understand Docker. I know it is not an InterSystems product but the assumption that everyone knows Docker and is using Docker has caused me a great deal of time. What is everyone's thoughts about getting some kind of docker help like a basic understanding within InterSystems documentation. #InterSystems Ideas Portal 3 2 0 209
Question Scott Roth · Oct 13, 2022 JDBC Gateway Server Crash I am trying to troubleshoot an issue I am having with the JDBC Gateway Server crashing at the %SYS level. I have numerous Linked Tables that are using JDBC to connect to a MS SQL database/tables to query values. I have written queries in other class files and within the class definition of the linked table to do the queries. 1. Should I be running the query in the class definition of the linked table as a class method? or is it best practice to run the query as a class method outside of the class definition of the linked table? #JDBC #System Administration #Ensemble 0 3 0 217
Question Scott Roth · Oct 11, 2022 Community Edition Linux Setup I am trying to get the Apache Web Gateway with Docker running on a development RHEL 8 machine so I do not have to config the Web Gateway and Apache apart from each other. I noticed the Apache Web Gateway docker image is using IRIS Community Edition. However when I try to run the docker image with podman I am running into issues with the IRIS setup. I was wondering if someone could help me. #Docker #InterSystems IRIS 0 2 1 269
Question Scott Roth · Oct 3, 2022 JDBC Gateway Server CSP timeout issue I was attempting to test a Linked JDBC View to MS SQL database and noticed I could not connect. When I look at the JDBC Gateway I noticed that at the Server Level it was down. However the page keeps timing out when ever I attempt to make any changes or start it, it will not respond. I thought I had found the Cache command to start it but it will not start. Is the following steps correct? #JDBC #Caché 0 1 0 252
Question Scott Roth · Oct 3, 2022 Enable Sub-Rules Programtically I know there is the ability to enable Rule Sets within a Business Rule by dates, but what about Sub-Rules or just Rules in general? We have an upcoming go-live that is at Midnight and I was wondering if there was a way I could script out enabling rules/sub-rules within a Business Rule to save my team some time and headaches. Or is the best practice is just to create another rule for the go-live, then move it over once we are live... #Business Rules #System Administration #Ensemble 0 1 0 257
Question Scott Roth · Sep 21, 2022 Docker - Webgateway I am trying to pull down the webgateway from containers.intersystems.com and I am receiving the following errors... Please advise #Docker #Web Gateway #InterSystems IRIS 0 7 0 507
Question Scott Roth · Sep 13, 2022 Setting up Task for User Defined Class File I have created a class file that I want to execute daily to gather Metrics (Message Header, Space Available, etc..) and write the data into a Cache table. Now that I have written the class I want to add it to the Task Scheduler within Ensemble to run every morning. How do I go about getting the class file created as a Task within the Task Scheduler? The Documentation isn't as clear cut for creating custom tasks as one would expect. #ObjectScript #System Administration #Ensemble 0 5 0 580