Question Shri R · Aug 26, 2020

Hi Community,

I am looking some kind of logic or trigger some events when cache process ends.

For example, if I set some X global when i logged into terminal and when I closed the terminal or process ends by its own,  global to be removed.

Thanks in advance!!!.

SR

3
1 239
Question Yann Simons · Jul 2, 2020

Hello,

we use a NAS to archive stream from database to files. If we look at the file size on disk, it is bigger than expected.

For example : 

File size is 127K

ls -alh | grep write-chupmb-pdf
127K 2020-07-02 10:43 write-chupmb-pdf

Size on disk  is 192K

du -sh * | grep write-chupmb-pdf
192K    write-chupmb-pdf

Or expected size is 128K (with 4K blocs)

I tried with %Stream.FileBinary, %FileBinaryStream and OPEN/USE/WRITE and with multiple files and file type (PDF, JPG, PNG) and I have the same problem each time.

For example :

du -sh * | grep write-chupmb-pdf
192K    write-chupmb-pdf
192K
3
0 524
Announcement Olga Zavrazhnova · Aug 25, 2020

Hi Community, 
As you may know, on Global Masters you can redeem a consultation with InterSystems expert on any InterSystems product: InterSystems IRIS, IRIS for Health, Interoperability (Ensemble), IRIS Analytics (DeepSee), Caché, HealthShare.
And we have exciting news for you: now these consultations available in the following languages:  English, Portuguese, Russian, German, French, Italian, Spanish, Japanese, Chinese.  Also! The duration is extended to 1.5 hours for your deep dive into the topic.
 

0
0 230
Question Ba Moser · Aug 23, 2020

I try to compare classic JOIN against implicit JOIN.

It is a simple case. But I am surprised.

The class:
Class Sample.Person1 Extends (%Persistent, %Populate)
{  Property Name As %String;
Property Home As Sample.Address;
Property AR As array Of Sample.Address; }

Query #1 - classic:
select name,home_state,a.* from sample.person1 p
join sample.person1_AR a on p.Id=a.person1
and home_state=AR_state

Query #2 - implicit
select person1->name,person1->home_state,*
from sample.person1_AR where person1->home_state=AR_state

for both I have the same query plan:

It is a simple query on  2 or 1 simple  tables.

2
0 271
Article Zhong Li · Aug 23, 2020 15m read

Keywords:  IRIS, IntegratedML, Machine Learning, Covid-19, Kaggle 

Continued from the previous Part I ... In part I, we walked through traditional ML approaches on this Covid-19 dataset on Kaggle. 

In this Part II, let's run the same data & task, in its simplest possible form, through IRIS integratedML which  is a nice & sleek SQL interface for backend AutoML options. It uses the same environment. 

IntegratedML Approach?

How to load data into IRIS

integredML-demo-template defined various ways to load data into IRIS.

0
0 608
Article Yuri Marx · Aug 22, 2020 1m read

Some clients ask me about migrate from Cache to IRIS. Why migrate to IRIS? Cache is excellent, stable, has good performance. These clients are right, but in the last years, the digital transformation imposed more complete solutions for the new requirements and InterSystems was a visionary to perceive it and launch IRIS.
It is a data platform ready to this digital transformation challenge. To show this, I created a Value Canvas.

Value canvas are a perfect tool to show in a few minutes the value of the change.
If you want create new value canvas to this topic or any topic, download PPT version

0
3 655
Question Muni Ganesh · Aug 1, 2020

Hi,

We are using CACHE 2017.2.1, I would like to retrieve data from Journal for killed global. Let say we have global name ^ EMP(123) with data and also have some child nodes and it has been killed by using cache kill command for some reason and we don't know who has executed this and when. My questions are below.

1) Can we get back the data of killed global from journal files,Is it possible or not ?

2) If above question is Yes, then how to find that specific journal file, which has the global which has been killed?.

5
0 803
Question Paras Batheja · Aug 17, 2020

Hi Developers 

Is there any way that we can pass the values to the read prompts via cache routine.

For example, we have a couple of reports/routine in our system which accepts some inputs and after taking the inputs it generates some data. Right now it has proper UI and where User enters the value and in routines we have Read statements which accepts those inputs for further processing.

Now we want to schedule all these reports on a task manager on cache and don't want to modify the existing routines  so wanted to check is there any way to pass the values to those "Read statement" via cache

7
0 640
Question Yone Moreno · Aug 18, 2020

Hello,

We would need to handle the following use case:

A system replies to our GET with a list of codes and a signature.

Each code has been signed with the SHA512withECDSA algorithm

We would need to:

1 Concatenate all codes in a string

2 Decode the string which is in Base 64

3 Validate the string using the signature which we get in the reply

We have read for step 2:

Base64Decode

https://cedocs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.c…

For step 3 we have found:

This example at "Validating a Signature" which

1
0 340
Question André Jouval · Aug 20, 2020

Hi,

Do you know if cache has programs and functions cache

I made a backup of my production base and when I use this function abouve I receve an error, but if I change any letter of the command the function go ok.

Didn´t work SELECT $$JOB1^KMIGxDESIG() FROM DUAL

Work sELECT $$JOB1^KMIGxDESIG() FROM DUAL

for this I.m using ODBC 64.

Thanks

1
0 351
Article Daniel Kutac · Aug 21, 2020 3m read

Dynamic PoolSize (DPS) Experiment

Purpose:

Enhance Ensemble or IRIS production so it can dynamically allocate pool size for adapter-based components based on their utilization.

Sometimes, an unexpected traffic volume occurs, and default pool size allocated to production components may become a bottleneck. To avoid such situations, I created a demonstrator project some 2 years ago to see, whether it would be possible and feasible to modify production, so it allowed for dynamically modifying its components per their load.

3
0 622
Question Jabe Hammond · Aug 20, 2020

Does anyone know if I can create an API integration, from Ensemble to Salesforce? What I would like to do is trigger a Salesforce case to be opened when for example a Queue reaches a predefined threshold or an interface connection goes from green to non-green.

1
0 497
Question Daniel Lee · Aug 20, 2020

We are using Ensemble and I added some debug logging that writes to a global and recompiled the class in Studio. However, when we send messages, the global is not populated. I have recompiled, removing the checkmark to keep the generated code so that there is only one .INT file and I verified that the code is present in the .INT file. 

My question is, do we need to stop and restart the Ensemble production in order for these changes to take effect? Do I need to stop and restart the business operation that calls this piece of code? Is there something else I may have missed?

Below is the code

6
0 416
Announcement Anastasia Dyubaylo · Aug 5, 2020

Hey Community,

We're pleased to invite you to the first webinar dedicated to our Global Masters Advocate Hub! Please join:

➡️ InterSystems Global Masters Advocate Hub Overview webinar ⬅️

Date & Time: Friday, August 14 – 10:00 EDT

 

Let's see the Global Masters Advocate Hub from the inside and talk about how you can benefit from participation in this program. We'll go through:

2
0 395
Question Yakov Berger · Aug 19, 2020

Hi,

I have some SQL querys i would like to run using an Outbound SQL Adapter  and save the returned rowsets in excel format (each rowset in a seperate excel file).

What is the best way to do this?

Thanks

4
0 436
Announcement Benjamin De Boe · Aug 20, 2020

Hi,

As part of our continuous efforts to expand and improve the InterSystems IRIS Data Platform, we’ve set up a brief survey around SQL monitoring. Your feedback will help us in designing and developing the right tools for the job and improve the platform’s overall ease-of-use. Please use the link below to access the survey, which should only take around 5 minutes to complete.

0
0 255
Announcement Anastasia Dyubaylo · Aug 17, 2020

Hi Community!

We are pleased to invite you to the upcoming webcast in Portuguese on August 20 at 11:00 BRT:

✅ Digital Government: Architectures and Solutions

On this webcast, InterSystems Solutions Consultant @Yuri Marx will help us understand how the 3 powers at federal, state and municipal levels are seeking the digitalization of public services.

1
0 221
Question Anna Golitsyna · Aug 19, 2020

Hi,

I'd like to compare classes in two namespaces, whether the corresponding .cls code exist in both namespaces or not, and if it does exist in both namespaces, whether the CLS code is identical. If there is such a routine out there the better, I'd like to see it. If not, I know how to get a list of classes in each namespace and I can check currClss.TimeChanged. What I cannot find is the following:

  1. Programmatic access to cls routine  code lines given the class name
  2. cls routine code size in bites as a crude approximation of cls files in two namespaces being different
  3. Can I compare classes or
8
0 593
Question Karthikeyan G · Jul 23, 2020

Hi ,

I tried to import Custom schema with 'Z' segment. I executed "Do ##class(EnsLib.InteropTools.HL7.MessageAnalyzer).Interactive()" in IRIS Terminal.

After executed the steps, i am getting below message, So i could not able to add z segment into my customschema 'Test_2.3'
------------------------------------------------------------------------------------------------
Summary Report for workspace C:\Demo\Migration\Workspace
Schema is Test_2.3
 ALL: 0 matched, 1 unmatched

---------------------------------------------------------------------------------------------------

Anyone help me to resolve this.

1
0 239
Question Mark O'Reilly · Aug 5, 2020

Hi:

I have an sql outbound adapter. Sometimes we have trouble connecting to the database. 

The timeout in develpment is set to 15 seconds in live it is 150 seconds as it is an always connected Buisness operation. 

I thought adding E=S or/and X=S would suspend the message. Why does it not? 

Is the only way around then adding something to the buisness operation itself/ creating a customised SQL buisness operation rather than EnsLib.SQL.OutboundAdapter?

Thanks 

Mark

5
0 579
Question Oliver Wilms · Jun 3, 2020

Hello,

I work on deploying IRIS inside Docker container. I really like %Installer class can automate many steps. I want to establish an ECP connection to a mirror database and then define a remote database on the application server. I have already seen we can create local database and namespace in %Installer. What code is needed to establish ECP connection?

6
0 742
Article Eduard Lebedyuk · Feb 11, 2020 6m read

Asymmetric cryptography is a cryptographic system that uses pairs of keys: public keys which may be disseminated widely, and private keys which are known only to the owner. The generation of such keys depends on cryptographic algorithms based on mathematical problems to produce one-way functions. Effective security only requires keeping the private key private; the public key can be openly distributed without compromising security.

In such a system, any person can encrypt a message using the receiver's public key, but that encrypted message can only be decrypted with the receiver's private key.

Robust authentication is also possible. A sender can combine a message with a private key to create a short digital signature on the message. Anyone with the sender's corresponding public key can combine the same message and the supposed digital signature associated with it to verify whether the signature was valid, i.e. made by the owner of the corresponding private key. (C) Wikipedia.

2
0 902
Announcement Anastasia Dyubaylo · Aug 18, 2020

Hey Developers!

InterSystems IRIS for Health™ includes several features that aid in healthcare interoperability including routing, support for standard data formats such as HL7v2, FHIR, CDA, a data transformation user interface, and easy integration with other systems such as for terminology services.

Enjoy watching the new video on InterSystems Developers YouTube for more:

⏯ Interoperability for Health Overview

 

0
0 224