Hi Community!

We're pleased to officially welcome @Kurro Lopez as a first moderator of InterSystems Spanish Community!

Let's greet Francisco with big applause and take a closer look at his bio!

I have a problem connecting IRIS to Atelier Webapplication.

IRIS Version: IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2019.1.1 (Build 609U) Thu Sep 12 2019 22:40:26 EDT

 When I try to access Atelier API  ( i.e. Webbrowser ) then I can not authorize.

Here is what it looks like:

URL: http://localhost:52773/api/atelier

I put in the valid credentials of a user with a %Developer Role but I am not able to authorize.

The api/atelier web application is enabled in the Management Portal.

I have this bevhavior only with the ReadHat Community Unix version of IRIS.

Has the Cache install been replaced with IRIS? Sorry if this is a silly question. I remember downloading Cache before and using Cache studio. I can't seem to find a download for that anymore, just IRIS? I did grab that and I'm able to connect Studio to what I need.

If there is still a Cache download, where can I find it?

Thanks!

Hi guys,

Great news for all Spanish-speaking community users! 

Finally, we launched new challenges on Global Masters and now you can collect points for contribution to the Developer Community in Spanish!

What's more? You will earn double points for making posts, comments and translations on DC in Spanish!

Please check the details below.

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.

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.

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": "...",

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.

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".

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.

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.

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.

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.

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.

¡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.

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.