Question David.Satorres6134 · Feb 18 Cube Compilation Order in UCR: How to Manage Dependencies? Hello all, We are currently developing a set of cubes in Unified Care Report (UCR) for data analysis purposes. However, we are encountering issues with cube dependencies, where certain cubes rely on others to be compiled beforehand. The complexity of these dependencies is becoming increasingly difficult to manage, particularly when attempting to deploy the cubes. #API #Cubes #HealthShare #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 0 5 0 31
Question David.Satorres6134 · Nov 13, 2024 AutoParallel feature in SQL not working Hello all, We have our system with AutoParallel enabled: USER>w ##class(%SYSTEM.SQL.Util).GetOption("AutoParallel") 1 But whenever I try to run any sql the autoparallel does not work. For example, this simple query: When I force it with %PARALLEL we can see it will effectively run in parallel: #Databases #SQL #InterSystems IRIS 1 9 0 177
Question David.Satorres6134 · Oct 7, 2024 I can't get to work WebTerminal in IRIS Health Connect 2023.1 Hello everybody, #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 10 0 168
Question David.Satorres6134 · Sep 2, 2024 Embedded python still using old version of python after system upgrade Hello, I've recently updated the python version of a linux server running Red Hat Enterprise Linux 8.10 (Ootpa). We have an instance 2023.1 running there, and whenever I run the $System.Pyhthon.Shell() I can see it's still pointing to the old version. From within linux, it runs the latest one (we've change all the links to the new 3.11, so no scripts are broken). So I guess the problem comes from the fact irispython is still compiled using old python version. So, how can I do to force IRIS to use the current version on the server, or update the irispython file? #Python #InterSystems IRIS 0 3 0 157
Question David.Satorres6134 · Jun 24, 2024 Export setup Linkage Definition from one environment to other Hi everyone, We have successfully configured the Patient Index and are now looking to bring it to upper environments. Our plan is to export the Linkage Definition and import it into higher environments to avoid any manual work. However, I am having trouble finding an export option in the Linkage Definition Designer and locating the globals that hold this setup. I would greatly appreciate any tips or guidance on how to export/import the Patient Index configuration between environments. Thank you in advance! #Data Import and Export #Globals #Caché #HealthShare 0 4 0 98
Question David.Satorres6134 · Oct 9, 2023 Create a cube sourcing a MS-SQL linked class/table Hello all, I'm trying to build a cube based on a linked table but seems that IRIS is not able to do it :O Long story short, I have a linked table in IRIS that sources a Microsoft SQL table (using standard linked feature from the portal). It works fine, I can access it using SQL as many other times. On top of that, I've created in DeepSee (ok, Analytics) a cube that uses this class as source. It compiles correctly, no errors given. When I build it with 100 records, all goes well and using Analyzer I can see results. #Analytics #Cubes #SQL #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 0 0 0 150
Question David.Satorres6134 · May 31, 2023 Disable sql auto-tune in IRIS 2022.1 Hello, Do you know if there is any way to disable the automatic tuning IRIS is doing every time a class is altered? It just takes too long in our case and is holding the system, so I'd like to tune the tables when I decide it (again). I've seen in the documentation that for 2023 version there is an option present in the backend. But not for 2022, so I assume a flag is needed somewhere. Many thanks! #SQL #InterSystems IRIS 0 3 1 250
Question David.Satorres6134 · Mar 1, 2022 Install python libraries in a different directory Hello all, I've seen that to install any python library we just need to call this: C:\InterSystems\IRIS\bin>irispip install --target C:\InterSystems\IRIS\mgr\python geopy Is there a way to install the libraries in a different directory and set up the system to load the python from that other directory? #Embedded Python #InterSystems IRIS 1 1 0 377
Question David.Satorres6134 · Dec 17, 2021 IRIS as a document database and Properties population Hello all, I'm "playing" a little bit with IRIS as document database, as it seems really simple to use. So far, creating a database and inserting documents is fine. Creating a Property so it can be indexed seems very useful and it works well when this property is created at the very beginning. But here my "problem": whenever a new property is added, how can the values be recalculated and inserted, so indices can be correctly updated? #Document Data Model (NoSQL) #InterSystems IRIS 0 3 0 327
Question David.Satorres6134 · Sep 21, 2021 "Invalid work queue manager category supplied" error after creating queue Hello, I'm experiencing a recurrent problem that I haven't found the way to solve, so I'm coming here with the hope somebody can give me a new approach. To make it short: we are creating categories on-demand to be able to place the maximum numbers of workers in memory, avoiding the limits established by system categories. But from time to time, one of this creation fails and system is no able to start the queue. The error we are getting is: #Code Snippet #Error Handling #ObjectScript #InterSystems IRIS 0 1 0 270
Question David.Satorres6134 · Jul 20, 2021 Suppress triggers in object approach, like %NOTRIGGER for sql Hi, When for any particular reason I need to update a record and don't want to pull the triggers, the keyword %NOTRIGGER can be used. But I've been trying to do the same when I change the row using the object approach, but I can't find it. Anyone knows if it's possible to avoid pulling triggers when working with objects? Sadly, the utility "DISABLE^%NOTRIGGER" doesn't seem to exist ;-) Thank you,David #ObjectScript #SQL #InterSystems IRIS 1 2 0 275
Question David.Satorres6134 · Mar 2, 2021 Community edition & jdbc Hi all, I'm trying to access via JDBC my community installation but the connection is always rejected. The same code (python code) using the stand-alone version of Intersystems IRIS works fine. Is the community edition limited in this case? I can't see it in the official documentation: https://irisdocs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page... #JDBC #InterSystems IRIS 2 8 0 599
Question David.Satorres6134 · Nov 23, 2020 Managing workers & categories for %SYSTEM.WorkMgr Hi, I'm trying to access the categories configuration for the WorkMgr via COS, so I can be able to create new categories for our processes and this way try to overlock the limit of cores*2 workers. I've seen that last version of IRIS is supposed to have a menu on the portal (System Administration > Configuration > System Configuration > WQM Categories), but since we are in 2020.1 this doesn't exist. Does anyone have experience with WQM.API to manage the categories, or the usage of ^%SYS("WQM") to set it directly? #ObjectScript #InterSystems IRIS 0 1 0 245
Question David.Satorres6134 · Oct 12, 2020 Creating index combining List(ELEMENTS) and another standard Property Hi, I'm trying (and not succeeding) to build an index based on a collection property combined with a property, like: Index Test On (Property, ListProperty(ELEMENTS).Property2) #Databases #Data Model #InterSystems IRIS 0 4 0 284
Question David.Satorres6134 · Aug 11, 2020 JDBC Gateway Server Hello all, I'm trying to setup the JDBC Gateway Server so customers can connect to IRIS remotely using JDBC and not ODBC. But I'm facing a problem connecting, as our system department tells me IRIS is using the loopback address (127.0.0.1) and that makes remote systems cannot connect to port 53773 (the default port for that). So, I would like to change this 127.0.0.1 host for the hostname but I cannot see where to do it: #JDBC #InterSystems IRIS 1 15 0 1.7K
Question David.Satorres6134 · Jun 17, 2020 Atelier in a zip Hi, I'm trying to install Atelier in my Eclipse installation, but due to network restrictions I am unable to reach the server. Is there any way to download the zip file to install it locally? #Eclipse 0 5 0 307
Question David.Satorres6134 · Jun 16, 2020 Multiple server connections in VS Code? Hi! As Atelier for Eclipse seems that will be discontinued, I decided to start moving my coding environment to Visual Studio Code. I kind of like it, and I'm getting used to it. But I can't find the way to have several server connections as I do in Eclipse, and so creating projects based on that servers. Is there any way to do it? Thanks a lot #Eclipse #VSCode #InterSystems IRIS #Open Exchange 0 14 0 3.2K
Question David.Satorres6134 · Feb 20, 2020 ECP status via $system.ECP Hi, I'm trying to get the ECP status of 2 servers using $system.ECP.GetProperty("ServerStats") and $system.ECP.GetProperty("ClientStats"), but I'm not able to find the documentation of the values returned: For example, on the server side I execute this: #ECP #InterSystems IRIS 0 3 0 342
Question David.Satorres6134 · Sep 12, 2019 Monitoring Activity Volume numbers Hi all,I recently discovered the Monitoring Activity Volume feature in IRIS and I was amazed by it. So, I put it to work in one of our productions. It is nice how easy it is to set up and all the possibilites that came with it.But there's something weird: the numbers. Actually, one of the BP is stating a time of more than 6 seconds to process: #Analytics #Monitoring #InterSystems IRIS 2 6 1 365
Question David.Satorres6134 · Aug 19, 2019 Queues refresh at IRIS 2019.1 Hi all,One of the most useful features for me in IRIS was the queue page. From there, I could see how the different elements (BS, BP & BO) from a production were behaving, thanks to the possibility of auto-refresh every second. Great thing.But we have updated to 2019.1 and this possibility is gone... we need to refresh manually! So, is there any way to set a parameter somewhere to have the queues status refreshed automatically?Thanks a lot. #InterSystems IRIS 0 1 2 372