Hi Community,

This week we have two new videos from Global Summit 2019. Please welcome:

1.   An ML Toolkit for InterSystems IRIS: Co-Innovation in Healthcare

This is a basic JavaScript Vue.js example how you can use REST calls using plain HTML.

Good day,

We upload images into the database with this code :

<tr>
<td align="right">FileName</td>
<td><input type=file size=200 name=FileStream></td>
</tr>

s FullFilename = %request.Get("FileName")
s FileName = ##class(%File).GetFilename(FullFilename)
s ItemImage.FileName = FileName

s ItemImage.fileSize = %request.MimeData("FileStream",1).Size
d ItemImage.Image.CopyFrom(%request.MimeData("FileStream",1))

The need is now to be able to copy a document (example as attached in an email) and paste to be saved into the  ItemImage.Image
%GlobalBinaryStream

Has anyone done something like this ?

Thanks

André

Hi,

   I've heard from two different sources the SMP (or parts of it) and for sure the DTL front end (in studio? via SMP?) have been rewritten to be more modern.  But on a latest IRIS Community download everything looks the same to me.  Am I missing something or is this Marketting Spin?

  ^{Hopefully I won't get banned for this post aswell......}

Olá pessoal,

Compartilho material de um curso desenvolvido por mim, espero que possa ajudar a comunidade.

English:

Hi folks,

I share material from a course developed by me, I hope it can help the community. The material is in Portuguese.
 

Link: https://www.linkedin.com/posts/cristianojs_material-te%C3%B3rico-activity-6608421528906285056-sr8E

I am generating the DDL from a modeling tool - ERStudio. But the DDL has 2 issues right now.

DROP TABLE schema_name.<Table_Name> CASCADE CONSTRAINTS; The Constraints is not supported but works with the statement - DROP TABLE Study_Definition.EVENT_STORE CASCADE;

Second if there is no object to drop, it throws an error, so is there a check like in sql server If_Exists that we can use in CacheDB?

For simplicity sake let's say that we talk about active production.

I need to know if the business host is added to the production or not.

Currently I have:

do ##class(Ens.Director).IsItemEnabled("HostName", .sc)
set defined = $$$ISOK(sc)

Which looks like a workaround.

Hello,

I've got a table with many attributes and data. There is 10 000 000 registrations approximatly.

I need to make a research on this table with filters, paging,  and order.

You can see an example of my  SQL request : 

SELECT * FROM ( SELECT TOP ALL  * FROM ANCV_Data.Titre WHERE etatTitre = 'Emis' ORDER BY numRemise desc) v WHERE %vid BETWEEN 1 AND 25

Cause there are many data on my table, my SQL req is  too long if I don't have index on my attributes BUT there are many associations possible...

Are they any solutions ?

Regards,

I have the following class: 

Class temp.test7 [ Owner = {PHOENIXDBUSER} ]{ClassMethod GetTenAssets() As %Status [ ReturnResultsets, SqlProc ]{s sc=$$$OKs sql="SELECT TOP 10 * FROM Data_Assets.Asset"s sqlStatement=##class(%SQL.Statement).%New()s sc=sqlStatement.%Prepare(sql)if $$$ISOK(sc) {s result=sqlStatement.%Execute()d %sqlcontext.AddResultSet(result)s %sqlcontext.%SQLCODE=result.%SQLCODEs %sqlcontext.%ROWCOUNT=result.%ROWCOUNTs %sqlcontext.%Message=result.%Message} else {s %sqlcontext.%SQLCODE=-460,%sqlcontext.%Message=##class(%SYSTEM.Status).GetErrorText(sc

Hi Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in November 2019:

Hi Community,

New session recording from Global Summit 2019 is available on InterSystems Developers YouTube Channel:

⏯ The Data Management and Analytics Landscape

Want to see how IRIS can be used in a radically-new way, as a JavaScript-based Multi-model database?

Take a look at QEWD-JSdb: https://github.com/robtweed/qewd-jsdb

Full instructions on how to try it out on the AWS IRIS Community Edition are included in the repository.

Hi,

What is the best practice when adding FHIR extension to Patient resource? To not to lose it when updating Patient base class etc.

Krystian

I am writing an API that sends over a very large JSON object. 

The code I'm using to get the data is actually used in our production system today for the use of writing a report.

However when I call the code using the API (using SoapUI) I am getting 'Error getting response; java.net.SocketTimeoutException: Read timed out'

The web applications settings have a session timeout setting at 15 minutes, but this is timing out within just a few minutes, so I know it's not hitting this mark.

Has anyone experienced this issue with APIs?

This post provides further detail on the suggestions from the DeepSee Troubleshooting Guide about what to do if a user is not able to view a listing in a DeepSee cube, but instead sees errors like this:

ERROR #5540: SQLCODE: -99 Message: User <username> is not privileged for the operation [zfindStatement+118^%SQL.DynamicStatement.1:<namespace>] (8)

Hello,

I have a couple of IOT devices that communicate via WebSockets to our backend.

I successfully managed to create a websocket connection between server and (iot)client using %CSP.WebSocket
However I would like to implement authentication on this using the HTTP headers at the same time of Connection: Upgrade.

I tried to set the headers to globals in order to debug but they are always empty.

Example code: 

Method OnPreServer() As %Status
{
Try {
    s ^Header("HTTP_AUTHORIZATION")=%request.GetCgiEnv("HTTP_AUTHORIZATION")
    s ^Header("AUTHORIZATION")=%request.GetCgiEnv("AUTHORIZATION")

A quick start guide to connect Ensemble to RabbitMQ using the RabbitMQ Java Client, a Java proxy class and the Ensemble Java Gateway.

Word and PDF documentation, source code and utilities available at https://github.com/toncat/ensemble2rabbitmq.

#Software Versions Server

• Windows Server 2012 R2 x64
• Erlang OTP 19.1
• RabbitMQ Server 3.6.5
• RabbitMQ Java Client 3.6.5

Client

• Windows Server 2012 R2 x64
• Java JDK SE 8u111
• RabbitMQ Java Client 3.6.5
• Ensemble 2016.2.0.736.0

#RabbitMQ

##Install Server http://www.rabbitmq.com/install-windows.html

Download and run the Erlang Windows Binary File

Download and

Hi folks,

how do people run iris-community edition nowadays? It seems there are some incantations needed that are not documented here: https://hub.docker.com/_/intersystems-iris-data-platform/plans/222f869e-567c-4928-b572-eb6a29706fbd?tab=instructions

When I follow these, I am only getting an error:

[WARNING] No init process detected!

I want to add ports 9100 and 9101 in addition to 52773. I read on docker container documentation that this is not possible on a already ran image. Currently it starts the google cloud IRIS health container automatically without me able to specify the additional ports. How can I add ports to Google cloud IRIS Health container?

Hi Developers!

For those who want to participate in the Advent of Code 2019 and code with ObjectScript in IRIS, I created a very simple but handy Github Template.

Use the green button

to copy template in your own repo, clone the repo and run in the repo folder:

docker-compose up -d

you will get InterSystems IRIS 2019.4 Community Edition running with the template classes to load input data from files and Day1 solution.

This is also set up to start crafting solutions of Advent of Code 2019 and edit, compile and debug ObjectScript with VSCode addon.

Happy coding with Advent of Code 2019!

BridgeWorks is pleased to announce a VDM, v9.1.0.1.  This release includes the following updates:

Updates

• Historical Linking is now based off connection profile name
• Saved Formatting is now based off connection profile name
• Tables and Fields column headers no longer hide based on connection type

Bug Fixes

• Cross tab would not load data correctly in Finished Reports Viewer if it was in a report footer
• Fixed an issue where refreshing logs would not work correctly after viewing a SQL statement
• Views were not visible for available schemas on the connection wizard

New

• Load Selected

Hi all...

I am try to execute a class method from JDBC connection. My method are simple, just create a file at $HOME  like this:

set sc='$zf(-1,"touch $HOME/lixo.txt > /var/tmp/log666 2>&1")

I put a log file to this commnad because it's don't work, and in log file i get this:

touch: cannot touch ‘/root/lixo.txt’: Permission denied

after to try other commands I found that user and enviromnent  variables are diferents:
I try this:

set sc='$zf(-1,"echo $USER > /var/tmp/log666 2>&1") ;Return root

set sc='$zf(-1,"echo $HOME > /var/tmp/log666 2>&1") ;return /root

set sc='$zf(-1,"whoami > /var/tmp/log666

I'm pleased to announce the latest version of the renewed for ObjectScript, which is now available with a lot of new features.

This new extension is a fork of previously developed extension in different repository originally started by @Oleg.Dmitrovich9110.

Having developed systems using Caché ObjectScript and Ensemble on various projects over the last 4 - 5 years I'm considering trying for some certifications. I've found details of the Caché Systems Administrator and Caché Application Developer certifications but have a couple of questions:

1) Is there a certification for Ensemble Application Developer?

2) Are any sample questions and/or practice exams available?

Thanks

Hi Team,
             If any possible to  add a rewards list of InterSystems cache certification to InterSystems Global Masters. For example ,developer or global master user have 10000 point as , we give any offer(price) to attend the InterSystems cache/Ensemble/IRIS certificate. So no.of developer try to attend the exam and get certification.This is very useful for developer career and we also have lot of Cache developers in the market. Please correct me, if I am wrong..

Thanks ,
Ponnumani Gurusamy.

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. 

When I try the same with a Windows

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.