Question Minoru Horita · Apr 11, 2019

SQL projections of dictionaries in IRIS NLP (a.k.a iKnow)

In Cache'/Ensemble, by specifying the objectsPackage parameter, dictionaries (and other objects) get projected to tables that can be accessed by SQL queries.

But in IRIS (IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2019.1 (Build 507U) Mon Feb 25 2019 13:47:16 EST), when I created a dictionary with ##class(%iKnow.Matching.DictionaryAPI).CreateDictionary(), it does not get projected to a table.

The class APIs correctly retrieve information about this dictionary.

Am I missing something with IRIS, or is there any issues about this?

#InterSystems Natural Language Processing (NLP, iKnow) #InterSystems IRIS
2
0 398
Article Eduard Lebedyuk · Feb 20, 2018 1m read

Determine programmatically if unit tests failed

I needed to know programmatically if last ran failed or not.

After some exploring, here's the code:

ClassMethod isLastTestOk() As %Boolean{  set in = ##class(%UnitTest.Result.TestInstance).%OpenId(^UnitTest.Result)  for i=1:1:in.TestSuites.Count() {    #dim suite As %UnitTest.Result.TestSuite    set suite = in.TestSuites.GetAt(i)    return:suite.Status=0 $$$NO  }  quit $$$YES}
#Caché #Beginner #Best Practices #Code Snippet #Testing
4
1 697
Question Neerav Verma · Apr 12, 2019

Method Performance Statistics

Hello All,

There are few tools for SQL optimization available and even query builder has Show Plan to give us an estimation of the resources needed to execute.

For Methods - Is there anything similar ??

I would like to see a similar approach as to the time taken for method to execute.

Is Studio Debugger only option ??

#Caché
2
0 442
Announcement Anastasia Dyubaylo · Apr 12, 2019

InterSystems at DockerCon 2019: "Containerized Databases for Enterprise Applications" Session

Hi Community!

We're pleased to invite you to the DockerCon 2019 – the #1 container industry conference for all things Kubernetes, microservices, and DevOps. The event will be held at the Moscone Center in San Francisco from April 29 to May 2.

In addition, there will be a special session "Containerized Databases for Enterprise Applications" presented by @Thomas Carroll,  Product Specialist at InterSystems. 

See the details below.

#Other #Cloud #Containerization #Docker #Events #Kubernetes
1
0 378
Question Thembelani Mlalazi · Apr 11, 2019

CSP how to auto refresh with COS

I have a query that I would like to  have refreshing at certain intervals lets say every 30 seconds with out refreshing the page content using the META TAGS

refreshes the whole page but I have a jquery function that will run at those intervals that I can use the problem is getting the jquery to call my COS function or is the way to do it with pure COS

<html>
<head>
<!--meta http-equiv="refresh" content="30"-->
<!-- Put your page Title here -->
<title>    Cache Server Page </title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/
libs/jquery/1.3.0/jquery.min.
#Caché #CSP #JavaScript #ObjectScript #Frontend
2
0 516
Question David.Satorres6134 · Apr 11, 2019

Error 7802 using WorkMgr

Hi all,

I'm facing the error 7802 ("Worker job/s unexpectedly shut down") when trying to work with the Queue Manager. Since today it was working fine, but suddenly today it started failing when arriving to the line:

Set sc=queue.WaitForComplete()

The method is pretty simple: first I invoke the queue manager by doing set queue=$SYSTEM.WorkMgr.Initialize("/multicompile=1",.tSc,64), and then into a loop I call a method exactly 64 times. Then after the first 64 processes are done, the system launches 64 more jobs.

#InterSystems IRIS #ObjectScript
1
0 640
Article Timur Safin · Apr 1, 2019 3m read

Closures in ObjectScript

After many sleepless nights it's a pleasure to announce the newer, better, moderner ObjectScript compiler which implemented pretty much everything you ever wanted to have in modern ObjectScript:

  • Design objective of this new compiler is to parse reasonable subset of current ObjectScript syntax which will look readable for stranger, and not scare them with 1 letter syntax. The good start for compiler was the old-good COS Guidelines from here https://github.com/intersystems-ru/cos-guidelines
  • For reasons we mentioned above we do not parse 1 letter syntax. It's declared evil;
  • We do not handle dotted syntax for the same reason - modern syntax with {} is proper replacement for dotted syntax blocks;

But we not only parse the modern ObjectScript syntax, we have implemented finally the long-standing request which we always dreamed about. Closures!

#Caché #ObjectScript
9
3 850
Question Yaron Munz · Apr 11, 2019

Business Process (BPL) scope and empty request/response objects

In a Business Process (BPL) I noticed that if I 'm using a "scope" to handle errors  then inside the "scope" when a "call" is used, the "request" and "response" action (i.e set for callrequest.prop = request.prop & response.prop = callrespones.prop does NOT work !
The result is that the values of those properties in the callrequest  are nulls (I do see the properties names in the content of the callrequest message)

What is the best way to solve this issue ?
As it seems that there are new instances of the request/response objects inside the scope, whats the best way to pass them into the scope ?

#Ensemble #Business Process (BPL) #Error Handling
1
0 361
Question Scott Roth · Apr 9, 2019

SOAP Request Header

I have a wdsl soap request that now requires a header. Where do I modify the header to allow this new value to be sent?

   <soapenv:Header>
    <Headers xmlns="urn:epic-com.2013.Interconnect.Headers"> 
      <Epic-Client-ID>12349fe5-2ff8-4b79-b723-e69efbabcdef</Epic-Client-ID>
    </Headers>
   </soapenv:Header>

Thanks

Scott

#Caché #ObjectScript
7
1 788
Question Chip Gore · Apr 4, 2019

How does FHIR work on "Latest HealthShare" WITHOUT Using the ODS?

Hi -

I was wondering how if the "old FHIR gateway" works with the latest release of HealthShare Information Exchange. Since there is an impact on the amount of storage needed to use the "FHIR Gateway 2 which uses the Operation Data Store (ODS)", my question is how (if at all) can FHIR access to Information Exchange work without ODS?

Thanks

#HealthShare #FHIR
1
0 564
Question Thembelani Mlalazi · Apr 10, 2019

Base64 Encoding Errors

I am trying to base64 encode a string with non standard characters encoded in utf-8 also tried windows 1252  and I am getting error like so 

ERROR <Ens>ErrException: <ILLEGAL VALUE>zEncodeStream+18^ -- logged as '-' number - @' set encString = $TRANSLATE($SYSTEM.Encryption.Base64Encode(streamString),$C(10,13))'

any help appreciated if anyone has faced this before

#HealthShare #Business Operation #ObjectScript
2
0 902
InterSystems Official Jeff Fried · Apr 9, 2019

Health Connect version 2019.1 released

The 2019.1 version of HealthShare Health Connect is now Generally Available!

Kits and container images are available via the WRC download site 

The build number for these releases is 2019.1.0.510.0.18883

Health Connect 2019.1 includes many new features and capabilities, most notably:

  • FHIR STU3 Support
  • Java Business Hosts
  • Managed File Transfer (MFT)
  • Containerized and cloud deployment
  • New interoperability capabilities that speed configuration and troubleshooting of productions

These are detailed in the documentation and release notes for Health Connect

Upgrades - Health Connect 2019.

#Health Connect #HealthShare #InterSystems Official #Interoperability
0
0 675
Question Sergio Vidal · Mar 21, 2019

Deepsee and Ens.MessageHeader

Hi,

I want to create a messages statistics group by month and year using deepsee. To do that I'm creating a DeepSee data model based on Ens.MessageHeader.

I added both SourceConfigName and TargetConfigName as dimensions and now I'm trying to add TimeCreated but I get these messages 

ERROR #5001: Level in time dimension must have a timeFunction: TimeCreated.H1.TimeCreated
  > ERROR #5490: Error running generator for method '%GetModel:User.Mensajes' 
ERROR: %DeepSee.CubeDefinition.cls(%GetModel) of generated code compiling subclass 'User.
#InterSystems IRIS BI (DeepSee) #Message Search
3
1 433
Question KI Joon Keum · Apr 4, 2019

Application ACK not working

I trying to get ACK back from the destination to the sending system.

I configured the Business Services to Ack Mode Application but sending system is getting Ensemble generated ACK [7] not destination ACK [9].

This is Ensemble 2018.1.1.312.0.

Ultimately I would like a NACK back when I have a Business Rule that blocks a messages from sending to Business Operations but currently [5] is an ACK |AA

|.

#Ensemble #Business Service
5
0 947
Article Eduard Lebedyuk · Apr 8, 2019 4m read

Should we use computers?

The titular question was quite relevant and often discussed some thirty years ago. The thought went: “Sure, there are industries where computers are the norm, but in my industry we got just fine so far, the benefits are questionable, problems innumerable and unsolved. Can we continue as before or should we embrace this new technology?”

Today, everyone asks the same question but about Machine Learning and Artificial Intelligence. The doubts are the same – lack of expertise, lack of known path, perceived irrelevancy to the industry.

Yet, as before, the correct, even the only possible answer is a resounding yes. Read on to find out why.

#InterSystems IRIS #Artificial Intelligence (AI) #Machine Learning (ML)
Open Exchange
1
1 454
Question Miguel Delvalle · Apr 2, 2019

Upgrade Vs Parallel install

Hello All,

Our Group currently has the following version of Healthshare, and Ensemble installed:

Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2015.2.1 (Build 705U) Mon Aug 31 2015 16:53:38 EDT [HealthShare Modules:Core:14.01.7913 + Linkage Engine:14.0.7913 + Patient Index:14.0.7913 + Clinical Viewer:14.0.7913 + Active Analytics:14.01.7913]

We are planning on upgrading all of our instances from 2015.2.1 to the latest version (currently 2018) starting in May. 

These instances are responsible for receiving data (i.e.

#Ensemble #HealthShare
3
0 604
Question Thembelani Mlalazi · Apr 5, 2019

How to compare time

I am trying to get the time difference between two time stamps one is recorded earlier to the one happening current but the problem is sql expect string while I have the other stored in a variable and if I do the following I get errors any help please

&sql(SELECT {fn TIMESTAMPDIFF(SQL_TSI_HOUR,$ZDT($H,3,1,3),tx)})

 

please note that tx is a variable holding the time formatted the same way as the one being compared to

#Caché #Beginner #CSP #Databases
3
0 822
Announcement Evgeny Shvarov · Apr 6, 2019

InterSystems Open Exchange March 2019 Digest

Hi Community!

This is the update on what are the new applications submitted on OpenExchange in March 2019

New Applications

isc-tar  published by @Dmitry Maslennikov 

Compact files as TAR or Extract files from TAR files

Light weight EXCEL download v.1.0 published by @Robert Cemper 

This is the working example of a light weight export to EXCEL based on data in SAMPLES namespace. Good old CSP is well equipped to produce HTML tables accepted from EXCEL as input. With modern Browsers you don't even need and tags. So the required code around your SQL result set is really slim. And you are free to add any formatting you need either by HTML or in SQL.

PythonGateway v.0.7 published by @Eduard Lebedyuk 

Python Gateway for InterSystems Data Platforms.

Adopted Bitmaps v.1.0 published by @Robert Cemper 

This is a running example of the Bitmap Adoption

WebSockets Tutorial v.1.0 published by @Lily Taub 

A short tutorial on WebSockets in InterSystems IRIS 2018.1+ and Caché 2016.2+

Sync Data with DSTIME v.1.0.0 published by @Robert Cemper

Other Sync-Tools just work from Caché/IRIS to Caché/IRIS. Synchronizing your data to some external DB you requires some other solution. DSTIME can do it.

HL7 and SMS Interoperability Demo v.1.3 published by @Amir Samary 

This demo shows how easy it is to integrate an Electronic Medical Record system that is sending HL7 messages with AWS.

#InterSystems IRIS #InterSystems IRIS for Health #Open Exchange #Digest
0
0 259
Question Robert Hanna · Apr 4, 2019

%GSIZE vs %SYS.GlobalQuery for Estimating Size of Globals

Hey everyone, 

I stumbled across a comment in this post that mentioned that the %SYS.GlobalQuery is a potentially faster alternative to %GSIZE. I tested it out and while I like the %SYS.GlobalQuery I noticed that it has some size discrepancies against a %GSIZE with details.  Can anyone tell me which is more accurate for estimating the size of globals?

Here is an example of one of the differences I saw. From this it looks like the size is estimated to about 70gb from %GSIZE and about 67gb from %SYS.GlobalQuery.

%GSIZE Output:

Ens.

#Caché #Ensemble
2
1 2728
Question Rodolfo Santos · Apr 2, 2019

Show ResultSet content in Business Process

Hello everyone!
I need to have a ResultSet of type % SQL.Statement show its contents when it is trafficked in a message property by Business Process.
I tried to use the % XML.DataSet type that inherits properties of type % XML.Adaptor, but did not work.
Is there any other way to traffic as an object, other than within a Stream?

Note: I can not traffic Streams and I will not be able to use Correlate in this case.

#Ensemble #SQL #XML
3
0 298
Question Laura Cavanaugh · Apr 4, 2019

CSP Gateway Management via Managment Portal link returns a page with a '0' and nothing else

On one of our servers, when I am in Mgmt Portal and click the link for Configure / CSP Gateway Management, I get this url:

http://ipaddress.of.server:port/INSTANCENAME/csp/bin/Systems/Module.cxw?CSPSYS=0&CSPSYSreferer=_CSP.Portal.Home.zen

but the page displays a 0, and nothing else. Literally, just a 0.  This link works on our other servers, with the same URL.  Any idea why? 

Thanks,

Laura

#Caché #CSP #Management Portal
4
0 382
Question Thomas Van Beveren · Mar 20, 2019

Controlling LDAP authentication

Hello everyone,

i am in process of changing our authentication method, so we can integrate our AD authentication in our programs. At the moment i am using they %SYS.LDAP object, and trying to use the .Bind() method with the user information to authenticate. This seems to work without issues, but here the problems start.

When i flag a user 'Change password on next logon' in our Active Directory, the Bind fails with a status error: "Invalid Credentials". To make sure the user who logged in is in fact the user to change the password.

#Caché #LDAP
1
0 557