All time
InterSystems Developer Community is a community of 25,647 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hi, Community!

We have a new release here!

What has been introduced:

1. Better notifications

With this release I hope you will turn on back the email notifications because every new notification today in the beginning of itself will tell first, why did you get it describing the exact reason you got this particular notification. And if you don't want this type of notification to be delivered anymore click unsubscribe link in the notification and it will lead to the settings of this very type to alter.

1 6
0 452
Question
· Nov 5, 2021
ERROR #9406

I'm trying to send a POST request to my REST API and I'm getting this error and most likely due the lack of experience, I have no idea how to fix this issue:

"error": "ERROR #9406: Unexpected format for value of field, AlertText, using class base mapping",

"id": "JSONImportError",

"params": [

"AlertText",

"class base"

]

Am I missing something from my string definition?

Defined below as:

0 4
0 567

Hi all,

Do you know if there is a way to create a Lock that is related to an existing transaction, in the sense that if transaction is finished (commit or rollback) Lock is removed. I ask this because in the following example Lock is there until process is killed.

Example :

TSTART

Lock +^MyLock

TROLLBACK

I know, that, Caché itself is locking internally a table register when doing an OpenId with exclusive flag during the transaction life. For example :

TSTART

0 4
0 567

Not sure there are many that connect to MS SQL to execute queries, stored procedures, etc, but our Healthsystem has many different MS SQL based databases we use within the Interoperability environment for various reasons.

With the push to moving from on-prem to the Cloud we ran into some difficulties with our SQL Gateway connections and knowing how to config them to use Microsoft Entra for Active Directory Authentication.

5 0
1 570
Article
· Mar 29, 2023 1m read
Named Parameter In SQL with Python

Quick Tips: Total Productive Maintenance

Named parameters can be achieved with SQLAlchemy :

from sqlalchemy import create_engine, text,types,engine

_engine = create_engine('iris+emb:///')

with _engine.connect() as conn:
    rs = conn.execute(text("select :some_private_name"), {"some_private_name": 1})
    print(rs.all())

or with native api

from sqlalchemy import create_engine, text,types,engine

# set URL for SQLAlchemy
url = engine.url.URL.create('iris', username='SuperUser', password='SYS', host='localhost', port=33782, database='FHIRSERVER')

_engine = create_engine(url)

with _engine.connect() as conn:
    rs = conn.execute(text("select :some_private_name"), {"some_private_name": 1})
    print(rs.all())

6 0
0 570

Hi Developers,

Python has a large and powerful ecosystem that contains thousands of libraries and packages available, especially in data science.

Therefore, I wanted to have a first try in using a recent feature of IRIS called Embedded Python, to simply import a python library called datetime, generate data with a timestamp component and persist it in InterSystems IRIS for Health Data Platform. The same will work on IRIS Data Platform as well.

4 5
1 470

Monitoring IRIS through SAM (sam:1.0.0.115)

While I've used to make it work in the past, I'm not able any more to fix the already faced issue : "State: Unreachable"

Despite all the ip-addresses attempts (or hostname = host.docker.internal) and while "/api/monitor/metrics" is running well...

Could someone provide good practices to make it work cleanly ?

1 13
0 557

I have just started to experiment with Using IRIS in Docker.

My first objective was to be able to enable global persistence within a Docker container. Using the following command I have managed to achieve this:

docker run --detach --publish 52773:52773 --volume /data/dur:/dur --env ISC_DATA_DIRECTORY=/dur/iconfig --name iris21 store/intersystems/iris-community:2020.1.0.199.0

Within this container, I have created a simple global:

for i=1:1:10 set ^tmp(i)=""

0 7
0 430

hi all,

I am looking to make a JDBC connection to my Intersystems Cache using the JDBC driver 2.0.0.

I see the connection format is as "

   jdbc:Cache://<host>:<port>/<namespace>

"

What I really want to do is filter additionally by a certain database, i.e. connect my consuming application to a database under the namespace.

how can I do that? what will be the format

0 4
0 566

Hi developers!

Every day coding with IRIS and docker I call the following 3 commands in VSCode terminal. Always the same for any projects:

docker-compose build   ; to build the container

docker-compose up -d   ; to run the IRIS in container

docker-compose exec iris iris session iris ; to open the IRIS terminal

Is there any way to map the key sequence which will type me the rest?

e.g.

0 2
0 568

Currently, namespace Alpha is configured to use database AlphaDB as its global database. How would we go about having namespace Alpha configured to use database AlphaDB for its global database except where global ^Customers(CustomerId) has a CustomerId greater than 10M, which we would like to have it redirected to database BetaDB.

In other words, ^|"AlphaDB"|Customers contains all customers between 1 and 10,000,000; and ^|"BetaDB"|Customers contains all customers greater than 10,000,000. Any help would be appreciated.

0 4
0 566

Hello all,
I am creating a REST API with a spec-first approach. However, I am using the try-catch method to handle any exception if any occurs. But whenever any error related to syntax or something occurs, we get internal server error

{

"errors": [

{

"code": 6220,

"domain": "%ObjectErrors",

"error": "ERROR #6220: Internal Server Error",

"id": "InternalError"

}

],

"summary": "ERROR #6220: Internal Server Error"

}

0 6
0 563

Hi Developers,

We're super excited to share with you the new awesome functionality of the Online Analytics Dashboard for every Community member 🔥

From now on, you can see your own detailed statistics for the current week, month, and all time, including:

  • number of views, likes, comments, followers
  • timeline graphics of views, likes, actions with your posts, comments
  • a table containing info about views, comments, and likes for your every post

      11 1
      0 549

      Does anyone have experience with CircleCI or really any automation tool using %UnitTest?

      I have built my app and ran my unit test in a Docker container automated by CircleCI. However, after many of the tests failed I see:

      How do you halt out of the IRIS session and return an exit code to the shell?

      I have a script in my repo that I pass into IRIS after CircleCI does the code checkout

      iris session IRIS < inFile

      0 8
      0 561