go to post Timo Lindenschmid · Jan 21 Hi So looking at those errors: First we have a process with an active transaction, that process crashed. So now the system is trying to rollback those transactions.Then the process conducting the rollback (pid: 10800) ran out of process memory (STORE error) Although i think the clean demon in the end was able to rollback the open transaction.
go to post Timo Lindenschmid · Jan 21 Hi Phillip, if IRIS is frozen/hung only way to see is via messages.log The freeze and thaw is recorded there.
go to post Timo Lindenschmid · Jan 17 Package names belong to the class names, so this is covered by the class names are case sensitive. In addition they have to by case-insensitive unique. e.g.TestClass and TESTClass would be valid class names but they are not unique as ToUPPER both read TESTCLASS same is true for package names and routines.
go to post Timo Lindenschmid · Dec 10, 2024 Hi Dmitrii, The automated export of changed files can be handled by %Studio.SourceControl.File, this would export any changed file on save and import the latest from disk on checkout. To automate import on a target system you can create a scheduled task that executes $system.OBJ.LoadDir regularly, this also per default compiles on load.
go to post Timo Lindenschmid · Dec 5, 2024 There is a setting in vscode for the objectscript extension, that allows you to modify the compile flags used. My current settings, which also triggers compilation of embedded SQL vs default behaviour to not compile embedded SQL. "objectscript.compileFlags": "cbk/compileembedded=1"
go to post Timo Lindenschmid · Nov 21, 2024 Hi, not sure about Veeam installing stuff etc. But i know some customers only backup the backup mirror, never the primary mirror as even with snapshot taking only a couple of seconds, QoS detection get triggered due to a slight performance degradation during the backup. If the backup is running against the Primary mirror, this then results in a forced failover being triggered.
go to post Timo Lindenschmid · Nov 17, 2024 Hi, 2 options:Is the locale set to DE in Iris, and have a look at this option: FastDistinct | Configuration Parameter File Reference | InterSystems IRIS Data Platform 2024.2But most probably its the FastDistinct default setting, you might want to disable that as per documentation.
go to post Timo Lindenschmid · Nov 15, 2024 Where you install IRIS depends on your use case. E.g. if you are "only" developing, no real user load the disc layout you would use is markedly different to a production system with 1000s concurrent connections. so just a couple of thoughts on disk layout: Install IRIS and every of its components in a dedicated folder e.g. /iris . Reasoning behind this is a single folder is easier to be excluded from any e.g. AntiMalware scanner that could wreak havoc on a database backend. In that subfolder separate data, file store, journals and executables. Reasoning: For a high-performance system each of above has a different i/o workload and a different performance profile. e.g. while journals are nearly 100% sequential writes, database executable are a mix of read and writes. Database files are also a mix of read and writes but usually much bigger block sizes. Also different filesystems have different performance profiles. So taking above in account also following best practises for mounts and i/o workload separation: root (/) /{instancename}/iris -> instance installation folder /{instancename}/journalPrimary /{instancename}/journalSecondary /{instancename}/database /{instancename}/filestore /{instancename}/webfiles Based on above you can mount volumes depending on workload sitting on different physical disks/lvms also for high performance environment you might want to separate the disc on multiple scsi controllers. So each controller only served a specific i/o profile. Also to note IRIS2021 changed the default disc i/o behaviour from use OS file cache to direct unbuffered i/o. Which again means separate IRIS workloads from any OS workload.
go to post Timo Lindenschmid · Nov 14, 2024 Hi, I guess you have written a custom extension using superclass %SYS.Monitor.SAM.Abstract?If so the method you are looking for is SetSensorLabels see doc here
go to post Timo Lindenschmid · Nov 8, 2024 The beauty of the IRIS technology stack is that code and data is withing the same instance. To separate code from data ISC uses the idea of code and data databases, which can be configured on a namespace level, this combined with global, package and routine mappings results in very versatile environment that should satisfy every need. If you want to actually separate compute from data storage, this is also possiple using the ECP protocol with dedicated app servers.
go to post Timo Lindenschmid · Oct 31, 2024 1. create a wrapper class with classmethods mapping to your routine(s) or better 2. convert your routines to classes then use $CLASSMETHOD | Caché ObjectScript Reference | Caché & Ensemble 2018.1.4 – 2018.1.9to call these dynamically. This also addresses the issue that xecute is highly risky from a security point of view, it can easily be targeted with injection attacks.
go to post Timo Lindenschmid · Oct 29, 2024 Hi Enrico, my sample code does that exactly. It takes number1 and converts it to a number than it compares the result to the original number1 field. Quirk of type conversion in ObjectScript if a value is converted from string to number ObjectScript walks the values from left to right and stops at the first non numeric character ie.123ABC becomes 123The if clause checks then if 123 = 123ABC so the org value is non numeric.Using && in the IF clause means do a logical AND check but short circuit the check ie. if condition 1 is already false go directly to the else clause and do not check cond2 and3
go to post Timo Lindenschmid · Oct 28, 2024 pure objectscript way no functions needed, we just use the IRIS type conversion behavior: set number1="123123" set number3="123123123 Not a pure number" if ((+number1=number1) && (+number2=number2) && (number1>=number2)) { set div=number1-number2 } else { w !,"Conditions not met" }
go to post Timo Lindenschmid · Oct 23, 2024 A simple health probe would be to have the LB poll /csp/mirror_status.cxw on the respective webserver it will return success if this webserver is connected to the active mirror and failed if its connected to the backup mirror.
go to post Timo Lindenschmid · Oct 23, 2024 Hi Fred, on the AWS instance what does the command "iris list" return?Also you can have a look at the messages.log file located at the <installDir>/mgr/messages.log This should give you an idea of what the issue is.
go to post Timo Lindenschmid · Oct 23, 2024 Hi, without knowing a bit more about what you are trying to achieve its difficult to advise. To export and reinstate a data structure including content you would need to export the storage class definition. After that you then can export the Global data and index storage defined by the storage class.To export you can use $system.OBJ.Export from a terminal/iris session. Then reimport using $system.OBJ.Load
go to post Timo Lindenschmid · Oct 22, 2024 Have you tried deleting the task using d ^TASKMGR ? This routine is available in the %SYS namespace, and you should login to terminal/session with a user that has %All access rights.
go to post Timo Lindenschmid · Oct 16, 2024 Hi Marykutty, depending on your use case. Usually, I would suggest going with Primary and BACKUP mirror plus arbiter for the optimal HA resilience. A webgateway on a dedicated IIS can serve both your application and the SMP. I usually would though consider having 2 webservers running so your single webserver is not the single point of failure.Also just to be aware webgateway is mirror aware and does not need a VIP to automatic redirect connections to the correct mirror. (refer documentation on mirroring )
go to post Timo Lindenschmid · Oct 10, 2024 very quick and dirty test, probably only works on small streams, also needs to actually read the whole stream for compare. # test compare - streams are same set stream1=##class(%Stream.TmpCharacter).%New() set stream2=##class(%Stream.TmpCharacter).%New() do stream1.WriteLine("ABC123") do stream2.WriteLine("ABC123") do stream1.Rewind() do stream2.Rewind() w (stream1.Read() = stream2.Read()) 1 # test compare - stream are different set stream1=##class(%Stream.TmpCharacter).%New() set stream2=##class(%Stream.TmpCharacter).%New() do stream1.WriteLine("ABC123") do stream2.WriteLine("DEF456") do stream1.Rewind() do stream2.Rewind() w (stream1.Read() = stream2.Read()) 0
go to post Timo Lindenschmid · Sep 19, 2024 Completely silent install an application can only happen during IRIS upgrade/install or by being creative with scheduled tasks. First step would be to automate installation of you application using a %Installer script refer to Documentation Fully automating it could involve a scheduled task checking a folder on the filesystem for the installer manifest and importing it.