Hello,

Even after using the SSL connection in Oauth2 client Im getting the following error.

ERROR #8854: OAuth 2.0 messages must use SSL/TLS

Any help would be appreciated!

What is the best free/open source option to generate the database diagram (MER) to the iris or cache persistent classes?

It is possible develop a new interoperability adapter? If yes, how can I do it?

Some InterSystems Java libraries are not available in public maven repositories, like intersystems-jdbc-3.1.0.jar. In this case, to configure your Java Maven dependency, copy the external file to your project (for a folder visible to the classpath, like resources) and use <systemPath>. Follow the sample:

<dependency>
            <groupId>com.intersystems</groupId>
            <artifactId>intersystems-jdbc</artifactId>
            <version>3.1.0</version>
            <scope>system</scope>
            <systemPath>${project.basedir}/src/main/resources/intersystems-jdbc-3.1.0.jar</systemPath>

Hi :

    1591891200000 

      How do I convert the timestamp above to something like this format : 2020-06-12 00:00:00

Hi Everyone,

We are trying to migrate old server to new infrastructure and need to sync all the DTL cls from old one to new one. There are hundreds of DTL in system and we tried to export from production but cannot select all at once which might cause some missing classes. Not able to connect to studio or atelier with that server neither. Is there any way that we are able to do mass export from system which will save some effort? Please let me know your thoughts. Thanks.

Keywords:  PyODBC, unixODBC, IRIS, IntegratedML, Jupyter Notebook, Python 3

Purpose

A few months ago I touched on a brief note on "Python JDBC connection into IRIS", and since then I referred to it more frequently than my own scratchpad hidden deep in my PC. Hence, here comes up another 5-minute note on how to make "Python ODBC connection into IRIS".

ODBC and PyODBC seem pretty easy to set up in a Windows client, yet every time I stumbled a bit somewhere on setting up an unixODBC and PyODBC client in a Linux/Unix-style server.

Is there a as simple yet consistent approach as it's supposed to be

Hello,

I'm trying to upload file to SFTP server.  

I have access to SFTP server . 
My code is bellow 

Try {
Set sftp = ##class(%Net.SSH.Session).%New()

Set sc = sftp.AuthenticateWithUsername(username,password)
if 'sftp.Connect(host){
            Set status = $$$ERROR($$$GeneralError,"Cannot connect to sftp  ")
            Quit       
}
Set sc = sftp.OpenSFTP(.t)

If 'sftp.Disconnect() Write "Failed to logout",!

}Catch ex {
Set status=$$$ERROR($$$GeneralError,$ZE)
Quit
}

The output : $lb(5001,"Cannot connect to sftp "

What i'm doing wrong ?

Hi Community!

Do you know how to create workflow users and roles programmatically?
I use Docker for test deploy and I need to set up IRIS Interoperability using the install script.

Maybe do you know how to import/export already existing workflow users and roles?

Hello,

I want to deploy Iris Interoperability Production in multiple containers . The production has File Services that process files from EFS location. All the files being processed by multiple containers are in the same directory. The standard Adapter class does not have Check Complete option to lock a file so that other containers File Services looking in the same file path cannot process the same file.

I updated the Inbound File Adapter class to offer another Check Complete option LOCK that will lock the file until it is processed and archived.

Has anybody else encountered conflicts when

Hi Devs!

Last weekend I had been testing the newborn csvgen module and was looking for a CSV file to test - thus I came across an interesting datafile on Data.World  with Game of Throne episodes statistics. Death statistics. These folks documented all the murders through all the 8 seasons and noted where, who, from what clan with what weapon had killed another one.

So I imported it and made an IRIS Analytics dashboard.

Don't worry, Jon,  with this dashboard we can figure out something ). See the details below.

Hello,

In the DTL, is there a way to set a value for the HL7 data element in the code section?

For example,
set target.SetValueAt("PID:3(k1).1)") = mrn (mrn is the value returned from the SQL query)

When I ran the test utility, I got this error message.

ERROR ErrException:
I tried both target.SetValueAt("PID:3(k1).1)") and target.GetValueAt("PID:3(k1).1)").That didn’t make a difference.The code still error out.

The latest WebComponent-based, SB Admin 2-themed QEWD Monitor application now includes a cool D3-based viewer for visualising your IRIS or Cache Globals - see example below

This qewd-monitor-adminui application is automatically installed when you install QEWD on a Windows machine

See here for details on installing QEWD on Windows:

https://github.com/robtweed/qewd-microservices-examples/blob/master/WINDOWS-IRIS-2.md#initial-steps
 

Hello,

I'm working on integrating a Cache database into an existing .NET project of mine.  I'm trying to execute certain queries utilizing the Cache ODBC driver.  The first error I ran into was "[S1000] [Cache ODBC][State : S1000][Native Code 417] Access Denied".  The part that's throwing me for a loop though is that the application ran ~200 successful queries before I started getting that.  After some of those Access Denied errors, they turned into "[Cache ODBC][State : S1T00][Native Code 450] Request timed out due to user timeout".  This was all with the regular (2.5?) driver.

I then started

If you're interested in building a browser-based CRUD application for maintaining data on IRIS, check out the detailed, step-by-step tutorial at:

https://github.com/robtweed/qewd-microservices-examples/blob/master/WIN…

To get a preview of the application you'll build in the tutorial, along with background on its technology stack, watch this video:

https://www.youtube.com/watch?v=d-NICYqv_2s

In summary, the key features and technologies that you'll be using and building out in this tutorial include:

- fully responsive interactive browser-based application - will also display correctly

Hey Everyone! 

At InterSystems, the developer community is an integral part of our ecosystem and this role is pivotal in the development of our products and services. As a result, we wanted to undertake market research in recognition of this to discover how best businesses can support developers. We have already asked 300 developers their thoughts, but we wanted to extend this survey to reach more people and also get your views on the current climate as we have all had to adapt our working environments.

➡️ Please click this link to take part in our survey!  

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

Hi

on this code

set reader=##class(%XML.Reader).%New()
    set statuscode=reader.OpenFile(file)
    if $$$ISERR(statuscode) {do $System.Status.DisplayError(statuscode) quit $$$NULLOREF}

I got this error "unable to open file 'https://www.musicxml.org/dtds/partwise.dtd'"

or using the xml schema wisard i got the error  https is active but no configuration found.

where do I have configure it?

After all these years of doing basic Ensemble work, I am just beginning to venture into using Cache Tables instead of either Data Lookup tables, or what I know of Outside SQL tables using JDBC.  I have several Cache SQL tables that I am building for a project I am working on.  

• I was wondering if it was possible to use a SQL call to look up a value against a Cache SQL table  within a Business Rule? 
• Or is this something that I would have to build a custom function for? 

Within the Business Rule I need to test to see if a Location value exists within this table, and if it does then process

Many times it is necessary copy or send files to your docker container instance.

In my case was with IRIS JDBC driver.

Docker has this recipe for this (credits to https://docs.docker.com/engine/reference/commandline/cp/):

docker cp [OPTIONS] CONTAINER:SRC_PATH DEST_PATH|-
docker cp [OPTIONS] SRC_PATH|- CONTAINER:DEST_PATH

But to copy you need your container name. Write this command for this:

docker ps

In my, my-iris is the container name.

If you need to know file location into your docker file system too, write:

1. To go to bash of your docker instance: docker exec -it my-iris /bin/bash.
2.Write cd .

I want to receive an EDI file through Applicability Statement 2(AS2) transport and send back the acknowledgement to AS2 using Cache ObjectScript.

Previously I used to transfers the EDI files using FTP.

Can anyone please help on this.

Thanks in advance.

Hi Developers!

The InterSystems IRIS Native API Contest is over. Thank you all for participating in our IRIS Competition!

As a result – 8 great apps! And now it's time to announce the winners! 

Hi Community,

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ In-Place InterSystems IRIS Conversions

Hello everyone! 

I have REST API and want check user with http header authorization,

When user input incorrect data refuse them with 401 unauthorized,

Question how to response with 401 unauthorized

Hey I would like to INSERT mulitple rows to 1 table.  I need to intersystems cache equivelant for 

INSERT INTO table_name (column_list)
VALUES
    (value_list_1),
    (value_list_2),
    (value_list_3);

Have tried this post https://community.intersystems.com/post/how-execute-multiple-query-or-script-sql-management-studio
but still got an error

I have a table with 4 column: MRN (primary key), Name, DOB, and Gender. I want to bring in the values on all of the columns into a DTL. Currently, I declare variables for each of the columns and using 3 select statements.

  &sql(SELECT Name INTO :Name FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

  &sql(SELECT DOB INTO :DOB FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

  &sql(SELECT Gender INTO :Gender FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

Is there a way to do this in a single select statement?

Dear All, 

I am currently working on a project to record ORU^R01 into a global for a particular set of tests.

I have multiple OBX repeats that need to go into a specific fields withing one row/ record on the global.

I am having trouble finding a way to either count or loop though the OBX's correctly in ObjectScript often with the counter being undefined.

I have done this this way, as I am building upon an existing class to populate this global.

The latest iteration of my obx looping code is below:

// handle repeating obx's by setting count of value    
            set segcnt =

Some time ago I got a WRC case transferred where a customer asks for the availability of a raw DEFLATE compression/decompression function built-in Caché.

When we talk about DEFLATE we need to talk about Zlib as well, since Zlib is the de-facto standard free compression/decompression library developed in the mid-90s.

Zlib works on particular DEFLATE compression/decompression algorithm and the idea of encapsulation within a wrapper (gzip, zlib, etc.).
https://en.wikipedia.org/wiki/Zlib

In Caché Object Script (COS) we already have GZIP support available in using /GZIP=1 on file- or tcp-devices or

About regulations

Personal data privacy regulations have become an indispensable requirement for projects dealing with personal data. The compliance with these laws is based on 4 principles:

1. Compliance with the rights of the holder of personal data;
2. Governance of personal data assets;
3. Privacy by Design and by Default;
4. Data protection.

In case of violation in the treatment of personal data, controllers and operators of these data may suffer:

1. Fines of up to 4% of revenue or up to €20 million;
2. Shutdown of the digital service until the problem is corrected;
3. Publicity of the incident to the

Ready Computing is a full-service IT firm, specializing in software development and data exchange solutions within the healthcare industry.

We are looking for a highly-motivated staff that can guide clients in developing their healthcare IT strategy and back up that guidance with high quality technical work.Solution Consultants work directly with clients, IT vendors, and internal teammates to deliver integrated health solutions.Solution Consultants focus primarily on deploying high volume interfaces and interoperability software.

I've got a REST service that I can access via a browser. I can get it to take HTML tags as data and display it back to me (so I know the REST part is working). So if I send it this:

http://MyServer:57772/TestArea/rest/TestQuery?UUID=1&RTX=RTX123456&CareType=Palliative
 

Then I can pick out the data and tell it to display in the browser, which is great but what I really want to do is put the data into a string and send to a business process that will do lots of looking up but eventually return a URL that my REST service will then redirect the browser to.

Been trying to follow advice from here but