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 250
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 818
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 584
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.7K
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 279
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 849
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 705
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 536
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 480
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 338
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 490
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 244
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 414
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.9K
Question Scott Roth · May 1, 2019 Inventory of Services/Processes/Operations Is there a way to get an inventory list of the Services, Processes, Routing, and Operations that are on the system. We get asked constantly from different departments to justify the number of personal we have. We are currently on 2015.2.2, with our upgrade to 2019 set for later this year.ThanksScott #Object Data Model #Ensemble 0 1 0 271
Question Scott Roth · Apr 12, 2019 Timing of Database look up We use a lot of external MS SQL calls to look up numerous things when it comes to HL7. I am running into an issue where the outbound calls are queued but the message is sent onto the next process before it gets a response. How do I get it to wait till the response gets back from the MS SQL call before sending it onto the next process?Below is a screen shot of what I am trying to explain...Select Research Study executes at 8:33 the message is sent to the next process at 8:34, but the response of the MSSQL call doesn't come till 9:31. #ObjectScript #SQL #Ensemble 1 8 0 380
Question Scott Roth · Apr 9, 2019 SOAP Request Header I have a wdsl soap request that now requires a header. Where do I modify the header to allow this new value to be sent? <soapenv:Header> <Headers xmlns="urn:epic-com.2013.Interconnect.Headers"> <Epic-Client-ID>12349fe5-2ff8-4b79-b723-e69efbabcdef</Epic-Client-ID> </Headers> </soapenv:Header> Thanks Scott #ObjectScript #Caché 0 7 1 711
Question Scott Roth · Mar 20, 2019 Query Response from MSSQL I am having an intermittent issue that when I make a call to MSSQL from a BPL that the response does not come back in the amount of time required. Since the call from the BPL is synchronous I tried changing the timeout to 60 but it has not helped (see below). Is there anyway to guarantee that the call waits long enough for a response before continuing on?Thanks #Business Operation #Business Process (BPL) #Callout #ObjectScript #SQL #Ensemble 0 4 0 412
Question Scott Roth · Feb 20, 2019 HL7 ORU^R40 Schema Structure We are currently on 2015.2.2 and in schema structures for vs 2.6 HL7 I do not have a ORU^R40. Its for a GE Device alarm. Has anyone hear of this structure, have a way to export it, and can send it to me so I don't have to build from scratch?ThanksScott #HL7 #Ensemble 0 3 0 1.2K
Question Scott Roth · Feb 13, 2019 Record Map - MAXLEN I am trying to read in a data file via a Record Map and I am getting the following error...ERROR #7201: Datatype value '030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_B452' length longer than MAXLEN allowed of 50 > ERROR #5802: Datatype validation failed on property 'osuwmc.MatSys.DataStructures.MatSysIVT.Record:Bin', with value equal to "030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_030121_B452" #Ensemble 0 1 0 642