All time
Question
· Feb 9, 2018
To use runlevel

Hi,

Has anybody used /epic/prd/bin/runlevel with different options to bring up or shutdown the cache db. I cannot see any information about it in the manual.

Regards,

Anil

0 2
0 440
InterSystems Developer Community is a community of 25,540 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Question
· Jan 2, 2018
Upgrading from 2014 .1.2

I am wondering about upgrading our Healthshare mirrored environment to the latest release. Has anyone upgraded recently to what version and what kind of effort was put into it. I am thinking it will take 2 analysts full time for 3 months. Am I out of the ball park on this estimate? We have bout 600 operations, Processes and services. What are some of the benefits we get from upgrading and what are some of the problems you ran into during the upgrade? Any information you have to share would be greatly appreciated.
Thanks

0 2
0 440
Announcement
· Jan 26, 2018
New Video: Java Business Hosts

Hi, Community!

Please find a new session recording from Global Summit 2017:

Java Business Hosts

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

2 0
0 442

Hello, I've completed this tutorial: https://community.intersystems.com/post/deepsee-period-date-vs-same-peri...
I've used the "year" level instead of a pivot variable.
I want to calculate something like the following variation: 100 * ([DateOfSale].[PTD] - [DateOfSale].[LYPTD]) / [DateOfSale].[LYPTD]
I create a new calculated member, under the same dimmension with the above expression.

0 3
0 439
Question
· Jun 8, 2017
SQL Connect

How to simply going to get the value of the system language from ^%z? Because I got a problem, U2 context isn't setup while connecting the SQL Connect.

0 4
0 438
Announcement
· Mar 16, 2017
Articles' Views Analytics

Hi, Community!

I hope you know the option to use DeepSee analytics portal for Developer Community stats. You can find it in Community-Analytics menu.

Let me introduce the beta of new analytical dashboard 'Articles' Views', which is available in Authors folder.

It consists of two dashboards, first shows the running total of the views for the articles (to see the impressive growing curve).

2 5
0 342
InterSystems Official
· May 21
InterSystems Platforms Update Q2-2025

We have a big update this quarter.

  • RHEL 10 was released yesterday, read on for what that means for you
  • 2025.3 will use OpenSSL 3 across all operating systems SUSE 15 sp6 will be the minimum OS for orgs using SUSE
  • The minimum CPU standards are going up in 2025.3
  • Older Windows Server operating systems will no longer be supported in 2025.3

9 3
2 381
Question
· Jan 5, 2024
SFTP connection problem

Hello,

I have been facing a problem for several months, I have several flows that work in SFTP with the iris class EnsLib.FTP.PassthroughService

The problem is that from time to time I get an error message that says:

"A connection could not be established because the target computer expressly refused it"

I had the case for a server at our house and we solved the problem by extending the call interval parameter to 60 seconds,

1 3
0 438
Article
· Sep 26, 2023 1m read
Create JSON Objects and Arrays by SQL

The related package avoids adding %JSONAdaptor to each class but uses instead
SQL functions JSON_OBJECT() to create my JSON objects. With this approach, you can
add JSON to any class - even deployed ones - without any need for change or recompiling.

The trigger was the Export of M:N relationships as JSON objects or arrays.

Open Exchange app
11 0
0 441

Multidimensional properties can be found on certain classes.

These operate as a collection of values much like a Python dictionary.

Examples of properties that might be encountered:

Class Property Description
%Net.HttpRequest Params Name value pair of form parameters
%Net.HttpResponse Headers

HTTP Headers returned with web content returned:

Open Exchange app
4 0
0 441
Question
· Mar 21, 2023
Read-only .cls?

Hi, could someone tell me please how can I "unlock" a .cls file which author is Intersystems? I want to make some modifications and add some trace messages there. The file resides in the HS.FHIRServer namespace and it looks like read-only

0 6
0 435

Hey Community,

We are glad to invite you to the upcoming kick-off webinar on the InterSystems Developer Tools Contest.

In this webinar, we'll talk about how to choose a project and show you how to develop, build and deploy applications on InterSystems IRIS data platform. Also, there will be information about the hot internal projects at the moment (SQL client, VS Code unit tests and Jupyter notebooks), how to look at community opportunities in the Ideas portal, and what InterSystems would like to do with the management portal.

Date & Time: Monday, January 23 – 12 pm EST | 6 PM CET

Speakers:
🗣 @Raj Singh, InterSystems Product Manager
🗣 @Dean Andrews, InterSystems Head of Developer Relations
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

>> Register here <<

0 2
0 401

Hi,

For a Linux host, has anyone developed an Ansible module that will start a session to IRIS and send commands?

What I am after is something like this:

1. Supply

Username

Password

Commands <- list

Prompt <- from session command

2. Send back the output from the session

If so please advise where I can download the module?

0 4
0 437
Article
· Nov 28, 2022 1m read
Use IntegratedML to 'predit' diseases

Hi Developers,

IntegratedML is a feature helps us and our teams easily implement machine learning (ML) without dedicated ML experts and data scientists. If you do not need particularly complex ML function, integratedML is a good choice and convenient that only requires executing 3 SQL queries to build predictive models directly from InterSystems IRIS to ML engine.

Open Exchange app
5 2
1 401

Hi All,

Is there any cache command which can give who all has compiled a classes from the day it has been created. Specifically I want the 2 information username and time of compilation of class.

I tried with $$DATE^%R("TEST.1.INT"), but it only gives the last compilation time.

Thanks in advance !!

0 3
0 438

Hi Firneds

I have few odscodes in Lookup table named "AllowLT" .

Now I need to continue if I found value in lookup table or stop it. For that I have colleting the value form lookup table for input HL7 message OBR:21 value.

I know if found in lookup table it will return 1 or 0 . If not found what it will return below line? to return 0 in case , given key not available in lookup table , what I need to write?

0 3
0 438

Kidney Disease can be discovered from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the scientist Akshay Singh published a very useful dataset for training ML algorithms in the detection/prediction of kidney disease. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/datasets/akshayksingh/kidney-disease-dataset.

Open Exchange app
2 0
0 441

I am looking for an experienced IRIS for Health engineer to join the CVS Health family.

This position can be contractor, contractor for hire or direct hire.

We are doing our first implementation of the product and can use someone with experience.

The contractor role can be fully remote.

For a hire we are currently fully remote due to COVID, however, post CVID, we should be in a hybrid model (some remote and some onsite) in the Chicago area.

4 0
1 441

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

0 5
0 436

I'm looking for the best strategy for extracting data from a Cache table that houses 86 Million lines of data and around 190 columns. I'm currently using DBeaver and the Invoice Service dates go back to 1996. Optimistically I'm looking to pull to a pipe delimited flat file, but even a year's worth of data takes many hours to get query results.

Any suggestions for the best practice/strategy?

Thanks,

John

0 2
0 439

I am trying to install IAM in my local and I downloaded IAM-0.34-1-1.tar.gz and extracted. I went to the location where iam_image.tar is available and run below command in the command prompt.

C:\ESB\HC\IAM-0.34-1-1.tar\IAM-0.34-1-1\IAM>docker load -i iam_image.tar
unsupported os linux

Getting unsupported os Linux issue. Kindly let me know if anyone had this issue. Thanks!

0 5
0 436
Question
· Jan 14, 2020
%CSP.Rest custom headers

I would like a REST client to be able to send a custom header with the http request, for example "APPLICATION-ID".

This can be seen in the CSP gateway trace but I have tried using %request.GetCgiEnv("HTTP_APPLICATION-ID") in various formats and parts of the classes but cannot work out where I can get this. Documentation says this should work but is for normal CSP pages.

Any ideas?

0 6
0 435

It is possible to update Cache object property from Python using the following Python code, with import of intersys.pythonbind3:

my_object.set("my_property",["A","B","C"])

However, I am unable to save 2D %List with 2D Python array like the following:

my_object.set("my_property",[["A","B","C"],["1","2","3"]])

I am not sure whether this is Python-Cache bind flaw or design issue. Is there any alternative/ workaround to do the same for above?

0 3
0 438