Announcement Henry Pereira · Mar 27, 2020

SQLBuilder is a flexible and powerful SQL query string builder for InterSystems IRIS,

With SQLBuilder you have nice and clean object oriented methods, instead of having to use concatenation and substituition to generate dynamic queries.

A Dynamic SQL without SQLBuilder

A Dynamic SQL with SQLBuilder

If you like it, don't forget to vote in the IRIS Programming Contest

18
5 810
Announcement Larry Finlayson · Jul 24, 2023

Managing InterSystems Servers - Virtual  August 14-18, 2023   9:00am-5:00pm US-Eastern Time (EDT)

  • This five-day course teaches system and database administrators how to install, configure and secure InterSystems server software, configure for high availability and disaster recovery, and monitor the system. Students also learn troubleshooting techniques.
  • This course is applicable to both InterSystems IRIS and Caché. Although the course is mostly platform independent, students can complete the exercises using either Windows or Ubuntu.

Self Register Here

0
0 115
Article Yuri Marx · Jul 19, 2023 8m read

Hibernate is the most popular framework to do ORM (Object Relational Mapping) projects. With Hibernate a software can use the main DBMS in the market, including the capability to change the database vendor any time, without source code impact. This is possible because the Hibernate supports dialects. Each database product has a different dialect that can be assigned into a configuration file. So, if a software is using Oracle and is looking to evolve to InterSystems IRIS, just change the configuration file with connection and dialect information. If your software needs to be prepared to use da











7
3 1044
Article Guillaume Rongier · Jul 24, 2023 20m read

k8sfhir

This is a sample to deploy iris-oauth-fhir on k3d with IKO.

  • iris-oauth-fhir is a sample to deploy a FHIR server with OAuth2 authentication with InterSystems IRIS for Health as a resource server and Google OpenId as an authorization server.
  • k3d is a lightweight wrapper to run k3s (Rancher Lab's minimal Kubernetes distribution) in docker.
  • IKO is a tool to deploy InterSystems IRIS for Health on Kubernetes.
0
2 669
Question Norman W. Freeman · Jul 18, 2023

Hello,

I am looking for information about garbage collector. I already looked at documentation but I could not find anything about it.
Here is some questions :

1) is there a garbage collector per process (each process has it's own memory and GC is done per process) or is it global (eg: shared memory) ?
I know there is some memory allocated per process at startup but also globally (gmheap).
2) when a GC / cleanup occurs somewhere,  is it possible that it block the other processes for a short moment ? (eg: a "stop the world" GC that pause everything while job is being done).
3) is it possible to g

3
0 486
Announcement Elena E · Jul 24, 2023

We're excited to announce a new feature on Open Exchange - app dependencies. Now, when you visit an app's page, you can easily see which other Open Exchange apps it depends on and which apps depend on it. This information is conveniently available in respective tabs, providing you with valuable insights.

The best part is, we automatically gather this information from IPM data, eliminating the need for manual data entry when submitting or managing your app. 

Your feedback is highly appreciated! Comment or DM us your thoughts.

Thanks!

0
0 203
Question Jude Mukkadayil · Jul 14, 2023

Hi,

     I am trying to load all the data tables from one iris server to a client server but some of the tables data failing to load all the time. But I can load around 100 tables successfully  but 8 to 10 tables are failing all the time. I made an IRIS odbc connection using odbc driver to load the data from tables.

Also I can see read server loop error message on the iris server side as the same time the table loading fails.

Please find the screen shot attached which shows the error on client server.

 

Can anyone provide me an advise how to fix the issue.

Thanks

Jude

15
0 1427
Question Jon Astle · Jul 20, 2023

Hi

We've been asked to develop a HL7 interface, but the end system has very different needs than any we've ever interfaced with before. We need assistance to determine if these needs are things HealthShare can support that we're just not aware of, or whether we'll need to develop some custom code to accomplish this.

This end system wants us to send HL7 messages completely asynchronously, one after the other without waiting for any form of ACK or NAK. My first thought was that we could have an outbound HL7 operation which set the session to deferred, with a separate inbound listener service on

4
0 580
Question Guilherme Koerber · Jul 19, 2023

Hello community,

I am developing a call that contains some properties in an Ens.Request class like this:

Class Linx.Omni.Operation.Apigee.Fidelidade.Msg.ProcessaVendaReq Extends Ens.Request
{

Property Bandeira As%String(MAXLEN = "");Property CodigoLoja As%String(MAXLEN = "");Property CpfCliente As%String(MAXLEN = "");Property ListaItens As list Of Linx.Omni.VO.Origem.Fidelidade.ProcessaVendaFidelidadeNew;
Storage Default
{
...

I am creating a new request and calling it as follows (I removed some code snippets for better visualization):

Method ChamaProcessaVendaFidelidadeNew


7
0 423
Question Pavan Kumar Rayudu · Jul 19, 2023

Iris DAT file is filling up  the Internal Storage with available Free Space to Zero. Is there any Alternative measures to reduce the File size or to control the Capacity.  Is there any chance to save Local storage. 

Once the Local Storage is full, Production is not responding and throwing Out of Space Error.

Does IRIS has any Internal Cloud Storage which can be used for managing and Storing  Database Operations. If yes, How can we configure it,

5
0 330
Question Scott Roth · Jul 20, 2023

I am trying to setup our first SSL/TLS configuration so we can possibly connect to the EMR FHIR server to pull data into the Interoperability engine.

I am running on Red Hat, and created and submitted a openssl CSR request to our Windows ADCS system.

I used the following command to generate the key and CSR request to submit to Windows ADCS

openssl req -new -sha512 -nodes -newkey rsa:4096 -keyout xxxxxxx.key -out xxxxxxxx.csr

When the certificate was generated I was able to download the individual certificate (cer) and the certificate chain (p7b) in  DER or Base64. I downloaded everything i

1
0 819
Job Preston Brown · Jul 20, 2023

The Database Administrator’s responsibilities will include, but are not limited to:
• Monitor systems logs, report abnormalities and troubleshoot.
• Monitor database backups, modify when needed.
• Monitor file system space.
• Perform support and maintenance of existing Cache deployment, analysis, and migration of existing Cache code to Microsoft SQL; and Web Services (SOA).

REQUIRED SKILLS/EXPERIENCE:

A minimum of proven 4 years of experience in database administration planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement,

0
0 306
Job Preston Brown · Jul 20, 2023

SCOPE OF SERVICES:
The Database Developer’s responsibilities will include, but are not limited to:
• To perform support and maintenance of existing Cache code
• Analysis and migration of existing Cache code to Microsoft SQL; and Web Services (SOA)

REQUIRED SKILLS/EXPERIENCE:

A minimum of 5 proven years of experience in computer applications development planning, design, troubleshooting, integration, maintenance, and enhancement of Cache Database applications.

Related required skills:
• Object Script
• Cache Routines, Queries, Class Methods
• SQL
• Globals
• RedHat Linux

Excellent communication s

0
0 300
Question Michael Davidovich · Jun 2, 2023

This is a bit of an IRIS question but also and OAuth 2.0 questions:

I am using %OAuth2.JWT.JWTToObject() to "validate" a JWT.  My questions:

- While I am checking claims with the returned body, does the return status of the method "count" as a validation step? In other words, if I weren't checking claims and $$$OK was returned from that method call (passing in the token and public keys), I could feel confident that this token came from the expected auth server?

- Does the method or can it validate the token expiration or is that something I need to manually validate; token expiration seems

4
0 393
Article Anastasia Dyubaylo · Jul 20, 2023 1m read

Hey Developers,

If you wish to know how you're doing in the Community and see your stats, you don't need to scroll through all your posts in your profile (though it is also possible). You can use the Online Analytics Dashboard. In it you can see your own detailed statistics for the current week, month, and all time, including:

  • number of views, likes, comments, followers
  • timeline graphics of views, likes, actions with your posts, comments
  • a table containing info about views, comments, and likes for your every post

0
0 271
Question Michael Davidovich · Jan 31, 2023

When manually coding REST services and using GET /api/mgmnt/v1/:namespace/spec/:application/ to return an OpenAPI spec, how do you specify supported properties (OpenAPI Properties in Use | Creating REST Services | InterSystems IRIS Data Platform 2021.1) like responses, definitions, and information in paths like summary and description?

GET /api/mgmnt/v1/:namespace/spec/:application/ | Creating REST Services | InterSystems IRIS Data Platform 2022.2

Using a very basic manual REST service that returns a JSON string I get a pretty basic spec that is not really helpful when it comes to documentat

7
1 401
Announcement Elena E · Jul 20, 2023

Exciting news for developers using GitLab for their InterSystems applications repositories! Open Exchange has expanded its support to include GitLab, allowing you to submit your projects just as easily as you would do with GitHub repos. 

Submitting Your GitLab Repo app on Open Exchange:

  1. Start by navigating to Open Exchange and log in to your account.
  2. Head to the "Submit Application" 
  3. In the "GitHub/GitLab URL" field, include the link to your open GitLab repository.
  4. Make sure to check the "Use GitHub/GitLab README as long description" checkbox. This ensures that your project's README fil
1
0 249
Question Eduard Lebedyuk · Jul 20, 2023

I have the following setup: REST broker calls inProc BO via BS. As BO initialization is time-consuming, I want to reuse the same BO during the CSP process lifetime.

I have tried the following approaches:

  1. Set %session.Preserve to 1 (I would prefer not to use it as the BO object is not linked to a specific client)
  2. Set $$$EnsInProcPersist to 1 (looked relevant)
  3. Cached BS between calls

However, every time I call my REST endpoint, I get a new BO. Is there a way to cache inProc BOs in the CSP context?

To run the sample, import it into any interoperability-enabled namespace, start in.Produc

0
0 168
Question Lewis Houlden · Jul 20, 2023

Hi InterSystems Community

We recently had an issue where we weren't able to parse a JSON HTTP request, but the issue went by unnoticed. We also did not have a trace of what the raw HTTP request was that we couldn't parse. I'm looking at improving our this by:
Tracing the raw request using $$$TRACE

Raising an alert which will hit our Ens.Alert router which will compose and send an email

I'm having an issue with consistently raising the alert (I've seen it raise an alert before, and then it wouldn't raise it again on a subsequent message), and also the error back does not really make sense. He

0
1 370
Question Yuri Marx · Feb 1, 2021

The InterSystems documentation https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl… says: "If you do not already have these files, contact the InterSystems Worldwide Response Center (WRC) for download information."

Hibernate is the most used framework to do database persistence. All databases in the market allows get hibernate driver in public repositories, InterSystems no. It is a barrier to InterSystems adoption in the Java Community.

When InterSystems will provide Hibernate jar file to public download, into a public maven repository? 

2
0 472