Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in November 2019!

New applications in November 2019

BridgeWorks VDM by Tony Coffman

BridgeWorks VDM is an ad hoc reporting and graphical SQL query application.

Designed for any user who needs access to their SQL projections in InterSystems Caché, InterSystems DeepSee, InterSystems IRIS, InterSystems IRIS for Health and InterSystems IRIS BI databases. VDM features a drag and a drop query builder, interactive data grids, charting, gauges, data visualizations, banded report writer, repo

Hello Community,

I would like to work in SQL developer with the tables from Caché.

Is it possible with JDBC tool?

What is the whole process in order to work in SQL developer?  I have the access information to Caché, but i can only choose in SQL Developer software only Oracle or MySQL database type, therefore i think, that have to install any  other tool.

Thank you in advance for your help!

br,

bálint

Hello,

I make some changes in our ObjectScript code between our prod environment  and dev environment in the process 'Hl7AdtFileIsoslBp'.

The operation is a class with "EnsLib.TCP.TextLineOutboundAdapter".

In prod:

In dev:

Like you can see, I don't have the contents of the text file.

I checked a lot of parameters but it seems identical.

The content of file is correctly received through TCP. So the only glitch is I don't see it in the 'View Full Contents'.

Best Regards.

Hello community,

I recently added a change to our copy of zenutils.js, and while moving it up to production, I found  different versions of zenutils.js.  I edited a copy stored in the default directory for our web application  (e.g. c:\intersystems\DEV\CSP\{application}) but the file on production is stored in {install dir}\CSP\broker.

Where should this file live, and if it lives in the default dir for our web application, is that location used before CSP\broker?  We have way too many copies of this file, and the copy that I edited was out of sync with the version on production.  I'd like

Hi Developers!

Here is what's we introduced in Developers Community features and UI last month:

• Pinned topics for main feed and tags;
• One-click unsubscribe option in every email we send;
• A 'new' indicator for the posts and comments;
• Notification of changes made by moderators;
• Articles without translation don't show 'access denied' anymore.

See the details below!

Hello,

We need to send data to an API using form_data as follows:

Using Ensemble 2017 we would use dynamic objects as:

set body={}.%Set("app_id",pRequest.appId).%Set("contents",contents).%Set("include_player_ids",pRequest.idsDispositivos)

However, how could we create a JSON to include into the form-data value??? We would like the following result: {"language1":"message1","language2":"message2"}

First we thought about creating it directly, however it stills being a dynamic object and wouldn't work with Ensemble 2016.2

set body = {
"app_id": "...",
"include_player_ids": ["...

When using $SYSTEM.Status.DecomposeStatus(tSC, .tErrorList) in ObjectScript to get the lsit of errors (I need to do this so that I can generate a custom JSON with the error messages) what is the type of tErrorList returned and how to intialize?

I need to know the type to iterate through it, I have tried dynamic array methods sich as %Size() also $LISTLENGTH to get the size, but both fails, so obviously not that, and being new to InterSystems I find the documentation assumes a new person knows what is behind the classes and how it was implemented from the start. The documentation of the does n

Does Caché have any features similar to PostgreSQL 'WITH RECURSIVE'? Something that allows recursion in SQL.
 

Hi,

I have a business service that needs to run only once a day at an specific time. It is important that the service only runs once.

I have tried the scheduler but you can only define the times (start-stop) when the service will be running...so this will not work for me as I need this to run only once.

Looking at the documentation I found "tasks". Apparently this is exactly what I need. As per documentation:

The recommended approach is to configure the business service with Pool Size = 0 and then use the Task Manager to launch a task that calls CreateBusinessService() on it and invokes ProcessInp

HI,

I have made a query with class definitions and all their properties and put them in a view.

All is good besides Parameters is showing junk characters. Is there a way to do it cleanly besides getting into the code??

SELECT 
CC.ID As CompiledClass, 
CC.SqlSchemaName,
CC.SqlTableName,
CP.Name As PropertyName, 
CP.SqlFieldName, 
CP.Type,
PD.Parameters

FROM %Dictionary.CompiledProperty CP
JOIN %Dictionary.CompiledClass CC
ON CP.Parent = CC.ID

JOIN %Dictionary.PropertyDefinition PD
ON PD.ID = CP.ID1

Hi Community,

We are pleased to invite you to the InterSystems Meetup in Moscow on December 10, 2019! 

InterSystems Moscow Meetup is a pre-New Year meeting for users and developers on InterSystems technologies. The meetup will be devoted to the InterSystems IRIS Data Platform.

Please check out the agenda:

I have the following class: 

Class P.RA.SII.F
{

Query ClosedFutures(FromDate As %Date, ToDate As %Date) As %Query(ROWSPEC = "FundCode:%String, Asset:%String, TradeDate:%Date,BuySell:%String, Price:Data.Common.Numeric, Quantity:%Numeric, CumulativePosition:%Numeric, PreviousCumulativePosition:%Numeric, ClosingTrades:%Integer, ClosingTradesInPeriod:%Integer, ClosedTradeValueInPeriod:Data.Common.Numeric, NetQuantityInPeriod:%Integer, WeightedClosedAverageTradePriceInPeriod:Data.Common.Numeric, InitialTradeDate:%Date, InitialTrade:%Integer, LastInPeriod:%Integer") [ SqlProc ]
{
}

ClassMetho

Hi Developers,

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

⏯ Showcase: InterSystems IRIS Directions

I am sending a HL7 message from a Service called Servicios.Interconsulta PeticionInterconsultav01r00  to a Bussiness Process Process called
EnrutadorVisa doMedicamento using SoapUI

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:hl7-org:v2xml">
   <soapenv:Header/>
   <soapenv:Body>
      <urn:PeticionER7>
         <!--Optional:-->
         <mensaje><![CDATA[MSH|^~\&|sistemaExterno|PETICIONER7, C.S.^12010410|380316|EXTHL7|20170901122402|scsdaeint:VXSn0jEG0OlDz6vIRz5ewA==|ORM^O01^ORM_O01|21147891|E|2.5|1|||AL||ASCII
PID|1|PRPR510419912012|6006642^^^MPI^6006

Index to Articles

Hi All

I am an avid user of ZEN for over 10 years now and it works for me.
But it seems that Intersystems are no longer actively developing it (or ZEN Mojo), the only published reference to this  is here

As an aside, Intersystems makes fine products (I have been using the technology for 35 years) and has great support BUT they are not good at being open with their product road map/retirement plans.  This is very embarrassing  to me when talking with my end user clients.

So I am looking at how to replace ZEN - this is not a short term project, at one client I have over

I have a class that inherits from %Library.CachePopulateand when I try to compile that class in IRIS I get an error does anyone out there know if this has been decapreated or the equivalent class please, in 2018.2 I can see the class in the documentation but in IRIS there is no reference to it

Hello,

I work with Ensemble Business Operation with SQL Outbound Adapter. I try to query a DSN defined database that happens to be Cache on the same machine in the same instance of Healthshare 2017.1.3. This worked fine on Linux server when I used JDBC driver. Now I want to run it on my Windows 10 laptop. I set up DSN and I can test connection successfully. I provided DSN in Operation DSN setting and I tried with and without Credential. I get ERROR <Ensd>ErrOutConnectFailed: ODBC Connect failed for 'myDSN'  / 'myDSN' with error ERROR #6022: Gateway failed: DSN/User Connect.

I tried to

Hello,

I would like to learn how to iterate over object's properties which name contains underscore _

For example, the API gives to us the following message:

[

    { "cod_cias": "12025222 ", "nombre_centro": "C.P. LA RESTINGA", "direccion": "C/ AVENIDA MARITIMA S/N (LA RESTINGA) ", "localidad": "EL PINAR", "telefono": "922922660", "longitud": "-17.98384130001068", "latitud": "-17.98384130001068", “tipo_centro”:”CP”, “punto_urgencia”:”N” },

    {"cod_cias": "12025223 ", "nombre_centro": "C.P. ISORA”, "direccion": "CTRA. GRAL. ISORA, S/N ", "localidad": "VALVERDE ", "telefono": "92

¡Hi everybody!

As you likely are aware, the new version of InterSystems IRIS for Health (I4H) it's already available in Docker Hub. It's the Community version and is free and fully functional. There have been comments about it in other articles and posts,... so today I won't add anything about features. Here I want to explore "the mistery about the disappearance, or better, absence of our persistent data when we run a container with the durable option"  (I didn't find a terrifying font to emphasize the thriller... post editor is not terrific for styling ) .

Hi Developers,

New video, recorded by @Stefan Wittmann, is already on InterSystems Developers YouTube:

🗣 Multi-Inheritance in a Multi-Model Environment

Hello Wonderful Community!

The question I have is: 

Can we set a Call Alert instead of an email alert (or both) in Ensemble when the system goes down? 

The message below is what we got via email. But I wanted to know if there is more functionality that allows to use a call system.

Subject: [CACHE SEVERE ERROR] Failed to allocate 43322MB shared memory using Huge Pages. Startup will retry with standard pages. If huge pages are needed for performance, check the OS settings and consider marking them as required with th...

11/23/19-15:01:58:494 (4458) 2 Failed to allocate 43322MB shared memo

Please can I have a quick simple answer.

I am still learning.

Thank-you.

I have SQLCompute with SQLComputeCode on a couple of Properties in my class.

These work fin when I insert/update via ObjectScript or SQL from the ManagementPortal.

However, if I insert (create new record) via my C# app using the Caché ODBC DLL the SQLCompute is ignored, it does not run.

Is this expected InterSystems Caché behaviour? We are on latest IRIS platform.

I'm pleased to announce the latest version of extensions for ObjectScript. Just a month has gone since my latest update, and I already have something new to show.

Important. In this version connection to the server will be disabled by default. You have to activate connection through the settings:"objectscript.conn.active" = true.

Hi All - Been looking in the documentation to see if, in DeepSee->Analyzer there's a way to create a filter on the "Most" recent date in a dimension.    The filter affords the ability to choose "Now" but sometime the most recent date in the data was a week ago.

Currently, many of you has some knowledge about CachéQuality (which is being renamed to objectscriptQuality) for analyzing objectscript code using the rules we have predefined. Probably you have tested it and have found too many warnings in your projects. I'm sure there are issues which are really important for you and some others which you would like to dismiss.

We have more than 90 rules to test different code situations and warn about a problem or a possible bug in code. But using all the rules is not always the desired situation (as I said before, maybe some rules are not useful for your

Hello everyone,

I am searching, but i cannot find a way to call a Procedure in Caché with PHP. Using .NET we have the Intersystems.Data.CacheClient.CacheCommand and we make a call in a Procedure. How i can do the same in PHP?

Regards,
Flávio

InterSystems has corrected a defect that can cause shadowing to fail with an access violation. In rare cases, the defect can cause memory corruption, leading to unpredictable behavior. 

Note: The defect does not affect mirroring.

This defect affects:

• InterSystems IRIS 2019.1.1 and 2019.3
• IRIS for Health 2019.1.1 and 2019.3
• HealthShare Health Connect 2019.1.1
• HealthShare Health Connect (HSAP) 15.032 on 2018.1.3
• Caché and Ensemble 2018.1.3

In InterSystems IRIS and IRIS for Health, shadowing code is included, but it should not be used; InterSystems recommends using mirroring, which