When I use Escape logic when inserting or updating Oracle Table I'm getting Max-Length exceeded error. With the original value the length is good but after I add Escape Logic, it causes value to be greater than max-length. The original value was "I visited O'Brien before heading out of town." and after added Escape logic it was "I visited O''Brien before heading out of town." Max-Length is 45.

INSERT INTO MyText
    (text)
VALUES
    ('I visited O''Brien before heading out of town.')
                 /\
             right here  
Any ideas around this?
SQL %Execute QUERY ERROR -

Hello guys, Can someone help me?

I have the error below when starting my IRIS instance.

--------------------------------------------

irisstart.exe error: pid = 2936
(112)
The service for the IRIS instance did not start.

Consult the Windows NT Application Event Log for details
using the Event Viewer application accessible from the
Administrative Tools menu.

You may find additional information in IRIS console log
(messages.log) in the manager directory.

Instance name = OTHER-INTEGRATIONS

------------------------

I even tried in emergency mode, and changing SystemStart to false in the .cpf.

When consulting

When I try to run Interoperability -> Interface Maps in 2022.1 on a very large namespace, I keep getting timeout errors. Even though I add filtering by Category, Text Search, etc... it still errors out no matter what. However if it is ran in one of our smaller namespaces it runs just fine. WRC told us the namespace is too big, however that should not matter on how many services, processes, and operations you have running. 

• Has anyone had this issue with Interoperability - Interface Maps timing out because of the size of the namespace?
• Does anyone have a way around it?
• Or does anyone else

I had some issues with my install so I tried removing the software using Windows Add/Remove programs but it just froze. It messed up my install and now I can't access the SMP. 

I tried reinstalling using the same commands I did on first install but it froze again. There were no logs in the installdir that was created. Windows log just shows install started.

Hello, I created HL7 router Extends Ens.Rule.Definition. When I click the dot to the left, it does not draw lines to targets. I tried to add ClassMethod OnGetConnections(), but it does not get executed.

If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you made a major change and expect a changed review just let me know.

On DR Async Member, I found that the addDatabase method cannot be used to add a non mirrored database to the mirror. Is there any other method?

Hi, what is the easiest way to clear all the tables which store FHIR data? The most straitforward approach is to get a list of tables using the information_schema.tables view, then execute dynamic SQL with the "delete from" clause, but perhaps some helper class has already been written for this purpose?

Hi,

In Objectscript it apperas these characters have a special meaning:

^var                                                                                          <- Does the ^ mean the variable after it is a Global
set status=##class(%SYS.Journal.System).GetState() <- Does the ## mean anything?
                                                                                                     Does the % mean anything?

Does the $ mean anything?

I have questions about Java Versions needed for setting up a %JDBC External Language Server

I'm trying to start the %JDBC. External Language Server my local instance of IRIS (2023.1.2). I've recently upgraded Java to version 21.0.1 

When starting the External Language Server, I get this error message:

Managing InterSystems Servers – Virtual  April 1-5, 2024

• Configure, manage, plan, and monitor system operations of InterSystems Data Platform technology
• This five-day course teaches system and database administrators how to install, configure and secure InterSystems server software, configure for high availability and disaster recovery, and monitor the system. Students also learn troubleshooting techniques.
• This course is applicable to both InterSystems IRIS and Caché. Although the course is mostly platform independent, students can complete the exercises using either Windows or Ubuntu.
•   

Hi,

I am having an issue when I am publishing data to FHIR which is hosting in AWS. I am sending the data to the Cloud FHIR url but getting the below error.

Any idea how to resolve this issue? Any example to cretae FHIR repository using Object script?

:<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>404 Not Found</title> </head><body> <h1>Not Found</h1> <p>The requested URL was not found on this server.</p> </body></html>

Now users can filter the CCR table by multiple conditions for the CCR tables displayed on the home page and the CCR tab of the System Details page.

Previously users were only able to filter the rows by one condition at a time. This made it cumbersome for users to quickly find CCRs that they knew met multiple conditions, as they would have to choose the condition that would produce the least number of results for them to then manually filter through. 

An example of filtering by multiple conditions that users can now do would be: show me all CCRs in the “CCR” system, that are in the “Closed”

I need to write test cases for Object script but need help for understanding the mock library in IRIS? Or need Suggestion for how to use mocking

Hi All,

I am writing few test for REST API need help from you guys as  I am new to Objectscript. I want to implement mocking into testcase but didn't get any good resource for the same. please help me

Hi Developers,

Thank you so much for being a part of the InterSystems Developer Community Ecosystem for yet another year! 

We love that you participate in the life of the Developer Community, Open Exchange, Global Masters, and Ideas Portal. 

We'd like to know how useful are our portals for you at this point. Please take a few moments to let us know what you think and what could be improved: 

👉 InterSystems Developer Ecosystem Annual Survey 2023 👈

Note: The survey will take less than 10 minutes to complete.

In case you're planning on deploying IRIS For Health, or any of our containerized products, via the IKO on OpenShift, I wanted to share some of the hurdles we had to overcome.

As with any IKO based installation, we first need to deploy the IKO itself. However we were getting this error:

Warning FailedCreate 75s (x16 over 3m59s) replicaset-controller Error creating: pods "intersystems-iris-operator-amd-f6757dcc-" is forbidden: unable to validate against any security context constraint:

proceeded by a list of all the security context constraints (SCCs) it could not validate against.

If you're like

Hello everyone,

I am looking for the syntax or the way to use a class created in the "BNA" Namespace (my application) from the %SYS Namespace.

Here is the context:

I have a "BNA" application contained in the "BNA" NS, this application provides a user creation functionality. This feature creates both the user in a table in the application and in the Iris system.

I created an initialization script for my database to be able to reset it at will, this script starts by emptying the database of this data, then initializes the basic data.

Hi Community,

It's time for the new batch of #KeyQuestions from the previous month.

Here are the Key Questions of February chosen by InterSystems Experts within all Communities:

Hi Developers!

I want to share with you the approach you can use working with Unit Testing which I personally find very convenient and robust.

Will not talk much here about Unit Testing, we have documentation, enough good articles on the topic not only on the Internet but here on Developers Community too,  e.g. this one.

How can you manage the Unit Testing of your ZPM module?

This is pretty handy with ZPM. It has a special command "test" which runs all the tests you mentioned in the module. You can execute it as shown below:

zpm:USER>module-name test

And this command runs all the tests you mentioned in module.xml.

Let's see how it works.

Hi VSCode users!

Just want to check with you, is this settings.json file ideal enough if I:

1. Want VSCode to connect to IRIS in docker?

2. Want to use VSCode SQL Tool?

The connection settings file:

{
    "files.associations": {
    
        "Dockerfile*": "dockerfile",
        "iris.script": "objectscript"
      },
    "objectscript.conn" :{
      "ns": "IRISAPP",
      "username":"_SYSTEM",
      "password": "SYS",
      "docker-compose": {
        "service": "iris",
        "internalPort": 52773
      }
    },
    "sqltools.connections": [
      {
        "namespace":

Online document says: TUNE TABLE updates the SQL table definition (and therefore requires privileges to alter the table definition). Commonly, TUNE TABLE also updates the corresponding persistent class definition. This allows the gathered statistics to be used by the query optimizer without requiring a class compilation.

I don't get the point.

What are the advantages/disadvantages of using the Person resource with a link to the Patient and Practitioner resources, rather than using the Patient and Practitioner resources directly without using the Person resources?

Hey Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ How to Migrate Your Instance to Apache - Linux Unix

Your may not realize it, but your InterSystems Login Account can be used to access a very wide array of InterSystems services to help you learn and use InterSystems IRIS and other InterSystems technologies more effectively.  Continue reading to learn more about how to unlock new technical knowledge and tools using your InterSystems Login account.  Also - after reading, please participate in the Poll at the bottom, so we can see how this article was useful to you!

What is an InterSystems Login Account? 

An InterSystems Login account is used to access various online services which serve

Hi Developers,

Our first Online Developer Roundtable of 2024 will take place on March 5th at 9 am ET | 3 pm CET. 

Tech talks:

1. ObjectScript Unit Testing Tools, Techniques and Best Practices - by @Timothy Leavitt , Development Manager, Application Services, InterSystems
2. Monitoring and Alerting Capabilities of InterSystems IRIS - by  @Mark Bolinsky , Principal Technology Architect, InterSystems Mark's presentation is rescheduled for the roundtable in April.

▶ Update: watch the recording of the roundtable below:

Hello everyone!
So, I am supposed to receive a REST-request into my production, and I need to send it, exactly as I received it, to another server.
I am struggling to find any good info on this, and have a hard time coming up with a good approach.
What would be the easiest way to do this?
- I have so far thought about possibly doing it with an EnsLib.REST.GenericService and then sending it with an EnsLib.REST.GenericOperation.
- I have also thought about manually creating a rest-service and somehow using %request and sending it directly if that would be possible.

I would be very thankful if I could

InterSystems FAQ rubric

You can use the %IndexBuilder class to perform index rebuilding using multiple processes.

Here is an example for the purpose of defining the standard index HomeStateIdx for the Home_State (state information of contact address) column of Sample.Person.

The steps are as follows:

1. Hide the index name to be added/rebuilt from the query optimizer.

>write$system.SQL.SetMapSelectability("Sample.Person","HomeStateIdx",0)
1

2. Add %IndexBuilder to the rightmost superclass of the class definition that defines the new index.

///The class definition statement is as follows (add it at

In the WRC, we often see customers contact us because they are having been provided a .PPK file for use with SFTP connections, but they don’t know how to use that key within InterSystems IRIS. This article will explain why this represents such a problem, and explain how to use the .PPK key to generate a Private / Public Key pair in a format recognized by InterSystems IRIS.

The Problem:

You are trying to use InterSystems IRIS to connect to a remote SFTP server.

Killer presentations are essential for opening doors, doing business and delighting customers. These types of presentations move away from the traditional and tiring topics and portions of texts, or even pictures of happy people to get closer to the interests of their audience.The best presentations materialize what customers are looking for into something they can see working. Instead of promises, examples in execution and the ability to be very close to what you want to do.

In this article I will show you how to structure your presentations, use some established techniques, but above all,