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

I have the following class: 

Class temp.test7 [ Owner = {PHOENIXDBUSER} ]
{

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.

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 {

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

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:

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

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

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:

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.

You can find a new repository here.

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!

Francisco López de las Heras is a young 46 years-old boy from Málaga (Spain). He never stops learning, very curious with new technologies. In addition, Advocate of year 2017 Spain.

Some words from Francisco:

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

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!

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.

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:

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.

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!

Pinned topics

Important news and posts now could be pinned to the top of the main feed and tags.

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???