February 11, 2021 – Alert: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’

InterSystems has corrected a defect that can cause incomplete query results. This defect affects:

• InterSystems IRIS and InterSystems IRIS for Health 2019.1.0, 2019.1.1, 2019.2, 2019.3, 2019.4, 2020.1.0, 2020.2, and 2020.3
• HealthShare Health Connect 2019.1.0, 2019.1.1, 2020.1.0
• HealthShare Products 2019.2, 2020.1 and 2020.2

(In HealthShare and HealthShare Health Connect, this defect only affects Personal Community with 64,000 patient proxies and possibly customer-built custom queries.

Hello everyone,

I have an issue with using "Open" function.

My goal is to execute a shell script with parameters like as:

/trak/FRXX/config/shells/transportIDE.sh "login|password|NOMUSUEL|PRENOM|NOMDENAISSANCE|1234567891320|199999999999999999999999|09%2099%2099%2099%2099|31%2F12%2F1999|242%20IMPASSE%20DES%20MACHINCHOOOOOOOOSE%20||99999|SAINT%20BIDULETRUC%20DE%20MACHINCHOSE|isc%24jhu|123456|123456798"" 2>&1"

But when some parameters are too long, I have a <NAMEADD> error.

I would like to avoid to write the %String command line in a temporary file and execute this file using : Open strCmd:"QR"
Is

Hello,

We would need to find messages where a property "pEntrada" of type %GlobalCharacterStream contains "C006"

We have read:

https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=E…

We have tried:

The production outputs:

How could we search in fields which are not strings?

Hi developers!

Recently we announced the preview of Embedded Python technology in InterSystems IRIS.

Check the Sneak Peak video by @Robert.Kuszewski.

Embedded python gives the option to load and run python code in the InterSystems IRIS server. You can either use library modules from Python pip, like numpy, pandas, etc, or you can write your own python modules in the form of standalone py files.

So once you are happy with the development phase of the IRIS Embedded Python solution there is another very important question of how the solution could be deployed.

One of the options you can consider is using the ZPM Package manager which is described in this article.

Hi Developers!

Here're the technology bonuses for the InterSystems Grand Prix Contest that will give you extra points in the voting.

Below are the details and useful links on all the technical bonuses.

Hello,

We would be grateful if you could help us,

Our aim is to develop a method which retrieves an image stored in an external system, using a REST Operation

To upload the image we have the following code:

/// Operacion para gestionar el Registro imagen identidad digital en Tarjeta Sanitaria
Class Operaciones.REST.miSCS.miSCS Extends EnsLib.REST.Operation
{

Parameter INVOCATION = "Queue";

/// Subir la imagen del usuario
/// La documentación para crear este metodo es:
/// https://docs.intersystems.com/irisforhealthlatest/csp/docbook/Doc.View.cls?KEY=GNET_http#GNET_http_post_multipart

Hi community, 

 The question that I have , it's very simple. I developed a pivot that contains two rows, the first it's a date and the other another field. I need to orde by date in descending order and I can´t find where I can do this. I saw that it's a option Sort members, but it's based  in a condition of the measures. 

Can someone help me with this. 

Thanks in advance. 

Visual Studio Code is a compatible IDE for InterSystems technology!
Visit the resource guide to learn more about the VS Code IDE and how to use the ObjectScript extensions.

Developing in ObjectScript with Visual Studio Code (link)

We are getting more and more request wondering if we could send/receive data via HTTPS to the outside world from within our Hospital Network. As you can imagine our Ensemble/Cache productions are not exposed to the DMZ or has access outside of the network. We only communicate with external vendors through a VPN, so communicating not using a VPN is rather new to us.

Currently there is a project to get rid of using Proxy, and instead of through a Load Balancer that can use rules to filter out traffic, which adds another layer of complexity.

So does anyone out there have a Best Practice, or can

Hi,

While installing IRISHealth-2020.1.0.215.0-macx64 on Mac computer I am getting the following error message.

Any suggestions please.

Thank You

===================================================================================

Updating system TEMP and LOCALDATA databases

Installing National Language support

Setting IRISTEMP default collation to IRIS standard (5)

Loading system classes

Updating Security database

ERROR HAS OCCURRED: Error in security tables, Error: ERROR #903: Domain xxx.com. does not exist

ERROR #5002: ObjectScript error: <ROLLFAIL>%TRollBack+10^%occTransaction

Unable to install

Hey everyone!

I recently learnt something new while working with WRC on an issue, and I wanted to share with everyone on the off chance it could help someone else.

Scenario:

Files are being inexplicably written to a folder on your server and, due to the number of files in the folder and general system throughput, it is not possible to work through the files to track down the source.

Dear Global Masters participants!
This is the moment you can share with us your honest thoughts about Global Masters. What do you like about it? What you'd like to change? 

Last year we created a roadmap based on your responses and successfully introduced new gamification system to make higher levels more achievable, new rewards, and new types of challenges. Time to make your wishes for 2021, because this program is FOR you!
Please spend 5 min and answer 11 questions about Global Masters. We guarantee that we carefully consider every single comment.

➡️ Global Masters Survey 2020 (5 min)

I plan to install an Apache Web server (2.4.x)  on a Linux server. The IRIS DB server is running on a separate Linux Server .  Do I need to install Intersystems IRIS software on the Web server to allow the web gateway and CSP server to communicate  ?   I read through a few IS documents, however, it's still not clear if I need to install IS on the Web servers .. Any help would be appreciated ..  

How to set the size of the participant pool and what are the key factors that determine it? How should we set it?

Hi,

I am trying to install Intersystems IRIS Health Community On Windows 10 Pro version. I am getting 112 error while installing and in some point it Roll Back the Action.

But I am able to configure in Windows 10 Enterprise version.

Is any other settings are there to configure in Windows 10 Pro version or IRIS is not supported?

Please help me.

Thanks in advance.

Hi -

I'm trying to figure out an elegant way to select a row on a table pane when I don't have an index, but I DO have a value.

My page has a typical tablePane (with a tableNavigator) which is being populated from a table of records, and the value for each row is the object instance ID for the class that has the rest of the columns being displayed.What I'm trying to do is add in a URL parameter for a targeted object ID that will populate the specific "fields" elsewhere on my page, which are the same fields that are populated when I do an onSelectedRow() from my tablePane.

Hi folks!

Each IRIS installation has a /lib folder which is intended for 3rd-party libraries being used in the solution.

For IRIS installation the typical path is:

/usr/irissys/lib/

In ZPM the shortcut is ${libdir}.

What is the macro or internal function to obtain it programmatically?

Hi everybody,

Is there any functionality I could use that triggers real time user-defined code on certain audit events? Right now I am interested in triggering such code on a routine modification event, like the one below. I do know how to access this record programmatically, via %SYS.Audit.

Thanks in advance,
Anna

Hi Developers, 

We are pleased to introduce new 🎁rewards on Global Masters available for advocates of the Specialist level and above:

➡️ PRE-ORDER for Raspberry Pi 4 8GB + InterSystems IRIS Community Image Set

The set includes: MicroSD Card 64GB with Ubuntu 18.04 64 bit + Docker + InterSystems IRIS Community Image, Raspberry Pi 4 8GB, Red-white case.

Hi Developers!

Please welcome the new video on InterSystems Developers YouTube:

⏯ Embedding AI Services

There is a error when I try to use VSCODE to connect to my Ensemble Server. What's wrong with me？How can I Configure this /api/atelier web application

As a Belgian leader in developing and operating entertainment solutions in the sports betting and casino games sector, Bingoal is a dynamic and ambitious company looking for a passionate Back-End Software Engineer. Together with the IT team, you will be working to create scalable and easy to maintain software having an impact on the core of Bingoal’s activity.

We are looking for a developer with InterSystems ObjectScript Experience.

As a Belgian leader in developing and operating entertainment solutions, Bingoal is a dynamic and ambitious company looking for a passionate Back-End Software

This is a demo to make use of a simple WebSocket Client with Embedded Python in IRIS.

How to Test it

• Run an Iris Session in Docker
• Select your WebSocket Echo Server
• Enter the text you want to send or generate it
• Send it and see the result

$ docker-compose exec iris iris session iris "##class(rccpy.WSockPy).Run()"

*** Welcome to WebSocket Embedded Python Demo ***

Collecting websocket-client
Using cached https://files.pythonhosted.org/packages/4c/5f/f61b420143ed1c8dc69f9eaec5ff1ac36109d52c80de49d66e0c36c3dfdf/websocket_client-0.57.0-py2.py3-none-any.whl
Collecting six (from websocket-client)
Us

Hi,

So I am a front end developer working with REST API with Cache database on the BE. The BE guys are currently using Cache through a Windows virtual machine and they claim it is not possible to have a development server to work with. All the work they are doing is directly on the production server and changes are immediate and I think this is a bad idea going forward and we most definitely need a development server that has access to the same code base and different version (through git) to be able to do development. We also do all the testing on this production server with test accounts, but we cannot do automated testing with this setup.

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in January 2021:

I need another set of eyes to look at the following. Instead of a Data Lookup table, I wanted to try to lookup a value against a Cache table that I had build. So I thought I could write a function to run a simple SQL query against the Cache Table and return me a %Boolean value back to my routing rule. However today I found that it was not working properly.

Can someone take a look at the following method and verify that I am doing this correct?

index = column name

value  = HL7 field that I am passing into the method

ClassMethod TecsysUnitExists(index As %String, value As %String) As %Boolean
{
  set

Hi Developers,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Building REST API with InterSystems IRIS Docker Container in 5 Minutes

In the context of IKO (Iris Kubernetes Operator) the question of Service not redirecting dynamically to the correct Pod is still pending.
In production this can be dangerous since an overload (or any other simpler problem) can cause you to change the main Pod and leave the application inoperable until we intervene.

Intersystems support warned that this is still an issue of IKO, but there are some possibilities that I am studying.

To explore an idea I had, I would like the help of this Forum to answer the following question:

Is there a way, via the non-iterative command line, to detect whether the

Hi,

I have a PV1 repeating field that can contain multiple or a single value. I'd like to always pull the last value in the field but am not sure how to configure this in my DTL.

The repeating field is in PV1:50().1

Could somebody shed some light on this?

Examples:

|15081942~15081951~15108961~15280550|

|15081947|

|15081939~15081940|

Thanks

*Analista Ensemble Júnior / Pleno

Próximo Metrô Clínicas

REQUISITOS:
* Conhecimento em barramento e protocolos RESTFull / SOAP 
* Integração com banco de dados Oracle / SQL Server

ATIVIDADES:
* Integração de sistemas hospitalares
* Administração do ambiente Ensemble
* Análise de Dados

Enviar CV com pretensão salarial
.

Contratação CLT ou PJ tempo indeterminado

Empresa ..................: JHealth Informatics
Email ........................: rh@jhealth.com.br