#InterSystems IRIS

Dear people,

I (really) spent hours on finding the maximum size a Global is allowed to be (for Windows, if that matters). All I seem to run into are database sizes (derived from a max number of blocks and block size), but I refuse to believe that is correct because too small to be realistic.  

It will  undoubtedly my fault that I don't understand or misread the concepts of "database" vs Globals, envisioning files as such while one set of functional Globals in one file (?

Hi Community,

I have created CSP page should show my Queue status.

Now I need to refresh this page every 5 min.(same like live score website) to reload new queue status.

Any tag in CSP will do this auto refresh?

Thanks,

Prashanth

I'm building a .Net Core Gateway container. Here's the issue.

As a final step I'm building a .Net Core 2.1 library. It has a runnable dependency - .Net Gateway, which I need to start first.

However dotnet publish generates .runtimeconfig.json and .deps.json only for my library and not for my dependency (.Net Gateway).

Is there a way to force dotnet to generate .runtimeconfig.json and .deps.json for a dependency?

With the latest improvements in support for Python in IRIS, and continued work on Python DB-API support by InterSystems. I've implemented IRIS support to the Django project where is Python DB-API is used to work with some other databases.

Let's try a simple application on Django, which stores its data in IRIS.

We are happy to share interesting information with you, as well as tell you why Python is good, where it is used.

Among the most used libraries are NumPy and Pandas. NumPy (Numerical Python) is used to sort large datasets. It simplifies mathematical operations and their vectorization on arrays. Pandas offers two data structures: Series (a list of elements) and Data Frames (a table with multiple columns). This library converts data into a Data Frame, allowing you to remove and add new columns, as well as perform various operations.

Hi Community,

for our forms validation we use XData to describe fields on server side.

These XData are in JSON like this

XData FormValidator [ MimeType = application/json ]
{
 {
  "username": {
   "required": true 
  },
  "email": {
   "datatype": "email"
  }
 }
}

When I try to use %JSON.Adaptor in same classes, IRIS throw an error at compile time

 ERROR #6301: SAX XML Parser Error: invalid document structure while processing Anonymous Stream at line 1 offset 23
  > ERROR #5490: Error running generator for method '%JSONGenerate:helora.worklist.

Voting time! 

Let's cast your votes for the best applications in the InterSystems Python Contest:

🔥 Vote for your favorites 🔥

How to vote? Details below.

Hey Developers,

We are pleased to invite you all to the next InterSystems online programming contest focused on Python! 

🏆 InterSystems Python Contest 🏆

Duration: February 7 - 27, 2022

In prizes: $10K - more prizes included!

In my article I described the work using iris.gref .
As the official documetation is rather slim on the subject it was necessary to dig into it.
Using the power of Python I was able to detect what I needed but was hidden.
I decided to share this with you. pydoc did the magic. 

Hey there,

I posted a reply to the recent video https://community.intersystems.com/post/new-video-building-data-driven-web-apps#comment-132511
with a slew of questions.  Wondering if someone can take a look a address my questions on that post or on this new thread.

I find many InterSystems learning to be challenging to follow, but I"m not sure if it's because my work computer is so locked down that I don't have all the right tools and permissions I need to do what the tutorial asks, or if I'm not understanding the basics of Cache/IRIS, or both!

Mike

We are planning to build a REST API with the Java Quarkus Framework.

• There'll be a connection pool;
• The DataSource instance will be automatically injected from the connection pool;
• We will use JDBI to do SQL instructions and this will give us automatic Connection and Statement management;

This Caché instance already have COS applications running and consuming connections and licenses.

After doing this, we will migrate to IRIS.

Is there any pitfalls that we must be aware before taking this approach?

If you want to see some code the PoC can be found here.

Thanks.

Hi contestants!

Here are the results of the bonus collections the applications of the Python Contest accomplished.

Here are the projects that scored it:

When designing a hierarchy in DeepSee, a child member must have only one parent member. In the case where a child corresponds to two parents, the results can become unreliable. In the case where two similar members exist, their keys must be changed so that they are unique. We will take a look at two examples to see when this happens and how to prevent it.

Example 1

There are a handful of states with a city named Boston. In my sample data, I have records from both Boston, MA and Boston, NY. My dimension is defined as:

City and State are simply strings in my case.

Hi!

Trying to create a string with $LB using Embedded Python.

Don't see the way to do it. If Embedded Python supports list builds?

It appears the link to download IRIS is down:
https://download.intersystems.com/download/login.csp

Hello All,

I am looking for some ideas from people who have automated alerting in place for their Ensemble or IRIS productions.  

I want to start with basic things like, simply checking if a Production is up and running. Once this has been achived, I am looking to go deeper and implement monitoring on each interface level for things like, Queue Size, Errors and Inactivity.

Would appreciate if you can share some ideas. I have been exploring http://localhost:52773/api/monitor/metrics but don't see anything in there that tells me whether my Production(s) are running ok or not.

Thank you.

Hi,

I'm using a DTL to convert a custom request class to various R4 FHIR resources using the HS.FHIR.DTL.vR4.Model.Resource classes. All is well with the exception of "meta.profile": when I attempt to hardcode this to a string value, the output is missing the value. This happens for several resources, specifically .HealthcareService, .Location, and .OrganizationAffiliation. I am able to get around this by doing an Insert() in a subsequent code block in a BPL, but was curious if someone knows why this would fail in a DTL.

Can we use BI.OCR as a plugin for some application platform such as JAVA and .Net

Hello,

I have a question about a problem calling a SOAP Web Service.

Indeed, to retrieve data via a Web Service, I need to make 4 calls, one to connect, one to place parameters, one to retrieve data and one to disconnect. Using the EnsLib.SOAP.OutboundAdapter class, I manage to make my first connection call but for the other calls I would need to keep my session cookie otherwise it doesn't consider me as connected. I know it's possible to do this in REST directly in the EnsLib.REST.OutboundAdapter class but I can't find a way to do it in SOAP.

Consider a Natural Key with an Identity (Serial) field.

I cannot seem to acquire the generated value after persisting my entity. That is, the returned entity by Spring Data's "save" does not have the generated value.

The value is generated by the database, and I can query it after repository.save(entity).

I have done some testing and created a Github repo with it...

https://github.com/jesjobom/iris-hibernate-key-test
Am I missing something?

We are on 2019.1 HealthShare Ensemble.  Has anyone upgraded from 2019.x to an IRIS version?  What was beneficial and the functionality you wanted and gained from the IRIS version.  How long was your downtime?

Good morning, Just wondering if anyone has had any experience with CMIS integration?  I am looking at a project to integrate an enterprise Content Management System with other CMS systems including windows folders for legacy documents not currently in a CMS.  I will be reading/updating the primary CMS using RESTful web services (system is cloud based).

Hello, first question for me:

Is there a way to use a class Parameter in embedded SQL without having to declare a local variable, in a similar way to how it is done with Property by preponing i% as described here. See my example:

Class Test.Test Extends %RegisteredObject
{ 
Parameter MyParam = "1";  
Property MyProperty;  
(...)
Method PerformQuery() {
    set myParamLocalVar = ..#MyParam //this is what I would like to avoid
    &sql(SELECT * FROM MY_TABLE
        WHERE MY_PROPERTY = :i%MyProperty
        AND MY_PARAM = :myParamLocalVar)
    (...)
}
}

We have a situation where we want to save the patient photo (or any other attachment) received via FHIR to a persistent property without decoding it. When it is sent out again using FHIR is is stored in the encoded format and need not be encoded. We do not need to decode it for our application. We always use it on another system that retrieves it or saves it via FHIR and therefore it is always received or sent embedded in JSON.

I'm trying to create a new Record Map but I keep getting a ZEN Exception error.  I actually go this to work the very first time I did it and have a record map.  But I need to do more.

I'm working on my local machine so I can grab a CSV (or txt in this case as it's pipe delimited) from the local directory.  I pick the file I want to use but when I click OK i get a popup and the following error:

Hi guys,

I'm starting few POCs to test InterSystems IRIS with a .Net core backend of an API Gateway and I have few questions about this integration.

• Which .Net library is the oficial? 
  • I found at least 3 options: packages from nuget website (https://www.nuget.org/profiles/InterSystemsCorporation - that I couldn't do them work), packages “IRISProviderCore.1.0.0.nupkg” and “IRISXEPCore.1.0.0.nupkg” inside “IRIS\dev\dotnet\bin\CorePackages” (Iris installation folder) and libs “InterSystems.Data.IRISClient.dll” and “InterSystems.Data.XEP.dll” at github sample project (https://github.

I would like to know any experience working with OPC UA standard in industry sector or IoT. Currently there is no adaptor implemented in IS IRIS for it but it seems to be pushed as the main standard in industry. Did anyone had to implement their own libraries or adaptors to deal with it? Or do you advice to use any already implemented library in Java, Python,...? Any feedback would be appreciated. 

I have production and workflow on Ensemble, but I need to update instance to IRIS 2018.1.1.

Do you know how to move workflow tasks from Ensemble 2017.1 to IRIS 2018.1.1?

Or maybe you know how to move tasks between two instances? 

How to check if the password is strong enough, so it will not be cracked very fast? And how to make a strong password?

I've developed a tool that may help with this. You can find it on OpenExchange. Install it with zpm

zpm "install passwords-tool"

This module will install just one class caretdev.Passwords, which contains a few helpful methods in it

Secure Password

To get a secure password it's usually enough to use letters in upper and lower case, digits, and special symbols, and it should be at least 8 symbols long.

Let's consider you would like to efficiently store your historical data in a similar structure than the one used for your current data, but without sharing the same physical storage (ie : not in the same global). What is the most efficient way to do it ?

Below a simple class of your current data : 

Class data.current.person Extends (%Persistent, %Populate)
{
Parameter DEFAULTGLOBAL = "^on.