Question Scott Roth · Aug 12, 2020 Is there a way to trigger system functions from Alerting in Ensemble We have a vendor that every couple of days will just stop transmitting messages, but still hold the TCP/IP connection open. No matter how many times we troubleshoot and talk with them, they don't seem to think its an issue with system. Normally if I just restart the service it will get the data flowing again. #Business Service #Error Handling #ObjectScript #Ensemble 0 3 0 248
Question Scott Roth · Jun 9, 2020 Querying a Cache Table from a Business Rule After all these years of doing basic Ensemble work, I am just beginning to venture into using Cache Tables instead of either Data Lookup tables, or what I know of Outside SQL tables using JDBC. I have several Cache SQL tables that I am building for a project I am working on. #Business Rules #ObjectScript #SQL #Ensemble 0 9 0 424
Question Scott Roth · Jun 3, 2020 Routing Rule - Syntax Error Cache for UNIX (IBM AIX for System Power System-64) 2018.1.3 (Build 414U) Mon Oct 28 2019 11:24:02 EDT [HealthShare Modules:Core:15.032.9026 + Linkage Engine:15.032.9026] #Business Rules #Ensemble 0 3 0 198
Question Scott Roth · Feb 6, 2020 Whats the difference between the CLS files and CSP pages Throughout my years working within HealthShare\Ensemble, I have been able to mimic the Data Lookup page trimming it down to give our Ancillary areas access to modify their own data Lookup tables. I am currently working on building a CSP application to allow certain users to update MS SQL tables by going through HealthShare. I thought all I had to was create the CSP pages and grant access. I am able to access it off my desktop, but when I have a user try to access the application, they get the sign in but then it doesn't do anything. So I think I might be missing something. #CSP #HealthShare 0 1 1 435
Question Scott Roth · Jan 23, 2020 Uploading gif/image into CSP page Ok so I am way outside of my comfort zone, and had to build an application using CSP to give users the ability to access SQL configuration tables. These SQL Configuration tables will affect the data that is sent to the downstream system. I saw in the examples where we were able to import GIF's/IMAGES into the CSP folders to use as a reference in our CSP pages. My question is how do you do that? If I try to import through studio, it tells me the file is invalid. Just trying to make it a little more user friendly then blocks on a page. #Beginner #CSP #HTML #SQL #Studio #HealthShare 0 1 0 919
Question Scott Roth · Jan 10, 2020 Remote Gateway Error: JDBC Gateway SP execute(0) error 0: Access to the remote server is denied because no login-mapping exists. I am working on a BPL to take data from a MS SQL database and create an HL7 Materials Message for our EMR. I have done this plenty of times in the past however I am running into an error. "Remote Gateway Error: JDBC Gateway SP execute(0) error 0: Access to the remote server is denied because no login-mapping exists." What is confusing is that this BPL doesn't differ from any of my other BPLs in connecting to MS SQL Server. I know I am missing something.. #Business Operation #Business Process (BPL) #Callout #ObjectScript #SQL #Ensemble 0 3 0 688
Question Scott Roth · Dec 20, 2019 CSP front page to allow users to alter multidimensional tables I have a case where I have an external table that lives out in MS SQL. Using Ensemble Security functions has anyone created a csp or cls page that acts like a portal to allow users to Update a multidimensional table without knowing SQL? I could clone the EnsPortal.LookupSettings but that was made for LUT which are only 2 columns. I know its a long shot but trying to see if there was anything off the shelf that I can use to help meet the requirements of this project. #CSP #Frontend #ObjectScript #SQL #Ensemble 1 4 0 242
Question Scott Roth · Nov 21, 2019 $System.OBJ.Upgrade not updating class dictionary I am currently working on an Upgrade to HealthShare 2019.1.1. As described in the steps once the upgrade was complete to run $system.OBJ.Upgrade(). When I run $system.OBJ.Upgrade() , it is not finding any classes to update. However I am getting an Error 5116 on one of my Productions... Class dictionary version for '%1' is out of date, please run upgrade utility $system.OBJ.Upgrade() #System Administration #Ensemble #HealthShare 1 5 1 771
Question Scott Roth · Oct 30, 2019 Multiple OBX Encoded PDF formatting I must be missing something. We have done encoded PDF's in the past with the Encoded PDF in OBX.5.5. When I have used this code in the past I was only working with 1 OBX, but I have a case where I am having multiple OBX's and having to loop through them and I am renumbering the outbound OBX. #DTL #ObjectScript #Ensemble 0 1 0 548
Question Scott Roth · Oct 14, 2019 Integrating InterSystems IRIS with Source Control Systems (GitHub/Azure) I am currently evaluating Source Control systems that we can use for both MS SQL, MS Visual Studio, and InterSystems IRIS. For both MS SQL and MS Visual Studio we do have the option of either Azure or GitHub. I understand when we upgrade to IRIS 2019.1 we have options for Source Control, and in previous Global Summit's I have heard GitHub discussed. So why can't I user GitHub for both MS SQL/MS Visual Studio and IRIS? A couple of questions come to mind starting to think about Source Control #Azure #Change Management #GitHub #Tools #InterSystems IRIS #VSCode 0 7 1 1.6K
Question Scott Roth · Oct 3, 2019 Error 5496 - Inverse property - Record Header Batch When compiling in 2018.1.2 using $system.OBJ.CompileAllNamespaces() I am seeing the following errors on some of our Record Maps. #Mapping #System Administration #Ensemble 0 1 0 264
Question Scott Roth · Oct 2, 2019 Trying to understand Orphaned Messages We are constantly running into issues where there are billions of Orphaned messages in our system that cause problems, and we have to manually run a cleanup to fix performance issues. In the following article about orphaned messages... https://community.intersystems.com/post/ensemble-orphaned-messages it mentions either programmatically eliminating the Orphaned messages or using a Utility like Demo.Util.CleanupSet in ENSDEMO. #Monitoring #System Administration #Ensemble 0 7 2 788
Question Scott Roth · Sep 19, 2019 Using Sleep/Halt in a Business Rule between sends We have a case where we have 1 message coming in, but then sending two messages out to the same location. Even with FIFO sometimes the messages get out of sequence depending on what is need to be done to the message in the DTL before send. Is it possible to call sleep or Halt or write some kind of a function to put a pause in a routing rule between two sends? #Business Rules #ObjectScript #Ensemble 1 5 0 662
Question Scott Roth · Sep 12, 2019 Clean up code after compile After upgrading I ran a $SYSTEM.OBJ.CompileAllNamespaces("u"). What I got in return was kind of a shock.In reviewing errors I am seeing code being referenced but no longer applies. It is referring to stuff that might of been defined in the Context , Formal Spec ,Thread , etc.ERROR #5373: Class 'osuwmc.CPD.DataStructures.TblPharmacyDEA', used by 'osuwmc.CPD.BusinessOperation:SelectProviderTempDEA:FormalSpec', does not exist #ObjectScript #System Administration #Ensemble 0 1 1 497
Question Scott Roth · Sep 9, 2019 Filtering messages based on OBX:3.1 being valued We have a customer that is not able to accept HL7 result messages that are missing OBX:3.1. I have been trying to create a function that could return a boolean value of 0 if the message didn't meet the expectations of the function. #Business Rules #HL7 #ObjectScript #Ensemble 0 7 0 455
Question Scott Roth · Sep 5, 2019 Running Compiler to an output file Is there a way that when you run $system.OBJ.Compileall() that you can make the output written to a file instead of the screen? I am trying to capture all the errors so I can review the code and fix them before we upgrade.ThanksScott #ObjectScript #System Administration #Caché #Ensemble 0 4 0 321
Question Scott Roth · Sep 5, 2019 Upgrading from 2015.2.2 to Health Connect 2019.1 Currently we are using Health Share 2015.2.2, and looking to upgrade to the latest version in the next month. From what I understand we have to upgrade to 2017 or 2018 prior to going to 2019.1 since 2019.1 is on the IRIS platform. In trying to outline my steps in the upgrade process I came up with a question. Can a Full System Backup from 2015.2.2 be restored into 2019.1? Do I have to restore the 2015.2.2 back up into 2017 or 2018, then do the 2019.1 conversion? Has anyone had experience with this? or should I open a ticket with WRC? #Backup #Ensemble #Health Connect 0 5 0 470
Question Scott Roth · Aug 27, 2019 Documentation while upgrading I am trying to work through our upgrading steps from 2015.2.2 to Health Connect 2019.1. Is there a place online I can access previous versions of Health Connect documentation? I am specifically looking for Health Connect 2018.1.2 documentation so I can understand the upgrade process on AIX. Thanks Scott Roth #System Administration #Documentation #Ensemble #Health Connect 0 2 0 227
Question Scott Roth · Aug 19, 2019 Filter by time in Routing Rule I have a colleague that is trying to eliminate any HL7 transactions that have admit date/time of midnight from going to an downstream system within a routing rule. I have tried several different iterations of code trying to figure this out just in the routing editor. Without having to write an object script function is this possible? #Business Rules #HL7 #Ensemble 0 4 0 388
Question Scott Roth · Jul 8, 2019 How do you loop through a string, and split the string up based on the number of characters Way back when during our Siemens LCR days we had to limit the number of characters in OBX.5 to a length of 75. That was back when we had eGate. Now I need to do the reversal of that and take loop through a string length and split the string up into multiple OBX or NTE based on a certain length. In reading documentation $EXTRACT can do this if you know the exact length, but in this case we don't. So how would one loop through a string and say every 75 characters create a new OBX or NTE segment? Thanks Scott #DTL #ObjectScript #Ensemble 1 7 0 2.8K