Hello,

First of all thank you for reading this question

Also thank you for giving an answer

We would need some help

Our objective is to spot all REST Services in a namespace

➡️ How could we detect all services with AdapterClassname  = EnsLib.HTTP.InboundAdapter , in an automatic way, in a namespace?

Does InterSystems IRIS will support Visual Studio 6.0 Enterprise Edition (Visual Basic)?

We are in the process of transitioning Intersystems Cache 2017 to Intersystems IRIS 2020 version.

For terminal based applications we can able to use the same DAT file used for Cache with minor changes.

For Web based we are using Visual studio 6.0(Visual Basic). Will IRIS supports Visual Studio 6?

While I am configuring from that GUI application, I am getting the error like, Access Denied or No connection could be established. Same configuration followed in Cache that works. 

Hi,

I have created a method than evaluates an XML expression using the EvaluateExpression method. I need to replace an element value by other string but I couldn't find the way of doing it.

To get that, first I have created the "%XML.XPATH.Document" object using an stream and then I have evaluated the XML expression with the "EvaluateExpression" method.

when i connect to DB via DBeaver , it always report Connection refused, i tried both Cache and IRIS but same error, I have already download intersystems-jdbc-3.2.0.jar as IRIS Driver.

And meanwhile SqlDBx tool is able to connect via internal Intersystems Cache Driver.

Hi Guys,

I'm new in HL7 and have seen the basic learning material in "HL7 Business Services and Business Operations" but I'm wondering if there are learning materials and samples that I can boost my HL7 knowledge pls?

Thanks

Hi Developers,

Watch the execution of a speed test for a heavy-ingestion use case on InterSystems IRIS:

⏯ InterSystems IRIS Speed Test: High-Volume Ingestion

Hi all,

I'm looking for a user-friendly way to make a method library available in DTL, and by user-friendly I mean via '..MyMethod()' or '$$$MyMacro()' rather than  '##class(MyPackage.MyClassName).MyMethod()'.

Does anybody know of a way to add a second superclass or a set of macros to a DTL ... or some other trick?

Cheers,

Otto

Hi colleagues!

Often when we collaborate to someone's repo in GitHub we do the following cycle:

Fork-Clone-Change-Commit-Push-Pull-Request-Merge to the original repo.

This is all great and works fine!

And if we want to make a second collaboration right after the merge you need to perform "Fetch upstream" to your forked repo first to "ingest" your own Pull-request in the original repo.

Geeky git-professionals do it with ease but this was always a headache for me so I usually simply deleted the fork and created a new one.

And today I figured that Github added a new UI feature that I can easily fetch-upstream for my fork with the original one and make it up to date and capable for pull-requests.

Here is where the button is:

This is a relief! )

Wanted to share this relief and productivity tip with you!

Bring more collaborations to Github repos!

And speaking of PR - I just made a PR with docker to Google Cloud Run deployment for the FHIRaaS demo made by @Anton Umnikov for the current FHIR Contest! Looking for more of your contributions!

We need to know how to pass a certain value, which in the .NET world is described as a byte array (i.e. byte[])

Background:

We have various libraries that were created in .NET 4.5 that are registered for COM interom, an example that we have is as follows:

.NET Signature:

public static byte[] CreateQrCode(string content, int width, int height, string imageFormat)

.NET utilisation:

byte[] image = Writer.CreateQrCode("http://redacted/", 100, 100, "png");

Intersystems utilisation:

do streamQrCode.CopyFrom(objGenerator.CreateQrCode("http://redacted/",100,100,"png"))

PROBLEM: We need to know what object to

I am trying to populate a table using the sql Data Import Wizard. The input file is a tab delimited text file. But the import keeps failing with a 104 error showing validation for the columns which use %Library.TimeStamp and %Boolean datatypes is failing. Yet when I insert values into the table through a SQL insert command, the values get saved correctly in the table.

For the TimeStamp format in the wizard form, I am choosing YYYY-MM-DD-HH:MI:SS because  there was no option for this format: YYYY-MM-DD HH:MM:SS. 

But even after I edited the time stamp column to use a dash between the DD and HH

Hello,

I'm quite new at InterSystems. I have a business process that's pointing two different business operations, but one of them I don't want it to point to.

I went through the FileSystem settings, data transformations, classes, and code to see what it could be, but I don't see why its connecting to this second operation. 

What other inner-system mechanics would I need to consider? What have might I have missed? 

I'm using a JDBC driver to connect PGSQL -> Cache.  I'm noticing when I run SELECT queries and COUNT(*) command against the same table, I get different result sets.  I'm pretty new to Cache in general - so I'm trying to understand why these would be different. 

Examples (TransID and InvNum should occur in every "row"):

SELECT COUNT(*) FROM ACCT.Services = 1,090,324 WHERE ACCT.Dept = 483

SELECT TransID FROM ACCT.Services = 1,085,776 WHERE ACCT.Dept = 483

SELECT InvNum FROM ACCT.Services = 586,023 WHERE ACCT.Dept = 483

(I tried the same thing in MSSQL via  LinkedServer and it unsurprisingly yielded

Hello community, 

I am in the process of building a Health Care Application named MediCloud and I was so excited to see that IRIS is one of a great choice that I can make for a database system. 

But, I am developing my system with ASP.NET Core Version 2.1. I did see that there is a way we could use .NET with IRIS using PEX (such a useful tip), is there a possibility I could do it ASP.NET Core as well.   

Or is it just limited to .Net for the time being? 

Cheers. 

Hello all, 

I am in a bit of a situation where I could get your help please. 

I want to get certified with IRIS, but I also do see that there is an availability named Cache. 

Are they both the same or different? if different please explain it to me as how? 

Also what is the difference between IRIS, IRIS for Health, Deep Sea? Please explain to me.

Also what do you think I should get my self certified with? 

Please leave your comments below. 

Cheers. 

We've traditionally run a selection of development environments from a single cache instance using different namespaces for DEV TEST PREP etc. This has come with a few drawbacks, mainly that you then cant break down into namespaces per environment and everything is sharing various options.

Is there a massive overhead to running multiple cache instances from the same 'box' instead?

How best to share the memory setup in that situation, we usually pre-define around 80% for the instance, do we just share that evenly between the multi instance scenario?

User antiterrorism is assigned the following SQL procedure privileges:

ERROR #5002: Cache error: <UNDEFINED>SQLUserPrivsExecute+57^%SYS.SQLSEC ^oddPROC("ENSEMBLE_ENS","BAIYAOJIREQUEST_EXTENT",27)

SOURCE ELEMENT: %CSP.UI.Component.SQLTables (SQLProcs)

Afternoon all,

Is there a way (at SQL level) to script out the definition of a Cache stored procedure from within SQL?

In SQL Server, I would do...

Select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME = 'my_sproc_name'

But cant find anyway to do this in cache.

Note, its an old version of Cache, so "INFORMATION_SCHEMA" is not available.

I am trying to see the SQL definition in the sproc from SQL itself.

Thanks all

I have some code in a mac routine that use indentation and the "." character : 
 

 IF condition1 DO
     .WRITE YCR,...
     .WRITE YCR,...
     .WRITE YCR,...

I would like to add a try / catch block between the write statements.
I can't refactor the whole code and use indentation with curly braces instead (there is too much code, not written by me)

I have tried the following but it does not work (it compiles, but code stop running right before the try keyword)

 IF condition1 DO
    try {
        .WRITE YCR,...
        .WRITE YCR,...
        .WRITE YCR,...
    }
    catch {
    }

Is this

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Cloud Backup Strategies

for debugging purposes of complex applications.

I believe most of you have encounted this problem: a healthconnect/ensemble user get a slow response and ask measurement on how long it takes ensmeble to process this request, the ensemble 'activity data' gives no clue of the delay.

The reason is HealthConnect message measurement was based on ensemble message, which can’t give a correct answer on when ensmeble recevie the request and what time it send back response. when there is delay on inbound/outbound adpter, or csp gateway, there is no way to find out the delay from "activity data" . 

I am asked by a customer how to deal with this problem.

I have run into two annoyances when using VS Code for server-side editing of Objectscript and was wondering if anyone knows of any solutions or workarounds.

1. In .mac routine files, class names that aren't fully qualified (e.g. ##class(example) instead of ##class(Package.example)) fail to be understood, so the class will have a red squiggly underneath it and a problem that reads

"Class 'example' does not exist. InterSystems Language Server".

In an old routine full of unqualified class names, it just fills the problems tab and drowns out the actual issues.

I am using MDX2JSON do display data, it uses CSP REST to retrieve data and uses Password Authentication. I enabled LDAP authentication for this applicaiton, but it does not work.

I cannot convert the R4 version of the JSON file through the built-in dtl, and convert it to SDA, I hope to get an answer, thank you very much

InterSystems Online Learning wants to know: What can we do for you? Take this brief survey by June 2 to let us know!

Hi Developers!  Let me share with you some exercises from a workshop about developing interoperability components in Java using PEX (Production EXtension).

You will find slides and step by step exercises about:

• Understanding simple PEX components coded in Java.
• Making some changes on them.

All built using containers, so you don't need to build a local Java environment.

You can reach the repository here: https://openexchange.intersystems.com/package/workshop-pex

It's a challenge when you need, as a software architect, design a corporate architecture to meet the current business requirements, you need achieve level 5. With InterSystems IRIS.
it's possible. With 1 product you get SQL + NoSQL + ESB + BI + Open Analytics + Real time virtual cubes + NLP + AutoML + ML (with Python) and Advanced cloud + Sharding support.

With Oracle, for example, you need Oracle DB + Oracle NoSQL + Oracle BI + Oracle SOA Suite + Some Oracle add-ons like Oracle R, Partitioning and RAC and some Oracle cloud products to NLP and AI features.

您好，我想问一下为什么我无法通过Iris中的内置转换模板将从HAPI-FHIR服务器下载的患者资源转换为SDA格式。它总是表明缺少某个默认值，或者这就是我们需要更改格式吗？我想问一下我们如何快速创建自己的映射，以及如何通过json将所需的数据转换为sda并将其存储在iris中，然后我们可以通过齐柏林飞艇进行调用，非常感谢您解决我的问题问题

Transaltion for the question:

Hello, I would like to ask why I am unable to convert patient resources downloaded from the HAPI-FHIR server to SDA format via the built-in conversion template in IRIS.

I am looking for an experienced IRIS for Health engineer to join the CVS Health family.

This position can be contractor, contractor for hire or direct hire.

We are doing our first implementation of the product and can use someone with experience.

The contractor role can be fully remote.

For a hire we are currently fully remote due to COVID, however, post CVID, we should be in a hybrid model (some remote and some onsite) in the Chicago area.