#InterSystems IRIS

Recently @Anastasia.Dyubaylopublished a post (this one) showing a new IntegratedML functionality for time series predictions that @tomdalready presented to us at the Global Summit 2023 so, let's go to set up a small workshop to test it!

Introduction

For this workshop we have chosen as the topic the prediction of monthly users of the Valencia Metro line by line. To do this, we have monthly data broken down by lines since 2022 as well as annual data by lines since 2017 that we will extrapolate monthly.

Does anyone have experience compacting and truncating IRIS datasets that are greater than 10 TB in size?  How long did it take and what was the size?  Did you run into any issues?  

Thanks.

Diane

I am currently using IKO 3.6 to deploy an irisCluster on EKS, but I am facing some challenges. Firstly, I need assistance in understanding how to connect to the Web Gateway sidecar. If anyone has experience with this, I would greatly appreciate any guidance or advice you can offer. Secondly, I am trying to utilize the 'seed: path' options of irisDatabases, but I am unsure of the best approach. If anyone has successfully implemented this feature, I would love to hear about your approach and any insights you can provide. Thank you in advance for any help you can offer!

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems Cloud Services - InterSystems IRIS SQL & IntegratedML @ Global Summit 2023

Using the Windows Subsystem for Linux (WSL2), is it possible to install IRIS and run it from there? I am wanting to test IAM, but unable to run Docker Desktop on my VM, and do not have access to a Linux machine to install and test with.

Thanks

Scott

Hi All,

In the below code, How to Add SSLConfiguration and TLS. Please advise.

My sample code.

set s=##class(%Net.SMTP).%New()
;set auth=##class(%Net.Authenticator).%New() 
;set auth.UserName=[["myUser"]]
;set auth.Password=[["myPassword"]]
;set s.authenticator=auth
set s.smtpserver="relay.abc.com"
set s.timezone="-0400" 
set m=##class(%Net.MailMessage).%New()
set m.From="test@company.com"
do m.To.Insert("kumars@test.com")
do m.To.Insert("test1@another.com")
set m.Subject="Test IRIS mail 1"  
do m.TextData.Write("This message has been sent using an SMTP server ")
set status=s.

Welcome back to %SYS! If you read the first article in this series, you must have already seen how to manage your users through the Security.Users class programmatically. Today, we will move on to Resources! Many of the classes in this package use a very similar set of methods. That means that the more we cover, the more familiar you will feel about the subject.

Users are a bit complicated and have a lot of options. Resources, on the other hand, are much simpler. They have names that can be chosen from almost anything you can come up with. However, there are a handful of rules to keep in mind.

When we add a new class in VSCode, the name automatically is set to <Folder>.<Filename>.

Because we are doing interoperability, we remove the default and type "interop" to get assistance on creating the class. This works fine on some machines, however on others it generates:

/// Description
Class C:\InterSystems\Training\src\Test.MyProd Extends Ens.Production
{ ...

So it uses the full pathname instead of Test.MyProd.

I guess it is a setting somewhere (settings.json?

Hi All,

is there any way how to hide or remove storage "Histogram" section in the file with persistent class definition, but keep the data both in globals and sql table?
The reason is that we use on-premise version control system and since the data is sensitive, it cannot be uploaded along with the files.

I have already tried "NoExtent" keyword, but that does remove the sql table and just keeps the data only in globals. The only solution I have come up with so far is to remove all the "property" sections from storage in file everytime before committing changes.

Hello Community,

Let us invite you to watch the recording of the webinar: 

👉 Developing an AI Powered IRIS Application, in Python 👈

Hi Community,

to learn quickly and in total autonomy on IRIS, I offer you some links which can help you in this beautiful bicycle ride rich in discoveries:

1. InterSystems Developer Hub​​​​​​
   • Full Stack TutorialBuild the IT infrastructure for a company that roasts and sells coffee.

The related package avoids adding %JSONAdaptor to each class but uses  instead   
SQL functions JSON_OBJECT() to create my JSON objects. With this approach, you can   
add JSON to any class - even deployed ones - without any need for change or recompiling.

The trigger was the Export of M:N relationships  as JSON  objects or arrays.

Hi everyone,

Today I have a simple yet potentially valuable question: How can I begin a new line of text within $$$LOGINFO or $$$TRACE?

For instance, if I need to display a long log message within the visual trace, is it possible to do something like this:

$$$LOGINFO("object: 'This is a try'"
    _"this is the second line with an example parameter: "_x
    _"this is the third line with an example parameter: "_y
    ")

Does anyone know if such a feature exists? It has the potential to greatly enhance code readability and layout.

Thanks :) 

Hello,

I begin to work with VSCode and all is ok but i have just one problem with ObjectscriptQuality plugin. I have no feedback in the problem tab using the objectScriptQuality plugin.

I only have feedback from InterSystems Language Server plugin. Where could the problem come from?

My goal is to use objectscriptQyality with the basic rules at first

I work with iris 22.3

SQL inbound service execute using schedule task it ends up with error when end time occurs.

Normally task run from 10 to 10:30 every day.

Error in Log: ERROR <Ens>ErrException: <INVALID OREF>%OnClose+10^EnsLib.SQL.GatewayResultSet.1 -- logged as '-' number - @''

Please suggest..

I want to create a folder directory through code, but I don't know how to write it

Hi folks

I want to tell you how you can make your own assistant based on IRIS and OpenAI (perhaps you can then move to your own AI models)

iris-recorder-helper

This is the first time I have fully tried developing an application for IRIS and I want to point out steps that may also be useful to you

1. Deploy to google cloud via github workflows (One container with an IRIS database and a web server in Python (flask)) and placing secrets inside the application not through an environment variable
2. Record audio from the browser and send to the server
3. Launching cron jobs via the ZPM module
4. Integration with OpenAi

First, about the application itself

You can try it using the link and see how it works - https://iris-recorder-helper.

Currently I have a program that is going to be used to compare global nodes between namespaces. Using nested FOR statements I am stepping through global nodes and comparing between the namespaces, if the global values are different I then parse the node comparing each delimited segment.

This is working.

I want to now be able to set what global I am in as a variable to expand on this concept. 

Program architecture

1.Initializing program that has user prompts to change starting nodes. This program contains the FOR nests to step through nodes.

Hi,

I am trying to find out individual segment values in Message viewer and it display the values in Management portal, copied the query and run it on SQL editor, Segment values displayed with blank. Is there a way to get the individual segment values using query?

Yet another example of applying LangChain to give some inspiration for new community Grand Prix contest.

I was initially looking to build a chain to achieve dynamic search of html of documentation site, but in the end it was simpler to borg the static PDFs instead.

Create new virtual environment

mkdir chainpdf

cd chainpdf

python -m venv .

I'm at a loss with configuring the IRIS ODBC driver (v02.10) on my Amazon Linux machine, connecting to a REMOTE IRIS backend.  It should be simplified by not requiring a DSN (the app uses a DSN-less connection and generates the connection string).  I have

• Downloaded and unpacked iris-driver-distribution/ODBC/lnxrh7/ODBC-2022.1.0.209.0-lnxrh7x64.tar.gz at main · intersystems-community/iris-driver-distribution · GitHub
• Followed the instructions at Defining an ODBC Data Source on UNIX® | Using the InterSystems ODBC Driver | InterSystems IRIS Data Platform 2023.

InterSystems FAQ rubric

The meaning of each timeout value is as follows.

1. [Server response timeout]

If IRIS/Caché processing (routine or query execution) does not finish within this set time, the browser will return an error.

For example, if this value is 60 seconds and it takes 90 seconds to execute a routine/method/query, an error will occur.

2. [Queued request timeout]

For each IRIS/Caché server configured in CSP/REST, you can limit the number of processes that can run CSP/REST concurrently.

My original ZAUTHENTICATE.mac to use Delegated sign on did not include GetCredentials(), however I am being told it probably should have it so I am eliminate an error I am seeing when trying to troubleshoot the ZAUTHENTICATION. I am trying to add the GetCredentials() from the documentation to the existing ZAUTHENTICATE.mac  but I am getting an error

GetCredentials(ServiceName,Namespace,Username,Password,Credentials) Public {

  // For console sessions, authenticate as _SYSTEM.
  If ServiceName="%Service_Console" {
    Set Username="_SYSTEM"
    Set Password="SYS"
    Quit $SYSTEMStatus.

InterSystems announces its first developer preview for the 2023.3 release of InterSystems IRIS^® and InterSystems IRIS for Health^TM.

Future preview releases are expected to be updated biweekly and we will add features as they are ready.

Please share your feedback through the Developer Community so we can build a better product together. Initial documentation can be found at these links below.

Why to use it

This app offers an easy interface to analyze storage:

• Filter by database (namespace), global name, used size, or allocated size;
• View a sum of the used and allocated sizes for the filters applied;
• Export the table to JSON, CSV, or XML.

How to use it

Follow the instructions on the README file from the GitHub repository, and configure the settings to connect to your instance.

How to adapt it to your needs

Since it was built with Python and Django, you can easily add specific analysis methods in the api/methods.py and use the views on views.py to display them.

In the ever-evolving landscape of data science and machine learning, having the right tools at your disposal can make all the difference. In this article, we want to shine a spotlight on two essential Python libraries that have become indispensable for data scientists and machine learning practitioners alike: Matplotlib and scikit-learn.

Matplotlib: Crafting Visualizations with Precision

Matplotlib is a versatile and powerful library for creating static, animated, and interactive visualizations in Python.

Hello developers!

We are holding the first technical article contest on Japan's InterSystems Developer Community!

The first contest is a technical document writing contest, and you can submit any content related to the InterSystems IRIS/InterSystems IRIS for Health. (The article must be in Japanese.)

✍ InterSystems Japan Technical Document Writing Contest: Articles related to IRIS ✍

🎁 Participation prize: There will be a participation prize for everyone who submits an article for the contest.

🏆 Special prize: Authors of three selected works will receive special prizes.

Entering the contest is easy! Please post an article related to IRIS on the developer community during the period from Wednesday, September 6, 2023 to Monday, November 6, 2023.

Hi Interoperability experts!

Recently noticed an interesting conceptual discussion in our Interoperability Discord channel to which I want to give more exposure.

All we know that typical InterSystems Interoperability production consists of the following chain:

Inbound adapter->Business Service->Business Process->Business Operation->Outbound adapter.

And Business Process (BO) here is always considered as a passive "listener" either on port/folder/rest API for an incoming data.

Hello to all developers and IRIS users. I am submitting to the competition a project for an alternative IRIS management portal that I have long wanted to create. The project was implemented on the Django framework and the intersystems_irispython-3.2.0-py3-none-any.whl library using native IRIS. The Django project is integrated with the telegram messenger and can be launched from a docker container or directly. To run it, you need to create a .env file in the project root for which you can use the .env_example example.

DJANGO_DEBUG=True
DATABASE_URL=sqlite:///db.

Doing a new project with %JSON.Adaptor, unexpectedly realized that %JSON.Adaptor does not support export to native JSON. %JSONExport just outputs directly to the current device, and there are two more methods %JSONExportToString, and %JSONExportToStream.

In conjunction with generating REST from swagger specification, where any generated method accepts as a result %DynamicObject, which is good. 

I have multiple places in my REST where I have to return JSON for an object, but I have to modify the result a bit, just extend it with some other way.