InterSystems Developer Community is a community of 11,999 amazing developers
We're a place where coders learn and share, stay up-to-date, grow together and have fun!

I am trying to troubleshoot an issue I am having with the JDBC Gateway Server crashing at the %SYS level. I have numerous Linked Tables that are using JDBC to connect to a MS SQL database/tables to query values. I have written queries in other class files and within the class definition of the linked table to do the queries.

1. Should I be running the query in the class definition of the linked table as a class method? or is it best practice to run the query as a class method outside of the class definition of the linked table?

0 3
0 93

Recently viewed a demo on the new Dynamic Objects in InterSystems (we are still running 2016.1); together with the upcoming IRIS data platform I started thinking about possibilities of building dynamic databases. That is, I can imagine some projects were it might be really nice to store dynamic objects and then run sql queries on them without ever defining the fields of the dynamic objects (i.e. not at storage, but only if you run your sql query).

0 3
0 530

We are seeking an InterSystems Object Developer With Docker Experience to join our team! You will develop and implement unique web-based applications.

This role is Remote, Full Time and a 1099 position.

Required Qualifications:

  • 4+ years InterSystems Object Technology developing applications utilizing industry best practices for software development.
  • 2+ years using Docker


1 0
0 107

I have installed Iris in Docker container with the above version. I need to create an additional user to log in via ssh. I have created a user and put in both the irisuser and irisowner groups, and created a user in iris with permissions. But, when I run "iris session iris" I originally got an error about permissions: /usr/irissys/bin/irisdb: Permission denied.

I looked @ the /usr/irisys directory and the permissions was only (r-x------). I changed to (dr-xr-xr-x.)and now I get a different error:

Invalid ownership for ./irisdb

Any suggestions?

0 8
0 118


I’m creating a REST API service but I need to convert my object in JSON.

Class message_B Extends Ens.Request
Property ClientId As %String(MAXLEN = "");

Property mesagge As %Stream.TmpBinary;

set pRequest = ##Class(message_B).%New()
​do ##class(Ens.Util.JSON).ObjectToJSONStream(pRequest, .content)

it is ignoring message property in json dueto its data type %Stream.TmpBinary

Could you please help me to resolve it?

0 2
0 84

HI Dev's

I dont work for Intersystems but i have found this training course very helpful and wanted to make sure others know about it.

Advanced Data Transformations

Advanced Data Transformations

Add a for each loop.
Create and use utility functions.
Create and use lookup tables.
Use counting.
Create and implement a subtransformation.
Add a code action.
Add a group of actions to organize relevant actions.

2 0
0 93

The capacity of taking numerous records every second while also facilitating real-time queries simultaneously in real time is called Hybrid Transactional Analytical Processing (HTAP). It is also called Transactional analytics or Transanalytics or Translytics and is a very useful element in scenarios where there is constant flow of real time data coming from IIOT sensors or data on fluctuations in stock market, and supporting the need for querying these data sets in real-time or near real-time.

3 2
0 112

In this post, I am going to detail how to set up a mirror using SSL, including generating the certificates and keys via the Public Key Infrastructure built in to InterSystems IRIS Data Platform. I did a similar post in the past for Caché, so feel free to check that out here if you are not running InterSystems IRIS. Much like the original, the goal of this is to take you from new installations to a working mirror with SSL, including a primary, backup, and DR async member, along with a mirrored database. I will not go into security recommendations or restricting access to the files. This is meant to just simply get a mirror up and running. Example screenshots are taken on a 2018.1.1 version of IRIS, so yours may look slightly different.

6 3
3 885

Hi Community!

As announced in this post, next November 16 will take place the 1st meetup of the Spanish Developer Community. And registration is now open!

It is the first in-person event in Spain since the pandemic started and we are thrilled to reunite with our customers and partners. Are you in?

🗓 November 16, from 12:00 to 2:00 PM (CEST) + pizza & drinks

📍 The Westin Valencia Hotel

➡️ Click here for more details and registration >>

Note.- If you are already registered at the Iberia Summit and want to attend the Meetup, you have to register on the previous link too.

0 0
0 106

I am reading file values by position with comma-separated string and it gives me incorrect values on the below line because there is a comma within double quotes within a string.

I would like to remove any text that has quotes with object script or alternatively separate each value with pipe-delimited so that I can return position 8 as code and position 9 as a description

0 2
0 104


I am currently having the experience activating prometheus for iris db.

This environment that I speak uses IKO as a base.

I need to put 3 notes in the iris service area.

Are they:

annotations: "/monitor/metrics" "52772" "true"

I'm not finding this possibility in the IKO documentation.

Has anyone had this experience and can help us with this challenge?

0 4
0 98

Starting today, we have release the new CCR view page to beta users!

As the view page contains a lot of functionality, we are giving users the ability to toggle their session between the new UI and the classic UI view pages. Your sessions will default to the classic UI for now, but beta users will see a "View in New UI" button in the nav bar for Tier 0 and 1 CCRs:

Similarly, the new UI page will have a "View in Classic UI" button at the top:

3 1
0 44

Get certified on InterSystems IRIS System Administration!

Hello Community,

After beta testing the new InterSystems IRIS System Administration Specialist exam, the Certification Team of InterSystems Learning Services has performed the necessary calibration and adjustments to release it to our community. It is now ready for purchase and scheduling in the InterSystems certification exam catalog. Potential candidates can review the exam topics and the practice questions to help orient them to exam question approaches and content. Passing the exam allows you to claim an electronic certification badge that can be embedded in social media accounts such as Linkedin.

4 1
0 120

Visual Studio Code (VSCode) is the most popular code editor on the market. It was created by Microsoft and distributed as a free IDE. VSCode supports dozens of programming languages, including ObjectScript, Until 2018, Atelier (based on Eclipse). It was considered as one of the main options to develop InterSystems products.

5 1
4 275

I'm trying to create a read-only role for most pages on the Management Portal. However, I cannot figure out resource permissions for the HealthShare tab or how to assign custom resource permissions, if any, to the registries. I would like for the role to include read-only access to the registries (service, consent, otherwise). How do I go about doing this?

0 1
0 95

Context: Ensemble development with ObjectScript in a healthcare context - lots of HL7, and some web service stuff. We've used Studio up till now, alongside a lot of leaning on an external developer, but are expanding our team and doing more in-house. We are wondering about Visual Studio Code - not least because it looks easier to hook up to source management solutions. And we've noticed that the test environments that you get connected to when doing many of the online training courses on give you a Visual Studio Code environment.

0 3
1 144