Dive into the details of InterSystems technologies with long-term online programs and classroom courses. Then, show off your skills with program and certification badges! Find all the details in this month's Learning newsletter. Don't forget to subscribe to receive the newsletter in your inbox!

I am unable to connect to InterSystems ODBC client. I am seeing the following error:

[Cache ODBC][State : S1000][Native Code 417] Access denied.

$cnx = new PDO("odbc:Driver={InterSystems ODBC};Server=<IP>;Uid=<id>;Pwd=<password>;");

Am i doing anything wrong?

Although, I can successfully connect and retrieve data in MS Excel using ODBC connection where I have configured my DSN and all

Hi,
i got 2 server with iris instances on them:

srv1
irisinstance1 port 51773/52773
irisinstance2 port 51774/52774

srv2
irisinstance3 port 51773/52773
irisinstance4 port 51774/52774

Both of them have apps published on an external apache on port 443 and i would like to publish irisinstance1 and irisinstance2 on port 443 of srv2.

Something like https://srv2/mgmt1/csp/sys/UtilHome.csp and similar to mgmt2.

I've tried with proxypass without luck.

How can i do that? Is there a guide?

Thanks!

How do I determine the size of an X12 message within the Rule Editor?  I should add this is for HealthConnect or Ensemble.

The FullSize property always shows 122, and the FullSizeGet method isn't available within the Rule Editor.

Our vendor can't handle messages over 500,000 characters, so I need to write those to another queue for later processing, and to get the interface into they're system from crashing.

Thanks,

getting an error while installing  git-source-control
Log of error 
 

zpm "install git-source-control"

[TTN|git-source-control]    Reload START (/Users/irisusr/mgr/.modules/TTN/git-source-control/2.2.0/)
[TTN|git-source-control]    Reload SUCCESS
[git-source-control]    Module object refreshed.
[TTN|git-source-control]    Validate START
[TTN|git-source-control]    Validate SUCCESS
[TTN|git-source-control]    Compile START
[git-source-control]    Compile FAILURE
ERROR!

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 did a major change and expect a changed review just let me know.

Hi Community,

Watch this video to learn how to manage your HealthShare HealthConnect Cloud deployments using the InterSystems CloudServices Portal. Inspect the details of your deployment, create users and productions in Health Connect Cloud, and access the System Management Portal for a given deployment:

⏯ Navigating the Health Connect Cloud Portal

I want to connect IRIS system as it has all the database tables. on top of that I am creating a REST API in python. How can I connect to IRIS DB. here is my example code for connection

def connect():

connection_string = "localhost:1972/USER"

username = "_SYSTEM"

password = "SYS"

conn = iris.connect(connection_string, username, password)

after this connection is created but how can I get tables data. Please let me know more about how we can integrate IRIS database into a python REST API.

I am working with a REST API JSON Response that contains a list of integers (departmentids).

JSON Response:

{
"status":"ACTIVE",
"departmentids":[
72
],
"subscriptions":[
{
"eventname":"LabResultAdd"
},
{
"eventname":"LabResultUpdate"
},
{
"eventname":"LabResultClose"
}
]
}

I am having trouble getting that to parse into my custom message structure using the %JSONImport method.

do pResponse.%JSONImport(tHttpResponse.Data.Read())

Here is my custom message class (pResponse):

Class AH.AHLIB.Custom.Athena.Message.GetEventsSubscribedResponse Extends (Ens.Response, %JSON.Adaptor)
{

Pr

I am trying to set up VS Code so that it will connect to a new server running IRIS 2023.1, and I can't seem to get the setup to accept my errors. I enter all the requested information, and at the end I receive a message:

Failed to store server '$(name)' definition.

Source: InterSystems Server Manager (Extension)

I've submitted a bug log with VSCode, but then I noticed the source, and figured it might be related to the extension instead of the program, and was wondering if others have received this message. The VSCode is 1.79.1, for the record.

Thanks as always.

Hello and welcome to the Developer Ecosystem Spring News!

This spring we've had a lot of online and offline activities in the InterSystems Developer Ecosystem. In case you missed something, we've prepared for you a selection of the hottest news and topics to catch up on!

Hi, I spend most of my time on VsCode and I love the dark theme.

But when I go to the InterSystems Community it's all white and I can't read anything.

Is it possible to have a dark theme for the community?

An interim idea to bring more dark to the docs with different font.

Process:

• In Firefox web browser address bar navigate to: "about:support"
• Look for label "Profile Folder", and click on the corresponding "Open Folder" button.
• Drill-down / Open sub-folder called Chrome.
• Create file here called: userContent.css

Content of file:

@-moz-document domain(docs.intersystems.com) {
:root {
 --iscbluelightest:#0c0405 !important;
 --iscbluelight:#91331f !important;
 --iscblue:#ccc96a !important;
 --iscbluedark:#c6bbb1 !important;
 --iscbluedarker:#dddacc !important;
 --iscbluedarkest:#e5e3d8

One of the most common needs of our clients is the creation of REST services that allow access to the information present in IRIS / HealthConnect. The advantage of these REST services is that it allows the development of custom user interfaces with the most current technologies taking advantage of the reliability and performance of IRIS in the back-end.

In today's article we are going to create a web service step by step that will allow us to both store data in our database and later consult them.

Looking to pull out HL7 Fields data to put into columns in a SQL table. How to handle the repeated fields & segments data  to SQL. 

Operations over the extracted data in SQL server  can help for Analysis.

Appreciate your Help!!

How to import Custom Schemas from VSCode? They look like this:

<?xml version="1.0"?><Categoryname="ITK"description="xmlns:hl7='urn:hl7-org:v2xml' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'"std="1"><MessageTypename='ACK'structure='ACK'returntype='ACK'description='xsi:schemaLocation="urn:hl7-org:v2xml ACK.xsd"'/></Category>

Instead of wrapped XML export produced by $system.OBJ:

Hi guys,

How can I get the list of printer in client Zen page?

We currently use an ActivexObject call "MSDesign.WebLabel" to get the list of printer loaded in a dropdown in our Zen pages:

        webControl = new ActiveXObject("MSDesign.WebLabel");
                  if (webControl!=null) printers = webControl.getPrinters();
and this will give us a list of printers available in client machine but this does work in Edge or Chrome, is there a tool or simple code that I can use to get me the list of printers available?

Thanks 

InterSystems FAQ rubric

Query cache can be purged programmatically using the Purge* methods of the %SYSTEM.SQL class.

*For details of each method, please refer to the following documents.

%SYSTEM.SQL class【IRIS】

%SYSTEM.SQL class

① When deleting all query caches in the system

Do $SYSTEM.SQL.PurgeAllNamespaces()

② When deleting the query cache in the namespace

// delete all cached queries in namespace
Do $SYSTEM.SQL.Purge()
// when deleting the query cache specified by date
// the following deletes the cache not used in the last 30 days
Do $SYSTEM.SQL.Purge(30) 

③ When specifying and deleting the query

InterSystems is committed to providing a high quality developer experience including a great IDE (Integrated Developer Experience). For the past several years we have been evolving Visual Studio Code's ObjectScript tooling in parallel with our long-standing IDE, InterSystems Studio. There have been over 46,000 downloads of the VSCode-ObjectScript plugin, and the feedback from developers is that this is a great developer experience, and now superior to InterSystems Studio.

With our 2023.2 release we are deprecating InterSystems Studio (deprecated designates a feature or technology that

Forgive me but our System Administrator who knows how the networking works is OOO...

How does IRIS know which local adapters are available to populate in an Inbound or Outbound TCP Adapter Object? We recently moved from HealthShare Health Connect 2018.1.3 to IRIS HealthShare Health Connect  2022.1. When we migrated we moved the VIP over to the new box and set it at the hardware level.

On RedHat when I do an ifconfig I have two ens192 adapaters..

ens192: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 8900
        inet xxxxxx  netmask xxxxx broadcast xxxxxxxx
        inet6 xxxxxxx  prefixlen 64

Demonstration example for the current Grand Prix contest for use of a more complex Parameter template to test the AI.

Interview Questions

There is documentation. A recruitment consultant wants to quickly challenge candidates with some relevant technical questions to a role.

Can they automate making a list of questions and answers from the available documentation?

Interview Answers and Learning

One of the most effective ways to cement new facts into accessible long term memory is with phased recall.

In essence you take a block of text information, reorganize it into a series of self-contained

how can we track logs of our rest api that we create in web applications. As i am running it on local system.

Hi Community, 

We invite you to join our next Developer Meetup in Boston: What happens next? Demos of the Latest Predictive Analytics technology.

Date: Monday, June 26, 2023 at 5:30 PM - 7:30 PM
Location: Venture Café Cambridge

>> RSVP here <<

I am trying to write the module.xml for a package that creates a web application associated with the %SYS namespace.

I didn't find a way of specifying that the CSPApplication tag should create the app for a specific namespace. It apparently gets set up to use the namespace in which the package install command gets run. This contrasts with how an installer manifest works, where the <CSPApplication> tag is put inside a <Namespace> tag.

So I wondered if I could make my package fail installation if the current namespace isn't %SYS.My package doesn't need to load anything, only create the web app.

How can I download caché 2016 now?

Posing a question to consider during the current Grand Prix competition.

I wanted to share an observation about using PDFs with LangChain.

When loading the text out of a PDF, I noticed there was an artifact of gaps within some of the words extracted.

For example (highlighted in red)

This is for the veteran programmers out there (you know who you are; you started programming before date 60000). 

I'm in the middle of updates for our system, and I've come across many $ZU() calls. Most of them are documented in the "Replacement List", but two are missing: $ZUtil(0) and $ZUtil(1).

I honestly don't remember what these are for (and I'm pretty sure I used them in code in a previous century), so if someone can tell me, great.  If you can provide a link to a reference, better!  

As always, I appreciate your help.

This is my delphi code

procedure TForm2.Button1Click(Sender: TObject);
var
 cmd:string;
 sResult:string;
begin
    cmd:='$$Check^logininput()';
    vism1.Code:=cmd;
    sResult:=vism1.Value;
end;

end.

Hello!

I would like to find all classes not up to date in a namespace programmatically.

With IRIS Studio, we can see the single "+", but I don't know how to do that with a script.

Set sql = "SELECT ID, Name FROM %Dictionary.ClassDefinition WHERE NOT ID %STARTSWITH ?"Set params($Increment(params)) = "%"Set tResult = ##class(%SQL.Statement).%ExecDirect(, sql, params...)

If (tResult.%SQLCODE'=0)&&(tResult.%SQLCODE'=100) Set sc = $$$ERROR($$$SQLError, tResult.%SQLCODE, tResult.%Message) Quit sc

While tResult.%Next() {
    // if class not up to date ??
}

Intro

If you ever wondered how to debug some requests that are being made to or from IRIS, well here is a little tutorial on how to do that.

During a complex project, usually you get the specifications and implement the communication between IRIS and other things based on that. But from the paper to the real world there's usually a huge gap and you need to know why you are receiving an error on a parameter, on a header, you are not receiving the data and so on.

If the connection is a plain http connection there's no problem, you can always fire up tcpdump and capure the traffic, but what about