Question Scott Roth · May 15, 2023 Linked Table connection through JDBC Ran into an issue with our upgrade from HealthShare Health Connect 2018.1.3 to IRIS HealthShare Health Connect 2022.1, that I thought I would reach out about, I already have a ticket open with WRC and started a chat on Discord. We have a couple of MS SQL tables that I have setup as Linked Tables within Cache to query NPI, Patient Account Information, Visit information, etc... When we upgraded last week we found that within a day or even a half a day that we were having problems with our JDBC connections. #JDBC #Key Question #SQL #Health Connect #InterSystems IRIS 0 19 0 696
Question Scott Roth · May 1, 2023 Email Alert - EnsLib.EMail.OutboundAdapter Error I am running into an error trying to send an Alert Email to test the functionality of IRIS HealthShare Health Connect 2022.1 compared to Cache HealthShare Health Connect 2018.1.3. I was trying to send an Alert email, when I am getting the following error on my EMailAlert operation which is using EnsLib.EMail.OutboundAdpater. ERROR <Ens>ErrException: <UNDEFINED>FText+4 ^%occMessages *msg -- logged as '-'number - @'' #Business Operation #Deployment #Ensemble #Health Connect 0 5 0 294
Question Scott Roth · Apr 20, 2023 Security Advisor - Application Error I am trying to finish build for moving to IRIS HealthShare Health Connect 2022.1 from HealthShare Health Connect 2018.1.3. I am currently using Delegated Authentication using an AD group to match up to the Role in IRIS. The Role has access to everything but the HS Resources because we don't really use the HS Resources for anything. We are mainly using IRIS for the Interoperability Engine. #System Administration #Health Connect #InterSystems IRIS #InterSystems IRIS for Health 0 0 0 166
Question Scott Roth · Apr 19, 2023 ERROR #5034: Invalid status code structure - Writing to File I wrote a function awhile back to take Encoded Base 64 and write the PDF out to a file that could be sent to a faxing system to fax out. We are trying to test this code out in IRIS and I am seeing an error that I have not seen before... ERROR #5034: Invalid status code structure Here is the code... ClassMethod DecodeBase64HL7ToFile(base64 As %Stream.GlobalBinary, Ancillary As %String, FileName As %String) As %String { set ArchDir = "/ensemble/data/transfer/AncillaryPDF/" #Error Handling #ObjectScript #InterSystems IRIS 0 7 0 413
Question Scott Roth · Apr 12, 2023 Quick Process to Start/Stop an Object We are currently using different iterations of Ens.Director.EnableConfig items to start/stop objects within the Interoperability Namespace. We are looking for ways to minimize our downtime as we move from AIX to a new section of our Network and Red Hat Servers. #Key Question #ObjectScript #System Administration #InterSystems IRIS 0 12 1 660
Question Scott Roth · Apr 6, 2023 Using %Stream.FileCharacter to create and append to files - Permissions Issue We have a function that was written for us that allows us to create text files for logging certain aspects to the OS using %Stream.FileCharacter. We had no issues with this until we moved from AIX to Red Hat. Now it seems the 1st time the function is called, and the file is created the permissions seem to be correct on the file. But as soon as we attempt to write another line to the file using MoveToEnd() it seems the permissions are changed on the file. I have been able to narrow the issue down to the MoveToEnd() by calling the function from different users. #ObjectScript #Red Hat Enterprise Linux (RHEL) #InterSystems IRIS 0 9 0 738
Question Scott Roth · Apr 3, 2023 Port Authority Error - ERROR #794: Doc DB IRISInteroperabilityPorts in namespace I followed the instructions to setup the Port Authority Report in our new IRIS instances, but noticed if I tell it to run every hour I am getting the following error message... Here is how the report is setup... #Management Portal #System Administration #InterSystems IRIS 0 3 0 358
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 322
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 284
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 247
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 424
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 446
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 303
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 307
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 283
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 541
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 262
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 236
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 372
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 368