Hi All,

We're doing our first babysteps with embedded Python and IRIS with an interoperability solution. We want to convert a CSV file to an Excel xlt file.

As service we've got a EnsLib.File.PassthroughService which picks up a csv file

As operation we've got a EnsLib.File.PassthroughOperation which writes the Excel file.

In the middle:

We've created an Business Process with an %Stream.GlobalCharacter in the Request and a %Stream.GlobalCharacter in the Response.

1 3
0 502
InterSystems Developer Community is a community of 24,463 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi!

Currently, I'm working on a script using %SYS.Journal API.

My journal files are compressed, following the documentation the compression is zstd.

I tried to unzip a file with zstd tool, ex: 

apt-get update
apt-get install zstd

zstd -d 20230806.001z -o 20230806.001

20230806.001z        : 92.03%   (909312 => 836859 bytes, 20230806.001)

Unfortunately, the unzipped file is invalid:

Write ##class(%SYS.Journal.File).IsValidJournal("/usr/irissys/mgr/journal/20230806.001")

1 2
0 465

Hi,

We have a global with 65 million entries. All we are doing is just iterating through each entry to find out the total no of entries. It is currently taking 110 minutes. Is this something normal? What can we do to speed up this process? Below is the program for just iterating each entry in the global.

s sub=" ,count=0
f{
s sub=$o(^YYY(sub)) q:sub=""
s count= count +1
}
w!, "Total Count:"_ count

3 19
1 610

Greetings.

I have a scenario in ENSEMBLE, where a business process router A is dependent on another business process router B. If B shuts down for some reason, A has to be disabled as well.

Do i need to write a custom process for B and call the call back method onShutdown or something?

Any suggestions would be appreciated.

Thanks,

Jimmy Christian.

0 0
0 138

There is several classes that allow to create TCP/IP connections (eg: to connect to a service).

Example : %Net.FtpSession (port 21), %Net.HttpRequest (usually port 80 or 443)

AFAIK connection will stay open unless closed explicitly or if variable that hold the instance is garbage collected.

Is there a way to get a list of all active (open) TCP/IP connections IRIS is maintaining so far ?

0 6
0 597

Hi Developers,

This July, you've posted the whooping 83 new questions on the Developer Community:

Questions

Short Answer Questions - Exams guide - LibGuides at National College of Ireland

3 0
0 302

Hi,

I try to initialize some properties of a %DynamicObject during his creation.

I Try to use InitialExpression this way :

Property refDate As %Date [InitialExpression = $piece($horolog,",",1)];

But it doesn't compile

I don't found if %DynamicObject can have a constructor to initialize properties by a calculated value, like other languages.

0 4
0 235

I'm trying to read data from a file and it contains single precision (4 byte) float values. Does Iris/Cache' have a way to convert the binary into a Cache' variable that is accurate?

ZW RECORD
RECORD="EDID"_$c(17,0)_"fLargeRefMinSize"_$c(0)_"DATA"_$c(4,0,0,0,0)_"DGMST&"_$c(0,0,0,0,0,0,0)_"d"_$c(14,0,0,30)_"h+"_$c(0)_"("_$c(0,0,0)_"EDID"_$c(22,0)_"fBribeSpeechcraftMult"_$c(0)_"DATA"_$c(4,0)_"ÍÌÌ=GMST"_$c(28,0,0,0,0,0,0,0)_"c"_$c(14,0,0,30)_"h+"_$c(0)_"("_$c(0,0,0)_"EDID"_$c(12)

The float DATA value for "f" LargeRefMinSize is $c(0,0,0,0) which is obviously 0.

0 6
0 215

Hey Community,

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

New Videos
№ Video Views
1 Winners of the InterSystems Grand Prix Contest 2023 11639
2 Projecting Data into InterSystems IRIS with Foreign Tables 7233
3 Using the InterSystems Terminal 1801
4 Introduction to irisChatGPT application 198
5 HealthShare Analytics Solution: So Many Tools, So Much Power 89
6 Introducing VS Code, and Moving from Studio 79
7 DevBox Alpha Demonstration 61
8 FHIR AI and OpenAPI Chain detailed walkthrough 58
9 How to Get the Most Out of the InterSystems Developer Ecosystem 51
10 Using the new InterSystems IRIS Hibernate 6 Dialect for a Springboot Project 50
11 Controlling Command Flow with Postconditional Expressions 49
12 #6 Developer Roundtable: Optimizing your dev practices 42
13 password app iris db 40
14 iris fhir generative ai 37
15 Online Meetup with the winners of the InterSystems Grand Prix Contest 2023 35
16 ZProfile 24
17 IRIS FHIR Transcribe Summarize Export Demo 24

2 0
0 127
Question
· Sep 13, 2019
Mirror Problem with SSL

I'm trying to create a simple mirror with two Cachés 2016.2.1.803 Instances,

but after i create the mirror with the primary and try to connect the fallouver server, i receive the following message:

ERRO #2071: Erro ao recuperar informações do conjunto espelho para 'BPLUS'. Erro: Connection failed: Unexpected error: <READ>SSLServer+191^MIRRORCTL

i'm not using ssl on this configuration, tried with arbiter and without, same effect.

Tried with Caché 2018.1 and Caché 2016.2.1, same problem.

Some tips?

Best,

0 2
0 1K

Hi Developers,

Watch this video to learn how InterSystems is supporting new regulatory requirements:

⏯ Regulatory Roundup: What’s New in the Interoperability Arena @ Global Summit 2023

https://www.youtube.com/embed/IdYEOQW6E0U
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 190

Hi,

Using Interoperability, I can't figure out how to create separate XML's files from a CSV-file using the GUI-features Record Maps/Complex Record Mapper -> Data Transformations. I'm familiar with reading/writing the files using File Service/Operation, but don't understand the processing-steps.
The preferred method by my colleagues is to do this without any Objectscript or Embedded Python coding, but if this can only be done by some coding that's fine as well.

See example below.
Any help is appreciated!

Kind regards,
Ties Voskamp

0 2
0 286

I asked the question in email and get answers from those colleagus.

Question:

I failed to change time zone on latest iris container(Ubuntu), because:

  • I am irisowner, no root password

  • There is no sudo command

I used to use below Dockfile setting to change time zone while creating a new docker image. However, those commands doesn’t work from non-root user.

2 1
0 378

The 2023.2 releases of InterSystems IRIS Data Platform, InterSystems IRIS for Health, and InterSystems IRIS Studio are now Generally Available (GA).

RELEASE HIGHLIGHTS

2023.2 is a Continuous Delivery (CD) release. Many updates and enhancements have been added in 2023.2:

Private Web Server

Starting with this release:

2 0
0 336

InterSystems announces its seventh preview, as part of the developer preview program for the 2023.2 release. This release will include InterSystems IRIS and InterSystems IRIS for Health.

Discontinuation of the Private Web Server (PWS)

A major topic in this release is the discontinuation of the Private Web Server (PWS) from the installers. This feature has been announced since last year and it's removed from InterSystems installers, starting with this developer preview.

2 11
0 305

Overview

We often run into connectivity problems with HealthShare (HS) deployments in Microsoft Azure that have multiple HealthShare components (instances or namespaces) installed on the same VM, especially when needing to communicate to other HS components while using the Azure Load Balancer (ILB) to provide mirror VIP functionality. Details on how and why a load balancer is used with database mirroring can be found this community article.

6 1
1 932
Discussion
· Jul 28, 2023
Code Golf: Parenthesis

Our previous code golf ended with an overwhelming win, so now it's time for another one.
Parenthesis Hell is a Lisp-like esoteric programming language(esolang).
As a Lisp-like language, the code consists only of nested matched pairs of opened and closed parenthesis.
Your task is to write a method that receives a string of parenthesis and returns 1 if the order of the parenthesis is valid. For example, the string of parenthesis (())() is valid because it contains a matched pair of opened and closed parenthesis at each position. The string ()((()))) is not valid because it contains one unmatched parenthesis.

5 37
0 740 
First time setting up a SSL/TLS connection, and I am running into issues when I call it from within a Business Operation. I used openssl to generate a RSA 4096  SHA512 key/csr request for our Active Directory Certificate Service to generate a Certificate Chain for me to use within RedHat. I was 
able to connect to our Web Service server using a generic request from terminal, however when I try it from our Business Operation I am running into issues.

I tested the SSL/TLS connection using the following commands from the terminal...

DEVCLIN>set request=##class(%Net.HttpRequest).%New()
0 1
0 706

Recently I started moving some of our JDBC Gateway configurations over to using the Microsoft JDBC Gateway driver instead of using the jTDS open source driver. I have noticed since then that those Objects that are using Microsoft JDBC Driver are throwing a lot more errors than the jTDS driver ever did, which I can understand however I am puzzled that I keep running into an issue with the Java Gateway Service within the Interoperability engine.

0 1
0 426

InterSystems FAQ rubric

You can set individual error pages for the following Web Gateway error messages/system responses:

  • server error
  • server busy
  • server unavailable
  • server timeout
  • connection closed

Settings are made on the Web Gateway Management screen ([Management Portal] > [System Administration] > [Configuration] > [Web Gateway Management] > [Configuration] > [Default Parameters]).

In the Error Page section of the Default Parameters menu, set the filename of the html page to display or the URL to redirect to when an error occurs.

1 0
1 342

Hi community,

I have an incorrect InterSystems Server Credentials password stored by the Workstation Keychain in VS Code. VS Code is trying to use this incorrect stored credential to access the server and does not prompt or allow me to input a different password. I do not see any settings associated with the Keychain or resetting those credentials. Does anyone know of the process to delete or replace a stored password here?

Thanks!

Hannah

2 1
0 958
Question
· Aug 3, 2023
XCPD versus PDQ Settings

I noticed that the XCPD processor has a setting for PDQ minimum threshold and maximum record count returned, but PDQ does not have these settings. Can anyone explain why? They are essentially the same service.

0 0
0 129

I'm trying to track down documentation on how HealthShare + HSPI prioritizes patient demographics that are returned in various scenarios. I've done some experimenting but was looking for some confirmation.

1. HSPI - It's my understanding that trusted tiers and aging factors only impact the HSPI management UI experience. That they are not incorporated into patient search response. Can someone confirm this?

2. Patient Search Response (Clinical Viewer, PDQ, XCPD, FHIR) - Only Registry demographics are used. Nothing from HSPI or Patient SDA.

1 0
0 189

Good morning,

first of all thank you for taking the time to read and answer this question.

Recently, since we have upgraded to HealtShare 2020, we experienced the fact that when opening in the Studio the Process (.bpl) and Transformation (.dtl) classes, it asks us to log in, i.e. username and password, almost every time we open a new Process or Transformation.

However, in previous versions, I think we had HealthShare 2016 or 2017 or 2018, and in it, you could log in from the Studio in Processes and Transformations, logging in 1 time only.

0 1
0 126

Hi Developers, I'm currently doing a demo about building a front end UI doing data analytics and setup a performance test with large data objects, therefore using "Populate Utility" could help me auto generate some sample data that I can play with.

Within this post I would like to share my experience of using Populate Utility, including using POPSPEC Parameter.

9 6
1 537