InterSystems Official Benjamin De Boe · Jan 11, 2024

InterSystems is pleased to announce the General Availability of InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML, two foundational services for developing cloud-native solutions powered by the proven, enterprise-class performance and reliability of InterSystems IRIS technology. 

InterSystems IRIS Cloud SQL is a fully managed cloud service that brings the power of InterSystems IRIS relational database capabilities used by thousands of enterprise customers to a broad audience of application developers and data professionals. InterSystems IRIS Cloud IntegratedML is an option

2
0 398
Announcement Alki Iliopoulou · Dec 22, 2023

Hi Community,

Round 2 of the GenAI Crowdsourcing Mini-Contest is here! Everyone can join, even if you missed Round 1. You have $5 million in fantasy funds to invest in up to 5 promising submissions.

🎁 Rewards

  • The top-funded submission of Round 1 will emerge victorious.
  • The mastermind of the winning concept earns 5,000 points, while 3 astute "investor(s)" backing the winning idea get a chance to receive 200 bonus points each.

Dive into the game, strategically allocate your virtual investments, and aim for maximum returns! Deadline: Dec 31st, 2023

5
2 384
Discussion Stefan Cronje · Dec 15, 2023

Hi all,

The last time I used CSP was back in 2008, so I am very rusty on it.
This question might have been asked many times, and the answer probably is that it is a matter of preference.

Are there scenarios to which CSP pages is easier/better to use than classes extending from %CSP.Page?
I want to build a little thing and don't want to start at the wrong end.
Doing an API-based, heavy client-side framework is not a requirement, and I would prefer not to do it that way.

Some of the criteria

  • Users need to do a login.
  • RBAC per page using the instance's Users, Roles and Resources
  • Call some
4
0 388
Question Stefan Cronje · Dec 15, 2023

HI *,

So last night I was doing a deployment which had a query to select from a large dataset of joined tables, to iterate through and populate data in a new table.

This was done in a classmethod using embedded SQL and the %PARALLEL keyword.
On a testing environment with the same dataset, this worked perfectly a few days earlier.

It was going to be a long-running process, so we started it from a csession using the JOB command.
Then get the PID with $zchild, go to Processes and monitor it there.
It would terminate after a minute or so with a <STORE> error.
The per process memory is set at 1GB.

2
0 332
Question Sandeep K C · Jan 10, 2024

Hello Guys,

Our cache application uses REST web services and handles single API request perfectly with response (response status and related data). But sometimes user sends multiple requests to the same API simultaneously ( ie, without waiting for the first to respond ), where one request will succeed (not necessarily the first) and the others will fail. 
So, I need to handle the requests one by one after completing and sending the response for first request in the queue then process the next request and so on.

Is there any appropriate way of handling this problem? 

I found that, cache supports mu

4
0 463
Announcement Larry Finlayson · Jan 10, 2024

Developing with InterSystems Objects and SQL – IN PERSON (Cambridge office) February 12-16, 2024   9:00am-5:00pm US-Eastern Time (EST)

  • This 5-day course teaches programmers how to use the tools and techniques within the InterSystems development environment to build high-performance transactional applications. Learners build a complex application using an IDE, object-oriented design, SQL and unit testing.
  • This course is applicable for users of InterSystems IRIS Data Platform and Caché.
  • Many benefits are offered by being physically in the classroom with our instructors for a more
0
0 158
Question Conor Browne · Nov 17, 2016

Hoping someone can help,

I have the "Sample FHIR Production" installed ( as described in the documentation) with the following Components:

Service: HS.Gateway.ECR.SDA3XMLFileService

Processes: HS.FHIR.FromSDA.DTL.Transaction.Process

Operations: HS.FHIR.Repository.Operations

When a patient's data gets updated in my application a new SDA3 message is generated and processed by the FromSDA DTL.The Repository Stores that data as a New patient ( i.e.when I query the Repo they have different IDs "resource":{ "resourceType":"Patient", "id":"4", ) .

5
0 1088
Question Logan Kitchen · Dec 22, 2023

I am trying to get data out of a cache backup. I am completely new to Intersystems Cache.
I got a docker image of Cache from this post: 
I want to get the data from my backup into this docker image. First, I need access to a gui and a cli, then I need some instructions or documentation for actually pulling in the backup data.
Thanks! This is all new, so pardon my lack of knowledge here. If I can provide any more information let me know.

3
0 318
Question Lewis Houlden · Jun 30, 2023

Hello

We are in the process of upgrading to 2023.1 for InterSystems Health Connect, and the Business Rule Engine editor is very difficult to use compared to 2022.1. It's difficult to scan over the rules as it all looks the same style with barely any distinction between rules, constraints, conditions, whens etc. There's also tonnes of whitespace, and searching on the page is hit and miss (using Ctrl + F) . I can see the previous editor is still available when you modify the URL, but I'm wondering if we can set it to be the default editor, and if this is something supported.

Thanks

Lewis

7
1 665
Announcement Anastasia Dyubaylo · Jan 8, 2024
Hey Community,
Please check out the 2023 Annual Dev Community Article Digest with the most popular and commented articles. 
Thank you all for your contributions to the InterSystems Community in 2023!
Overall Stats - All Communities:
3,675 posts published in 2023:
 1,413 articles
 1,050 announcements
 1,147 questions
 65 discussions

4,737 members joined the Developer Community in 2023
19,063 posts published in total
10,995 members joined in total

2
0 226
Question Sylvain Guilbaud · Jan 5, 2024

Hello,

I have been facing a problem for several months, I have several flows that work in SFTP with the iris class EnsLib.FTP.PassthroughService

The problem is that from time to time I get an error message that says:

"A connection could not be established because the target computer expressly refused it"

I had the case for a server at our house and we solved the problem by extending the call interval parameter to 60 seconds,

However I have the same error for an external server with exactly the same configuration as the first flow, I contacted their infrastructure department who told me that an

3
0 461
Article Muhammad Waseem · Jan 9, 2024 9m read

  Hi, Community!

Since this article is an overview of Flask Login, let's begin with Flask Introduction!

What is Flask?

In the realm of web development, Python has emerged as a formidable force, offering its versatility and robustness to create dynamic and scalable applications. For that reason, tools and services compatible with this language are in demand these days. Flask is a lightweight and easy-to-use web framework for Python. It stands out as a lightweight and user-friendly option. Its simplicity and flexibility have made it a popular choice for developers, particularly for creating smaller-scale applications. It is based on the Werkzeug toolkit and provides a simple but powerful API for building web applications. 
Unlike its full-stack counterparts, Flask provides a core set of features, focusing on URL routing, template rendering, and request handling. This minimalist approach makes Flask lightweight and easy to learn, allowing developers to build web applications quickly and without the burden of unnecessary complexity.

0
1 1953
Question Sylvain Guilbaud · Aug 23, 2023

Is it planned that LOAD DATA takes into account several DATE/DATETIME formats with, for example, a parameter indicating the format used in the source data?

example :

LOAD DATA .../...
USING
{
  "from": {
    "file": {
       "dateformat": "DD/MM/YYYY"
    }
  }
}
3
0 263
Question liu yanjie · Jan 7, 2024

Hi all,
Does anyone have experience with obtaining logs from Caché databases and parsing them now? Please leave me a message.

I ask because my project involves some hospitals that used Caché when creating databases over 10 years ago. Currently, we cannot replace the database, but we need to check and parse the database logs from the Caché.

Thanks.

12
0 294
Article Evgeny Shvarov · Apr 4, 2023 2m read

Hi developers!

As you know InterSystems IRIS besides globals, object, document and XML data-models also support relational where SQL is expected as a language to deal with the data.

And as in other relational DBMS InterSystems IRIS has its own dialect.

I start this post to support an SQL cheatsheet and invite you to share your favorites - I'll update the content upon incoming comments.

Here we go!

26
7 1646
Question Ephraim Malane · Jan 8, 2024

Hi Community,

I hope this message finds you well. I am reaching out because I have encountered an issue with a new dimension I created, named "Region," and I could use your assistance in resolving it.

The problem is that when I open the cube analyzer, the "Region" dimension does not populate data as expected. Instead, it merely displays the text "sourceRegion," which I specified as an expression in the architect. 

To provide a bit more context, my intention in creating this dimension was to incorporate data from the Health care facility relational table into the cube.

1
0 182
Article Sylvain Guilbaud · Jan 8, 2024 3m read

Hello Community,

When using an SQL type Business Service, it may happen that we need to replay certain rows from the source table.

Let's take as an example the Business Service "from customer SQL" using the generic class EnsLib.SQL.Service.GenericService

Different cases arise, depending on the settings used on this Business Service.

First case :

If the Business Service only uses a KeyFieldName

In this case, to reprocess IDs 123, 456 and 789, it will be enough to delete them from the global ^Ens.AppData for the Business Service concerned on the "adaptor.sqlrow" reference:

kill^Ens.AppData("from
0
1 449
Question Lucas Galdino · Jan 6, 2024

Dear experts,

I'm trying exported a project from version '2012.5' to '2018.1.4' but is returning ERROR #7602.
Please, could you help me. How can I do it?
Below is steps that I did:

ACB>D $System.OBJ.Load("C:\GlobalPatch.xml")
 
Load started on 01/07/2024 00:06:51
Loading file C:\GlobalPatch.xml as xml
Imported global: ^GlobalPatch
Load finished successfully.
 
ACB>Set sc = ##class(%Studio.Project).InstallFromGbl("^GlobalPatch","fv")
ERROR #7602: Exported on version '2012.5' but this machine on version '2018.1.4' so unable to import

Thank you.

3
0 212
Announcement Anastasia Dyubaylo · Jan 6, 2024
2
0 177
Question Daniel Aguilar · Dec 4, 2023

Hello, How are you doing?

I'm currently developing a proyect in wich I want to use %SYSTEM.Event to process queues. I realized that if a queue has events pending to be sent to the listeners, when I restart the cube the queue with all its events are deleted.

Is there a way to store the queue with their messages in a Global?

I've checked the documentation but I can't find any option for this prupose.

https://docs.intersystems.com/supplychainlatest/csp/documatic/%25CSP.Do…

Thank you!

10
0 399
Question David McPfimeloronti · Dec 18, 2023

in Management Portal on Freespace screen there are links to compact and truncate a database.

Can these tasks be done programmatically?  I have looked through documentation and dont see anything but I hope I just missed it.

Thanks,

David

6
1 592
Announcement Sylvain Guilbaud · Jan 5, 2024

Hello Community!

Take advantage of watching the new video to discover the innovative solution which strengthens communication between community medicine and hospital practitioners for better patient care in the context of semi-emergency and contributes to the relief of emergency services in the region of Mayenne in France.

📺 MayVilleHop, the new City Hospital coordination platform

0
0 132
Question Julian Matthews · Dec 21, 2023

Hi everyone.

I have a few processes where I rely on them being triggered by a schedule to run, and in the past I have relied on the following setup:

The Scheduled Task is a custom class that runs a minimal amount of code to simply create and send the specified service an Ens.Request, and equally the Service is also a custom class that simply passes the Ens.Request to the Process for it to kick the process off.

As scheduled tasks need to be configured on a per-mirror basis, I'd like to do away with it completely and simply have a service that just sends the Ens.Request to the Process based on a

8
0 660