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 367

Hello,

searching messages in our Message Bank is quite slow, often runs into timeout.

I wanted to perform a tune table on Ens_Enterprise_MsgBank.MessageHeader because this apparently has not been done yet - the Tune Table utility shows no entries for selectivity, etc.

I tried

 w $SYSTEM.SQL.Stats.Table.GatherTableStats("""Ens_Enterprise_MsgBank"".MessageHeader")

and got this error message

1 6
1 363

IRISTEMP - IRIS.DAT took up all the available disk space of almost 2 TB that leads to Production instance down.

After RCA the suspected cause was some SQL query but not confirmed as query result was received within a minute.

Currently we are monitoring the IRIS.DAT and it is continuously increasing and currently we set the MAX size for this DB, but not sure what will happen once it hit the MAX SIZE ?

Any clue why the IRISTEMP DB is not flushing the data from IRIS.DAT as i believe it is being mostly used for system processes and is in increasing trend at ~ 1GB/day?

0 3
0 319

Hi,

In some of the trakCare screens there is term "Production" shown [Interoperability->Production Configuration]
What is a production?

The production I'm looking at, is related to a Gateway.

What is a definition of a Gateway? How is this different to an Interface?

Under Gateway Production, there are "Services", "Processes", "Operations".

How are these defined to be?

I have 3 services, each with a green dot.

I have 3 processes , each with a green dot.

I have 5 operations, 4 of which has a green dot and one red dot.

1 7
0 315

Hi,
The IRIS Health Docker image comes with Java 1.8 but I need OpenJDK 11. How could I install that using aptitude or somehow else?
The apt-get command requires elevation but if I rewrite the command with sudo apt-get it won't build with error message /bin/sh: sudo: not found
Is it possible to do what I want?

2 3
0 314

I am looking for an appropriate solution to generate HL7 test messages to test my production. IRIS for Health already contains many HL7 specific functions like the schema structures. Furthermore one can use transformations to build custom messages.

What I am interested in is if anyone has already created a tool or script that can be used to create any HL7 messages that meet the minimum requirements and populate all the required fields with test values. I would then like to send these test messages via TCP to a business service.

1 9
2 297

Morning everyone,

I would appreciate some advice please- hopefully there is plenty of experts out there.

We are setting up an sFTP share between hospital trusts here in the UK and I have set the outbound operation up using a custom extension of EnsLib.HL7.Operation.FTPOperation.

We are configuring a VPN tunnel to run between the sites also so there is a bit of firewall / network routing to take place to enable the connection but to add in a complication we are on a mirrored cluster and usually present on a Virtual IP address.

0 2
0 290

We are trying to come up with huge DataStore which needs to store HIPAA transactions and Data getting partitioned with idkey - YYYYMM. Current Live data get inserted into current Month DB - HIPAA_202306. 10 years (Hipaa retention policy) old data is going to be sitting in to 120 DBs ( 201606_HIPAA, 201607... 202305) for historical audit legal compliance purposes.

Currently if we create Namespace we get 2 databases - CODEDB for routes/classes & DATADB for journals data.

0 7
0 270

Hi,

I'm trying to figure out why I'm unable to iterate through a dynamic array and access the nested objects.

Using the NHS PDS FHIR API in the NHS sandbox environment, I'm querying the PDS endpoint using a sample NHS Number to retrieve a patient's demographics. My Business Operation reads the response data and passes it back to my Business Process where I intend on iterating through certain nested objects. The data present in these nested objects will decide what happens next in the process.

0 4
0 269

Hi, I have a laptop with a Core i5 processor, a workstation with AMD Athlon 3000G processor, and another workstation with AMD Ryzen 3900 onboard. I was succeded to install IRIS Health community on the laptop. On both AMD workstations the install process hangs. I've waited for 8 hours but with no avail. What could be wrong with AMD?

0 9
0 267

Hi all,

I'm trying to use LOAD DATA to insert 11k (11,377) rows of data. LOAD BULK DATA is not available for the version of IRIS I am using.

After calling LOAD DATA it says only 5,500 rows has been inserted. The LOAD DATA docs says any error rows are skipped and a count of skipped rows can be found in %SQL_Diag.Result however there are no results here. There are no errors in the xDBC error log either.

Why have over half the rows been skipped?

3 3
0 263

Hello,

I have Iris4Health community version (using for some development) running in a docker container and trying to enable TLS/SSL/HTTPS in the container. I have created the SSL cert chain (root ca/web site cert) via open SSL have the http.conf and http-local.conf file loaded on a durable volume. I have also loaded the root CA in the trusted root cert store on the device that is connecting.

After inspecting the logs it looks like apache has loaded the certs and is listening on the correct port, but I am unable to connect to the mgmt portal via SSL.

0 2
1 251

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?

0 7
1 217