Article
· Nov 20, 2023 3m read
Parquet files and InterSystems IRIS

In the world of Big Data, selecting the right file format is crucial for efficient data storage, processing, and analysis. With the massive amount of data generated every day, choosing the appropriate format can greatly impact the speed, cost, and accuracy of data processing tasks. There are several file formats available, each with its own set of advantages and disadvantages, making the decision of which one to use complex. Some of the popular Big Data file formats include CSV, JSON, Avro, ORC, and Parquet.

3 2
1 244

Hello,

I am trying to connect to a web socket endpoint that potentially has a number of different IP addresses for load balancing purposes.

I have been asked whether it's possible to use a DNS name to resolve the IP address rather than statically assigning one specific IP address in the TCP Operation.

If it's not possible to resolve on a DNS name directly on the TCP operation, then I wondered whether it was possible to provide multiple IP addresses.

0 2
0 116

Good morning,

Thank you for taking the time to read, understand, and answer this question.

If you needed to convert a message where questions are separated by "|", and the question text is the portion before the ":" and the response is the portion after the ":"; Which way would be the most readable and understandable for other developers?

Input example:

NAME OF SQUAD 1?:ALPHA|NAME OF SQUAD 2?:BRAVO|NAME OF SQUAD 2?:ANSWER THREE||NAME OF SQUAD 25?:YANKEE|NAME OF SQUAD 26?:ZULU

Output structure:

0 2
0 104

The 2023.1 Clinical Viewer appears to have data dependencies that need to be met in order for data to surface from the SDA to the chart. Examples:

1. Lab results need to have a collection date or they will not display.

2. Observations need to have their UoM and codes in the portal txt files in order to display.

Are all of these requirements documented?

0 2
0 203
Article
· Nov 2, 2023 3m read
How to hide the source program

InterSystems FAQ rubric

For routines (*.mac)

You can hide the source by exporting/importing only the *.obj that is generated after compiling the source program.

The command execution example specifies EX1Sample.obj and EX2Sample.obj, which are generated by compiling EX1Sample.mac and EX2Sample.mac, as export targets and exports them to the second argument file.

After moving to another namespace, I am using the exported XML file to perform the import.

8 1
0 442
Question
· Nov 25, 2023
New CACHE.DAT file

Hello,

I have a database drive which is getting full and almost getting out of space. My retention policy is for keeping 3 days worth of data. Seems like I have to modify my code for daily purge as it seems like not doing the complete job. In the meantime, I was looking to move the current CACHE.DAT files for a couple of my databases with maximum size and create a new .DAT file to replace. Can anyone kindly guide on the process?

Thank you,

0 1
0 162

Hey Developers,

Watch the latest video on InterSystems Developers YouTube:

How to Migrate off the Private Web Server - Windows

https://www.youtube.com/embed/NGGt3DE2OD8
[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 1
0 90

We need to generate a PDF file from an HL7 message as it passes through an Ensemble production. Looking for examples, tutorials, documentation aligned to our scenario.

We are currently using Ensemble (so can't use InterSystems Reports at the moment). Thinking Zen reports...

We can get from HL7 to XML OK, following Introduction to InterSystems Health Connect - YouTube (see c.1:11:00-1:13:00)

0 1
0 98

InterSystems FAQ rubric

ObjectScript allows you to pass any number of arguments using arrays. Do it by adding ... after the argument name.

An example is as follows. In the example statement, the argument information is set in a global variable (a variable stored in the database) so that it can be easily checked after the method is executed.

5 1
0 275

Two extended maintenance releases of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect are now available.

✅ 2022.1.4

Release 2022.1.4 provides bug fixes for any of the previous 2022.1.x releases.

You can find the detailed change lists / upgrade checklists on these pages:

0 1
0 296

Hi Community,

Click play and immerse yourself in our new video on InterSystems Developers YouTube:

HealthShare Health Connect - Upgrade Automation with Production Validator @ Global Summit 2023

https://www.youtube.com/embed/61Nduu5UyS0
[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]

3 1
0 108
Question
· Nov 30, 2023
Multitransformations of HL7

This question originally appeared in the comments of the post: Making use of Multiple Sub Transforms in a main map || HL7

I'm having a similar problem trying to get PRD(1) into PV1:ReferingDoctor and PRD(2) into PV1:ConsultingDoc

Running the subtransform will populate referring doctor for the first PRD, and then the second running will delete the PV1, make a new one with only the consulting doctor populated.

0 1
0 114

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.

0 1
0 68

Hi Community,

I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?"

0 1
0 91
Question
· Dec 4, 2023
Custom Application Metric

I made a custom application metric, imported it to the USER namespace and used:

set status = ##class(SYS.Monitor.SAM.Config).Add.ApplicationClass("historymonitor.errorSensor", "USER")

to add it. When I do 'w status' it returns 1 so it is added but I still can't see the custom metric in the api/monitor/metrics endpoint. Even though I added %DB_USER in the application roles for api/monitor.

Does anyone know where the problem might be that the metrics endpoint still doesn't show my metric?

0 1
0 110

Customer has a connection set up to connect to an ISC sftp server but it keeps failing the connection with:

ERROR <Ens>ErrOutConnectFailed: SFTP Connect failed for sftp.il.intersystems.com:22/NPPES/SSL='!SFTP'/PubKey=''/PrivKey=''
with error ERROR #7500: SSH Connect Error '-2146430933': SSH Error [8010102B]: Failed getting banner [FFFFFFFF8010102B] at Session.cpp:238,0

A manual connection can be made successfully and I have verified that the credentials are correct. The Connection Settings are:

SSL Configuration - !SFTP

0 1
1 72

Given the number of new features in this release, InterSystems has decided to add this fifth preview as part of the 2024.1 developer preview program. This extended developer preview release only includes InterSystems IRIS® for HealthTM, and HealthShare® Health Connect.

❗This announcement does not apply for InterSystems IRIS®

1 1
0 85

Hi

Some of our integrations use a system DSN to interact with our Data Warehouse (built on Microsoft SQL Server). We've recently migrated from SQL Server 2016 to 2022 and on the day of go-live we changed DNS cname records as a mechanism for redirecting everything to the new server. This worked great for users and reports, but for some reason we found that HealthShare clung onto the old server name even after several days.

1 1
0 56

Good day,

We recently had penetration testing conducted on our HealthShare clinical viewer and patient Index instances and below is the recommendation

1. Set a same-site cookie for identified CSPWSERVERID. Please advise where I can do this as I only saw this on web gateway settings and it has enable and disable options only.

0 1
0 155

When using InterSystems IRIS as an interoperability engine, we all know and love how easy it is to use the Message Viewer to review message traces and see exactly what's going on in your production. When a system is handling millions of messages per day, you may not know exactly where to begin your investigation though.

Over my years supporting IRIS productions, I often find myself investigating things like...

7 1
1 180