Announcement Emily Geary · Sep 12, 2024

Hello Community,

The Certification Team of InterSystems Learning Services is excited to announce the release of our new InterSystems IRIS SQL Specialist exam. It is now available for purchase and scheduling in InterSystems exam catalog. Potential candidates can review the exam topics and the practice questions to help orient them to exam question approaches and content. Candidates who successfully pass the exam will receive a digital certification badge that can be shared on social media accounts like LinkedIn.  <--break->

0
1 179
Question Charles TETU · Sep 12, 2024

Hi there,I'm discovering IRIS and I need to POC the solution, with a constraint: containerization.I'm used to deploy my apps in a Swarm cluster, and all my bind volumes are written on a GlusterFS volume.The problem here, when I start my stack, the first log is:[WARN] ISC_DATA_DIRECTORY is located on a mount of type 'fuse.glusterfs' which is not supported, consider a named volume for '/iris_conf'And of course the deployment fails.Any idea? How can I provide my data on all my cluster nodes? I read this article: https://community.intersystems.com/post/deploying-sharded-cluster-docke…

0
0 138
Question Richard Prouvot · Sep 12, 2024

I have a DOS batch file that calls *.scr script to back up an existing routine and upload the newly updated one.

I have a backup folder setup in C:\Users\[username]\Backup\ on each server, some with more recent versions of cache. The *.scr script calls on the command:  $SYSTEM.OBJ.Export(routine,path) . 

0
0 168
Question Krishnaveni Kapu · Sep 11, 2024

I have an SQL table as below (columns - ID and Value)

I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID 

as -

if ID = 11 ; QRY output = aaa,bbb

if ID = 22 ; QRY output =  xxx,yyy,zzz

can someone help me with query 

ID    Value
----------
11    aaa
22    xxx
22    yyy
11    bbb
22    zzz
-----------
 

2
0 168
Question Mary George · Aug 2, 2024

Hi Team, 

Is there a way to search for a string or use of a function in all namespaces in one go.

Studio option "Search in files"/Ctrl+shift+F search all files in the current namespace. We have 13 namespaces and wanted to know if there is an easy way to search in all namespaces in one go. 

Thank you for your help 

7
0 455
Question Igor Barboza · Aug 15, 2024

Hello every one, here in our company we are trying to develop a tool to help us in our "Code Review" that today is completely done for another developer.So I need to develope a tool that reads a class/routine (Already done) and identify if in the current line there is some abbreviated command, that is against our policy of codification, for example:s variable = "test"d ..SomeMethod()So in this cases I want to warn the original developer that the code has parts that need to change the "s" to "Set" and de "d" to "Do".I tried to found some library in the documentation but with no success, if

6
2 254
Article sween · Sep 10, 2024 4m read

So if you are following from the previous post or dropping in now, let's segway to the world of eBPF applications and take a look at Parca, which builds on our brief investigation of performance bottlenecks using eBPF, but puts a killer app on top of your cluster to monitor all your iris workloads, continually, cluster wide!  

Continous Profiling with Parca, IRIS Workloads Cluster Wide

0
2 336
Question Victor Castanon · Sep 9, 2024

Hi there, I'm wondering if anyone has run into an issue with <FILEFULL> when building an image from the ISC image? Specifically what's happening in our build is we are pre-loading our codebase into the image to make deployments faster and setting up source control, etc. When loading our libraries however we get hit with a <FILEFULL>. The resource limits on docker are pretty beefy and when observing resources on both the machine and container level we don't hit any issues. Oddly, this only happens when using the ARM64 version. When using the AMD64 version of 2024.1 it builds fine but I need

3
0 193
Question Jignesh Patel · Sep 2, 2024

I am trying to login to InterSystems image repository but it is not recognizing following credentials from ubuntu.

docker login  https://containers.intersystems.com -u <username> -p <password>
WARNING! Using --password via the CLI is insecure. Use --password-stdin.
Error response from daemon: Get "https://containers.intersystems.com/v2/": unknown: Bad credentials

The same credentials works via website.

2
0 195
Question Gramen Tontchev · Aug 23, 2024

during an upgrade, a customer wants to load custom schemas in a particular order.
For this, they renamed a file EPIC_MDM.HL7 to 1EPIC_MDM.HL7
Upon importing this file into their server using VSCode, the custom schema was renamed to 1EPIC_MDM.HL7 inside the <Category>
This is impacting the upgrade and they are looking for a way to import a custom schema without renaming the schema itself.

2
0 109
Question Michael Lundberg · Sep 9, 2024

Hello to you!


Is it possible to write to Windows Eventlog with Object Script?

Tried a bit but having trouble getting it to work. If possible, I would be grateful for a piece of sample code

Regards Michael

3
0 158
Article sween · Sep 9, 2024 14m read

I attended Cloud Native Security Con in Seattle with full intention of crushing OTEL day, then perusing the subject of security applied to Cloud Native workloads the following days leading up to CTF as a professional excercise. This was happily upended by a new understanding of eBPF, which got my screens, career, workloads, and atitude a much needed upgrade with new approaches to solving workload problems. 

So I made it to the eBPF party and have been attending clinic after clinic on the subject ever since, here I would like to "unbox" eBPF as a technical solution, mapped directly to what we do in practice (even if its a bit off), and step through eBPF through my experimentation on supporting InterSystems IRIS Workloads, particularly on Kubernetes, but not necessarily void on standalone workloads.

eBee Steps with eBPF and InterSystems IRIS Workloads

0
3 374
Question Marcel den Ouden · Sep 4, 2024

An IRIS.DAT file was removed, as it was not needed anymore. But the database was mirrored, so it still shows up in the mirror monitor and database list. How can this be fixed? There is no backup of the .DAT file so it cannot be restored.

w##class(SYS.Mirror).RemoveMirroredDatabase("/mydir/")

throws a protect error.

(everything else works fine and this is not a production system, it only is annoying in the mirror monitor and database list)

3
0 267
Question Colin Brough · Aug 30, 2024

I can START and STOP a business process via its Schedule setting.

Is it possible to change the value of another Setting in an analogous way?

I can imagine a SettingSchedule that could look like 

action:YYYY-MM-DDThh:mm:ss[,action:YYYY-MM-DDThh:mm:ss]

But rather than just START or STOP, action could be "SET Setting = value", overriding whatever the normal value is.

Is there an existing way of achieving this kind of functionality?

4
0 177
Article Robert Cemper · Sep 7, 2024 1m read

You might know that you can search posts in DC by Tags
starting in left upper  corner   and  

that's fine to start. But - based on some local feedback - some improvements
might make is more useful. actual the SELECT works .. IF TAGS CONTAIN %tag 
This spams you with a lot of results but often much more than useful
so the suggestions for extensions:

0
0 122
Announcement Anastasia Dyubaylo · Sep 7, 2024
0
0 86