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

In time for InterSystems Global Summit 2019 we at George James Software are pleased to offer a cloud-hosted evaluation environment where you can work with Serenji in Visual Studio Code, editing and debugging ObjectScript in a sandbox running InterSystems IRIS 2019.3 Community edition.

You can do it all from your web browser. Nothing will be installed on your workstation, nor will any settings have to be changed on it.

To take Serenji for a test drive please visit https://georgejames.com/dc-gitpod

Some time ago I developed an application that tackled a familarial problem faced by many developers when required to update multiple UAT or PRODUCTION sites with the latest Software patches that have been developed and tested on your DEV server and now need to be deployed to multiple sites running that software.

In principle the solution works as follows:

1) Prepare an XML export of affected classes/routines/csp pages/hl7 definitions et al

2) Optionally create a global export of any new globals or changes to existing globals

3) a class that contains a collection of methods where each me

Hi I am experienced with Ensemble but working in my first DeepSee project, so forgive me if this seems elementary. 

My question is, how do I clear  the data out? Every time I build I am adding more and more data. But I would like to revert my cube to being 0 so I can reload it and start over? Set my row count back to 0?

I am unable to remove/purge through the management portal

-I've tried to kill my cube Do ##class(%DeepSee.Utils).%KillCube("MyCube.Cube")  and then Rebuild it. 

Thanks In advance

Hello community,

I have a very simple REST API connection doing a POST of JSON messages via AZURE APIM. 

It worked successfully for few weeks until a day ago when i started receiving a bad response as below.

<META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW"><meta name="format-detection" content="telephone=no"><meta name="viewport" content="initial-scale=1.0"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><script type="text/javascript" src="/_Incapsula_Resource?......................................
 

Is there anything to put in the http header to avoid this message or any sugge

InterSystems Data Platforms products allow you to export and import security settings in two different ways.

This article talks about those options:

• On the command line, using ^SECURITY
• Programmatically, using the Export and Import methods of classes in the Security package

Exporting settings on the command line (^SECURITY)

You can export everything or individual sections of the security settings.

Exporting everything with ^SECURITY

With ^SECURITY, you can export or import all the security settings for an instance very simply. In the Terminal, go to the %SYS namespace and start ^SECURITY:

US

This quick guide shows how to serve HTTPS requests with InterSystems API Management. Advantage here is that you have your certs on one separated server and you don't need to configure each backend web-server separately.

Here's how:

1. Buy the domain name.

2. Adjust DNS records from your domain to the IAM IP address.

3. Generate HTTPS certificate and private key. I use Let's Encrypt - it's free.

4. Start IAM if you didn't already.

5. Send this request to IAM:

POST http://host:8001/certificates/
{
    "cert": "-----BEGIN CERTIFICATE-----...",
    "key": "-----BEGIN PRIVATE KEY-----..."