Question Mark OReilly · Oct 25 ForEach with Assign only returning the second looped aux value in foreach when sending from rule editor We have a scenario where we use the best practice article of a BP and DTL to split up HL7 messages mainly ORUS https://community.intersystems.com/post/splitting-oru-messages-using-obj... It is really useful but we have this code in many places that we are trying to consolidate it in one place. #Business Rules #DTL #HealthShare #InterSystems IRIS for Health 0 1 0 62
Question Mark OReilly · Aug 30 Only load part of XML/ SQL Snapshot in visual trace- portal loads too slow As part of fully decoupling code we send a snapshot from a business service (running a SQL statement). sql service Processor File Out This is picked up by a processer and puts it into a file .txt. #Business Service #Management Portal #Message Search #InterSystems IRIS for Health 0 2 0 72
Question Mark OReilly · Jul 31 How to get value from Zenpage component from Chrome/edge addon JS Hi: I have been adapting the IRIS WHIZ addon as part of the contest. I will soon fork the code on github so the changes are available. The next phase is I am storing the date from and to time for a more complete search cache zenPage.getComponent(36).value it works in the chrome console ok I'm not sure in external JS how to set the page it is on as a zenpage to use the zenpage functions #JavaScript #ZEN #Caché #Ensemble #InterSystems IRIS for Health 0 3 0 63
Question Mark OReilly · Jun 12 Message Body Details index- all seem same value? Hi: We are looking again into DB size. Looking at our Ens.MessageHeaderI GSIZE is 3767107 Looking at the global i'm not sure if we have had an issue in the past so much of the data looks the same, we only have 3 values in the $zwc and although some of the data in the $c between 1 and 18630 it looks very similar as if there was an issue in the past. But if anyone has any examples of their index param this would help to know if our global is abnormal. Data below #Globals #InterSystems IRIS for Health 0 1 0 58
Question Mark OReilly · Apr 19 Message Bank Message Viewer- how to query XML In message bank how do you search within XML? XML is imported on message bank so that side is ok as can see it like below On source system message viewer finds message On Message bank it doesn't #Enterprise Message Bank #Message Search #InterSystems IRIS for Health 0 1 0 110
Question Mark OReilly · Mar 13 ZAUTHENTICATE.Mac cannot be saved in %SYS other macros can When trying to save ZAUTHENTICATE.mac the following error occurs If it is wrongly named as like ZATHIENTICATE.mac in the %SYS namespace it saves ok so it is something blocking saving a new fresh ZAUTH code of the correct name- we have no other delegated auth that I am aware of. #Authentication #InterSystems IRIS for Health 1 9 0 136
Question Mark OReilly · Feb 16 %Library.PropertyHelper not accepting variable *** updated from a comment as original question may not have been clear** To clarify my question this is the library property helper class Library property helper when you look at the documentation for computed from documentation here Computed documentation #Compiler #ObjectScript #InterSystems IRIS for Health 0 9 0 215
Question Mark OReilly · Jan 16 Raw content from DTL test Does anyone have any trick to get the raw text out whenever you run a DTL test in the DTL editor? #DTL #UI Development #InterSystems IRIS for Health 0 2 0 159
Question Mark OReilly · Dec 12, 2023 Arthematic overflow only on one server- mssql sql When running a sql insert query with CONVERT('datetime', '2023-12-12 11:27:00',120) in an insert statement into a table this works on one server and not the other. i.e. to record datetimereceived #SQL #InterSystems IRIS for Health 0 2 0 143
Article Mark OReilly · Dec 8, 2023 2m read Business Service to Query Internal IRIS database Scenario IRIS has the likes of SQL inbound adapters for use with SQL gateways such as EnsLib.SQL.InboundAdapter to repeatedly query SQL Gateway connections. A scenario appeared as that we wanted to query an Internal database for some data but did not see an out of the box service for this. Desired Approach Have a Generic service that can poll internal SQL to work with downstream components. #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 2 0 0 250
Question Mark OReilly · Aug 15, 2023 Discarding leftover input followed by <Ens>ErrException: <NOTOPEN>zFlush+7^%IO.DeviceStream.1 -- logged as '-' number - @'' We have this intermittent issue with a particular supplier message , just wondering if anyone has further insight around the two errors we get when we see this. We use the out of the box TCP hl7 adapter. We first seem to get this incomplete hl7 message resulting in an error like Discarding leftover input 'MSH| This is not unexpected as the final obx has not dot the description of OBX:2.2 ect. OBX|53|TX|NCDAC^ The next message will have the error #Business Service #HL7 #InterSystems IRIS for Health 0 2 0 202
Question Mark OReilly · Jul 3, 2023 How does the front end of the portal look up the message head ID so quickly In show Query messages in the message viewer the head.%Id is always used. How do you do this via your own sql/objectscript as fast as the portal does a search as using dates searching Ens.MessageHeader on portal is slow. For instance if you try do a search saying (TimeProcessed >='2023-06-01 00:00:00.000' and TimeProcessed <'2023-06-02 00:00:00.000') it is slow but using the portal the search would know this is head.%ID >= 5344549861 AND head.%ID <= 5347641372. How do you utilize this in your own queries as can't see the logic in EnsPortal.MsgFilter.Assistant #Message Search #SQL #InterSystems IRIS for Health 0 3 1 237
Question Mark OReilly · May 18, 2023 Streamcontainer to operation original filename won't be set Trying to pass pdf to save to custom file using default Trying to pass pdf to save to custom file and %f. but oriignal filename didn't send (it does in terminal). What is missing from setting filename from stream? can the file passthrough not out of box use outputfilename or has wrong default one been sent. #Business Operation #ObjectScript #InterSystems IRIS 1 5 0 257
Question Mark OReilly · Apr 14, 2023 After upgrade SYS.Task.BackupAllDatabases not After any installs upgrades we get the following 04/13/23-18:00:00:978 (18668) 0 [Utility.Event] d:\intersystems\healthshare\mgr\enslib\ (Database is readonly) 04/13/23-18:00:00:979 (18668) 0 [Utility.Event] d:\intersystems\healthshare\mgr\hslib\ (Database is readonly) I think we must have before altered these to not read-only. Not sure if the isssue is by default -Running task as user with %ALL rather than SYS user - Should the dbs be as default in the all backup list - Should these be not ro so it backs up without error? #Backup #InterSystems IRIS for Health 0 2 0 257
Article Mark OReilly · Apr 6, 2023 7m read A beginners guide to Orphaned data- How as a trust we cleaned up 200+gb Purpose of this article There are two great WRC best practice articles Ensemble Orphaned Messages | InterSystems Developer Community | Best and the delete helper post DeleteHelper - A Class to Help with Deleting Referenced Persistent Classes (intersystems.com) #Beginner #System Administration #Tips & Tricks #InterSystems IRIS for Health 6 3 5 626
Question Mark OReilly · Feb 16, 2023 Can you compact and truncate only on shadow server 2022.1 (Build 209U) Hi we have started to get rid of orphaned data and would like to soon compact and truncate the database as will have about 40gb free to return to filesystem after the few weeks of running the new task. The idea would be to do this on the shadow server first of mirror rather than primary. Is there any reason this is a bad idea? Considering this needs done on both servers of mirrored db? As idea would be to do this on shadow server before we failover to the server a few days afterwards. And do the same for the month afterwards. #Databases #InterSystems IRIS for Health 0 3 0 190
Question Mark OReilly · Feb 3, 2023 How to use Delete helper https://community.intersystems.com/post/deletehelper-class-help-deleting-referenced-persistent-classes Hi: I don't understand how to use this open exchange item for auto creating deleting items. I think it assumes knowledge in the steps of how to use it which i don't get. Added the code into dev on SRFT.Utility.DeleteHelper.OnDeleteSuper and SRFT.Utility.DeleteHelper.AddHelper current class is #Message Search #ObjectScript #Open Source #InterSystems IRIS for Health 0 2 0 221
Question Mark OReilly · Jan 11, 2023 How to quickly open class in VS Code Is there an easy way to open classes in VS Code? In studio you go open and just type the class name and it opens up the class. In VS Code need to know the full path, is there a quick way? It is probably the one thing preventing from using VSCode full time (apart from not seeing the .luts or csp files) #VSCode 0 15 0 4.5K
Question Mark OReilly · Oct 25, 2022 Attempt to access a protected Resource- CSP custom page error- have granted role Getting proctect error on csp custom login page. It says to add role to CSPSYSTEM i have given role to db (rw i would like to change to R once working). It has not solved issue #Authentication #CSP #InterSystems IRIS for Health 0 2 0 197
Question Mark OReilly · Sep 27, 2022 Deleting Cleanup SQL Cleanup Index task How to delete this redundant task. Cannot press delete when logged in as _system #SQL #InterSystems IRIS for Health 0 1 0 232