Question David Satorres · May 31 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 #Caché #InterSystems IRIS 0 3 1 78
Question David Satorres · 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 0 1 0 198
Question David Satorres · 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 177
Question David Satorres · 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 #Caché #InterSystems IRIS 0 1 0 179
Question David Satorres · 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 186
Question David Satorres · 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... #Development Environment #JDBC #InterSystems IRIS 2 8 0 358
Question David Satorres · 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? #Caché #InterSystems IRIS 0 1 0 164
Question David Satorres · 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 #Caché #Ensemble #InterSystems IRIS 0 4 0 200
Question David Satorres · 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 887
Question David Satorres · 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 215