Article Megumi Kakechi · Aug 15 3m read How to identify which temporary globals are consuming size in the IRISTEMP database InterSystems FAQ rubric Temporary globals stored in the IRISTEMP/CACHETEMP databases are used when a process does not need to store data indefinitely, but requires the powerful performance of globals. The IRISTEMP/CACHETEMP databases are not journaled, so using temporary globals does not create journal files. The system uses the IRISTEMP/CACHETEMP databases for temporary storage and are available to users for the same. #Globals #System Administration #Tips & Tricks #InterSystems IRIS #Caché #Ensemble #InterSystems IRIS for Health 2 0 3 129
Article Megumi Kakechi · Jul 18 1m read How to put application logs into the global ^ERRORS InterSystems FAQ rubric This can be done with TRY-CATCH: #ObjectScript #Tips & Tricks #InterSystems IRIS #Caché #Ensemble #InterSystems IRIS for Health 3 0 0 78
Article Megumi Kakechi · May 23 2m read TIMESTAMP type format InterSystems FAQ rubric The TIMESTAMP type corresponds to the %Library.TimeStamp data type (=%TimeStamp) in InterSystems products, and the format is YYYY-MM-DD HH:MM:SS.nnnnnnnnn. If you want to change the precision after the decimal point, set it using the following method. 1) Set system-wide #ObjectScript #SQL #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 1 0 0 121
Article Megumi Kakechi · Apr 18 1m read How to restore the prompt when an error occurs while running a program in the terminal InterSystems FAQ rubric When you run a routine in the terminal and an error occurs in the program, if you have not set the error trap properly, the program will enter debug mode as shown below. #Terminal #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 6 0 1 153
Article Megumi Kakechi · Jan 11 2m read What to do with the error 5369: Class is currently being compiled by process InterSystems FAQ rubric This error occurs when an instance of the class is already open at compile time. There are two ways to deal with this issue: Terminate the process or application that has the instance open Compile options in the studio build menu: Check the compile flag “Compile classes in use” and compile. If you want to determine which process is using the class, try the sample routine below. #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 4 1 0 166
Article Megumi Kakechi · Jan 4 1m read What to do when a large amount of memory is used while processing relationships InterSystems FAQ rubric If a relationship is set and there is a large number of n in a 1:n ratio, a large amount of memory may be consumed due to sequential processing of the relationship. After referencing a many-sided object in a program and internally swizzling it, simply releasing the variable containing the OREF (deleting it, setting another value, etc.) will not free the many-sided object and the relationship object. This is the cause. #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 3 0 0 231
Article Megumi Kakechi · Dec 7, 2023 2m read What to do if a <PROTECT> error occurs when importing a routine with % InterSystems FAQ rubric To resolve the error <PROTECT>, remove the read-only attribute of the system-wide library database (IRISLIB for InterSystems IRIS, CACHELIB for Caché/Ensemble/HealthShare (Caché-based)) Once you have finished importing the routine, remember to change it back to read-only. [Version 2013.1 and above][Management Portal] > [System Administration] > [Configuration] > [System Configuration] > [Local Database] Uncheck "Mount read-only" from the database name link. #System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 4 3 0 331
Article Megumi Kakechi · Nov 23, 2023 1m read How to execute the OS commands InterSystems FAQ rubric When executing OS commands, use $ZF(-100). #ObjectScript #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 4 2 1 383
Article Megumi Kakechi · Oct 19, 2023 2m read How to know the size of database cache (global buffer) in use InterSystems FAQ rubric A tool (^GLOBUFF utility) is available to check the database cache usage for each global variable. You can run the utility directly or programmatically in the %SYS namespace. Here's how to run the utility directly: #ObjectScript #Tips & Tricks #Tools #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 9 5 1 704
Article Megumi Kakechi · Sep 28, 2023 2m read How to save and restore images in an object using Base64 strings InterSystems FAQ rubric In the sample below, an image file is encoded into a Base64 string in a class property, saved, decoded again with Base64, and restored to another file. 【Usage class】 Class User.test Extends %Persistent { Property pics As %GlobalBinaryStream; } 【When importing】 #ObjectScript #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 7 2 2 485
Article Megumi Kakechi · Aug 24, 2023 1m read How to get database's free space programmatically InterSystems FAQ rubric You can see the free available space for the database using the radio button "Free Space View" in Management Portal: System Operation > Databases. And it can be obtained programmatically by the FreeSpace query of the system class SYS.Database. #Databases #System Administration #Tips & Tricks #Tools #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 2 0 1 239
Article Megumi Kakechi · Aug 10, 2023 2m read How to compare multiple globals and routines in two databases InterSystems FAQ rubric ※Use this method if you want to compare databases that have been replicated using mirroring, shadowing, or some other mechanism. You can use the DATACHECK utility to compare global variables. Please refer to the document below.Overview of DataCheck [IRIS] *** Routine comparisons use the system routine %RCMP or the Management Portal. Below is how to use it in the Management Portal. #System Administration #Tips & Tricks #Caché #InterSystems IRIS #InterSystems IRIS for Health 6 0 2 265
Article Megumi Kakechi · Aug 3, 2023 1m read How to customize web gateway error messages InterSystems FAQ rubric You can set individual error pages for the following Web Gateway error messages/system responses: server error server busy server unavailable server timeout connection closed Settings are made on the Web Gateway Management screen ([Management Portal] > [System Administration] > [Configuration] > [Web Gateway Management] > [Configuration] > [Default Parameters]). In the Error Page section of the Default Parameters menu, set the filename of the html page to display or the URL to redirect to when an error occurs. #CSP #Tips & Tricks #Web Gateway #InterSystems IRIS #InterSystems IRIS for Health 1 0 1 290
Article Megumi Kakechi · Jun 15, 2023 1m read How to delete the query cache programmatically InterSystems FAQ rubric Query cache can be purged programmatically using the Purge* methods of the %SYSTEM.SQL class. *For details of each method, please refer to the following documents. %SYSTEM.SQL class【IRIS】 %SYSTEM.SQL class #SQL #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 2 0 0 237
Article Megumi Kakechi · May 4, 2023 2m read Which processes do you need to monitor in Windows to check that InterSystems IRIS is working properly InterSystems FAQ rubric In Windows, set the processes with the following image names as monitoring targets. [irisdb.exe] contains important system processes.* Please refer to the attachment for how to check important system processes that should be monitored. [IRISservice.exe] #System Administration #Tips & Tricks #InterSystems IRIS #InterSystems IRIS for Health 1 0 1 271
Question Megumi Kakechi · Apr 21, 2022 Insert IRIS globals including Japanese into pandas dataframe I tried to convert IRIS globals to pandas dataframe. I can do it as follows if there are no Japanese included in globals, #Python #InterSystems IRIS 0 2 0 303
Question Megumi Kakechi · Apr 18, 2022 How to handle returned exception error object by Embedded Python method? How can I get the Python error object(exception return value) from the embedded python method?I have an embedded Python method like as below; #Embedded Python #InterSystems IRIS 0 9 2 664
Question Megumi Kakechi · Dec 26, 2016 Is it possible to build cube(source class:DataConnector) during source table updating? Hello,I have a question regarding Data Connector cube. #InterSystems IRIS BI (DeepSee) #Cubes #Listings 0 2 0 371
Question Megumi Kakechi · Jul 11, 2016 ZEN Mojo : file download code sample Hello, One of our AP would like us to provide the file upload/download sample code by using ZEN Mojo. I already provided them the attached "upload-sample". I tried to create the "download-sample" in a similar way, but I couldn't do it yet. Does anyone have a good idea/sample about this? I'd like to download the server side file(e.g. c:\temp\nene.jpg) into client machine with a OpenFileDialog(image.png). Thank you in advance. #Frontend #ZEN #Caché 0 6 0 886