We’re looking for Python developers to participate in our Embedded Python Early Access Program!  If you (or someone you know) are a Python developer and are interested, please contact us via the email address below.

InterSystems is bringing the power and simplicity of Python to IRIS.  We’re hard at work integrating Python directly into the IRIS kernel, making it a full peer to ObjectScript.

I have created a custom role in IRIS for users to provide limited view-only access for querying tables in the HSANALYTICS namespace. WinSQL has been installed on a Windows server (WinSQL Lite version 14.0.244.784) and an ODBC connection entry has been created in WinSQL for the users to log in and run SQL queries. The custom role provides the roles/resources included in the attached file. The WinSQL System DSN entry defined is:

Health Insight UAT HSANALYTICS    64-bit    InterSystems ODBC35

The ODBC35 driver is defined as:

InterSystems ODBC35    2018.01.00.184    CACHEODBC3564.

Hi developers!

We are glad to share what we have new in June Open Exchange release:

• Change Download button name
• New submissions flow
• New way to upload logo

Hi,

I have a DR member and in this cache server the database "cachetemp" start to getting bigger without any reason (50GB that was all the free disk space we have)

In the members of the mirrors the cachetemp its ok and the size is 31MB.

I restarted the server because I read that the cachetemp database purge when restarting, but didnt happend.

Any recommendation to clean this database? can I just deleate the CACHE.DAT from this database?

Thanks!!!

Hi

While configuring FHIR Server I could not find "Health > FHIR Configuration > Server Configuration" option. I am using InterSystems IRIS community edition on my local PC.

Thanks

Hi everyone, 

I am talking from Brazil and we have one very important customer that requested our support to find a consultant, deeply specialized in Cache that could work with us attending this customer. It has a tons of data and its core application is based on Cache.

If you are interested send me an email with the subject title - Cache consultant opportunity - and we will make contact with you. The main request is how strong are your skills in cache and it would be considered a differentiator if you are a portuguese speaker.

Regards - Helberth Cavalcante.

Hi

I have had customers who would rather use a backup application rather than using IRIS Backups. In my experience, I have tried a number of free backup tools and I have paid for at least two "very good Backup Tools" and all of them have failed to create usable backups especially if my Ensemble/IRIS Instances are still running and even if Ensemble/IRIS have been shut down I have found that the backups created by these tools have around an 80% chance of being able to restore a system (let's assume that I am not trying to backup core Windows elements like the Registry and Windows system files).

Error:$ZERROR: <ZSG>%Save+5^GL.Account.1

Does anyone know what this error means?

Hi colleagues!

Is there a way to export globals in XML if I have the access to Management Portal or any other web app?

Currently, it gives the option to export into gof format only.

Hi,

I have the requirement to dump large result sets into files. I am currently using %SQL.Statement and the result set created by it.

The DisplayFormatted is used to write a CSV. The query I used to test does not contain any filters, it is just a select * from a table with 16 million rows.
The file created is 2GB in size. The issue I have is that it takes 8 hours to create this file.

I have seen in the past that file streams write fast at the start. As the file continues to grow, the process' memory usage increases until it reaches the max allowed.

Hi folks!

Here is how I grant SQL access of user to a particular class/table:

GRANT SELECT, UPDATE ON Packacge_X.Table_Y TO UserZ

How can I grant SQL access of a certain user to a whole schema?

Hello,

I need to create a dialogbox  on my zenpage to confirm a Delete operation. 

I tried using below code on in a my client side method but its creating a blank dialog box.

zenLaunchPopupWindow('%ZEN.Dialog.confirmationDialog.cls','confirmationDialog','resizable,width=380,height=180');

Is there a way i can create a Dialog box with text "Do you want to delete" and two buttons "Yes" and "No" and store the response in the calling client/server method.

Thanks,

Jimmy Christian.

Hello Respected members,

I am new with InterSystems IRIS , want to setup the environment on RHEL 7.5 with multiple lun layouts (separate LVM for DB , Journal, and WIJ), 

I would like to get some help in setting up the same, as far as I know, the installation will go through on a single directory ( I did not see any option to chose path/directory for DB's or WIJ /journals), hence after installation I would like to move my DB's to separate LVM and WIJ on another LVM set

Please suggest or share the steps for the  same document if any for the same, that will be really helpful, Thanks

Regards

RS

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Automating InterSystems IRIS Instances Configuration

We’ve published an update to the Serenji debug extension for Visual Studio Code, making it ready for the Workplace Trust feature in VS Code 1.57.

This allows the Serenji ObjectScript editor to work without restrictions across all workspaces and, by bringing it in line with the VS Code update, only allows the debugging feature to be used in trusted workspaces.

Hi Developers, 

It's time to announce the Winners for May 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in May 2021:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈  @Guilherme Koerber, Programmer, Bplus Tecnologia, Brazil

Learn more about the competition and our awesome winners below.

Hi all, I am new to IS Objectscript and I would appreciate some assistance regarding this. 

I am trying to find out how to count the number of elements within a dynamic abstract object and I am having some trouble using the size method.

Here is the code below:

The key value pairs are originally in JSON and I would have converted it in to an object for use.

Class JSON.

Hi Developers, 

We invite you to take a few minutes and leave a review about your experience with InterSystems IRIS on the TrustRadius. Submitting a review requires time and effort, so we'll be glad to reward you with a $25 VISA Gift Card for a published review!  
UPDATE: this promotion ended in 2021. 

Hello, first of all thanks for your time reading this question and thank you for your replies

We would need some help

We are trying to create a function to generate a random number with always 4 digits

We have already read the following topics:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

https://community.intersystems.com/post/how-generate-random-string-fixe…

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…

How would you recommend to write a function to handle this use case?

Getting this error:

ERROR <Ens>ErrFTPPutFailed: FTP: Failed to Put file 'TestsDaily.xlsx.xlsx' 
(msg='Error in SFTP Put('\\Reporting\reports\Daily-Weekly\TestsDaily\To Be Processed\TestsDaily.xlsx','/TestsDaily.xlsx.xlsx') 
ERROR #7500: SSH Put Error '-2147024894': The system cannot find the file specified. [80070002]',code=0)

is this due to the file extension? Also, if its just because the file isn't there, how to fix that? 

Hi Guys,

I'm wondering how can I get fields defined as %GlobalCharacterStream diplayed in a SQL query or even objects?

I've some data that I need to convert over to a new system and the old uses %GlobalCharacterStream data type for one of its fields and I''m unable to display or extract to a spreadsheet, any help pls?

thanks

Some key points are emphasized in this article in order to save your time to get linux ldap client in cache working with windows AD (active directory) LDAP server. The first thing to do is to get successful TLS connection to windows AD. Raw tcp case is beyond of this article, there is no problem with it, it is trivial. Windows ldap server uses port 636 for tls and this port can be used to get ldap certificate. As we will see later there is reason for this. linux ldap client uses STARTTLS special ldap extension to switch plain tcp to TLS only.
Hence, connection should use port 389.

I'm looking for a way to get the message header ID for the current message in a Request to a Business Process.

I've located some code that gives me what I need, but it runs the risk of violating the "abstraction layer" ISC has in place around such things. And while I very much appreciate their efforts at keeping things simple for me ... well, sometimes you just have to dig through the guts to get what you want.

Is there a documented, deprecation-resistant method for getting at %Ensemble("%Process").%PrimaryRequestHeader.%Id() from within a  BP?

Gartner defined DataOps as: "A collaborative data management practice focused on improving the communication, integration and automation of data flows between data managers and data consumers across an organization. The goal of DataOps is to deliver value faster by creating predictable delivery and change management of data, data models and related artifacts. DataOps uses technology to automate the design, deployment and management of data delivery with appropriate levels of governance, and it uses metadata to improve the usability and value of data in a dynamic environment.

A concurrent session in IRIS:
SQL, Objects, REST, and GraphQL
 

Kazimir Malevich, "Athletes" (1932)
 

"But of course you don't understand! How can a person who has always traveled in a horse-drawn carriage understand the feelings and impressions of the express traveler or the pilot in the air?"

Kazimir Malevich (1916)

Introduction

We’ve already addressed the topic of why object/type representation is superior to SQL for implementing subject area models. And those conclusions and facts are as true now as they have ever been. So why should we take a step back and discuss technologies that drag abstractions back to the global level, where they had been in the pre-object and pre-type era? Why should we encourage the use of spaghetti code, which results in bugs that are hard to track down, and which relies only on virtuoso developer skills? 

There are several arguments in favor of transmitting data via SQL/REST/GraphQL-based APIs as opposed to representing them as types/objects:

Hi Community,

Please welcome the new video from #VSummit20:

⏯ Special Sauce: InterSystems IRIS Overview

Is there a call in ZEN to FOP to combine (merge) separate PDF documents into one?

Or does anyone know of a Windows server program that could be called from Cache to do this.

Thank you in advance.

Hi,

is it possible to avoid the display of certain properties in a custom message class in the message viewer content section. The message class is a common Ens.Request with a bunch of properties alongside one property of Type enslib.dicom.document wich in Turn is Not extended By %XML.Adaptor so the content display of course displays an error. 

My idea is to avoid the display of That certain property When output is rendered (Text/XML). Using Ens.Util.MessageBodyMethods and method %OnShowContents could be a way to do this But i don‘t find a way to do so.

We are pleased to announce that now you can choose the preferred language of the Global Masters program! Available languages: English, Spanish, Portuguese, Japanese, Chinese.

Choose the language in your profile settings:

Hey Developers,

The InterSystems FHIR Accelerator contest is over. And now it's time to announce the winners! 

Are you excited?

A storm of applause goes to these developers and their applications: