#InterSystems IRIS

I have a requirement which comes down to evaluating two fields, if they are both empty then provide a default value.

If one is empty but the other has a value, then set the empty one to the field with a value.

The screenshots are not the actual fields, I was just using the dtl and fields to prove out the solution.

When I saved and compiled in the Management Portal I got an error, but it still compiled.

I then went to studio and opened the dtl, using view-->other code then compiled and did not get the error.

Wondering if this is a true error or just an anomaly?

Hi, 

I'm trying to connect to IRIS with .NET 4.5 and I see is quite different from Cache Method.

I have a connection and I can invoke a Method but I can't get %Stream.GlobalCharacter value as Class property and I can't use it in a ByRef parameter. With Cache we had the Intersystems.Data.CacheTypes namespace to use this "special" types. 

Is there any documentation to use the %Stream.GlobalCharacter as class property and ByRef Param?

Thanks!

Hey Community, 

Get ready for the next French Stream on InterSystems Technologies!

The new monthly event hosted by @Guillaume Rongier for French-speaking developers familiar with InterSystems technologies will be live stream October 7th at 12:00 Paris time. You will discover all the news and tips related to our solutions!

👉 Direct link to join: https://youtu.be/Rbp-u-3vY-8

On the Agenda:

Hello,

I'm experiencing a recurrent problem that I haven't found the way to solve, so I'm coming here with the hope somebody can give me a new approach.

To make it short: we are creating categories on-demand to be able to place the maximum numbers of workers in memory, avoiding the limits established by system categories. But from time to time, one of this creation fails and system is no able to start the queue. The error we are getting is:

ERREUR #7823: Invalid work queue manager category supplied 'User.65733'.1<INVALID OREF> 

The code is very simple:

s ^%SYS("WQM","MaxActiveWorkers","User.

Hi developers, 

Serenji 3.2.0, the latest version from George James Software, was released last week and our current users have been enjoying trying out the new features (which you can find more about here). 

If you're thinking about trying Serenji for the first time, we've made it easier to get set up by adding a walkthrough on the VS Code Welcome page. It takes you through: 

• Setting up the server components.
• Selecting a server namespace.
• Saving and extending your workspace.
• Requesting a debug license (don't forget we offer a free 30 day trial!) 

We've also added prompts and guidance throughout VS Code to open and add Serenji folders to your workspace and when going to run and debug code. 

This is just one of the ways we've enhanced the Serenji debugger to make straightforward and easy to use - so all you need to do is focus on your code. 

I want to restore to a certain point in time through the Journal log, and I can't find relevant information in the help documentation.  Can someone help me?   

very thankful 

Starting installation
Starting up InterSystems IRIS for loading...
../bin/irisinstall -s . -B -c c -C /usr/irissys/iris.cpf*IRIS -W 1 -g2 
Starting Control Process
Unable to allocate 242 MB shared memory...
Unable to allocate 232 MB shared memory...
Configuring minimum system...
Unable to allocate 139 MB shared memory...
Unable to allocate shared memory minimum of 139MB (errno=22)
Startup aborted.
Startup error. See messages.log for more information.
Call InterSystems Technical Support if you need assistance.
IRIS startup returned 1.
InterSystems IRIS failed to start.
Check

Hi!

We're doing a small data integration project at our university and I've run into a problem.

I'm trying to make a counter that records the amount of messages (a simple .txt file transfer) that pass through a process and dumps that amount into a text file (preferably with a timestamp) every 10 minutes or so.

What I've gathered it's possible to do it via SQL query but linking that query into a process is something I haven't found any info on.

Are there any semi-beginner friendly ways to do this?

Thanks in advance!

Hi Team,

I want to consume(call) third-party API by passing JSON as a request from Iris.

is there a command line  function I can use to export the user file.  The names off all the  user in Health Share or Health Connect.  Export it into some type of flat file?

I'm trying to install IRIS 2021.1 in the Ubuntu 18.04 but all the time I got the message below:

Starting installation
Starting up InterSystems IRIS for loading...
Invalid ownership for ./irisdb
InterSystems IRIS is already up!
Status code is 1
InterSystems IRIS failed to start.
Check /mnt/WinData/InterSystemsLinux/mgr/messages.log for more details.
Call InterSystems Technical Support if you need assistance.

* Installation aborted *

Post-installation tasks failed, installation is not complete

Has anyone had the same problem?

I tried to install with root as well but the problem persist.

Thank you all.

Benjamin De Boe wrote this great article about Universal Cached Queries, but what the heck is a Universal Cached Query (UCQ) and why should I care about it if I am writing good old embedded SQL?  In Caché and Ensemble, Cached Queries would be generated to resolve xDBC and Dynamic SQL.  Now in InterSystems IRIS embedded SQL has been updated to use Cached Queries, hence the Universal added to the name.  Now any SQL executed on IRIS will be done so from a UCQ class.

Why did InterSystems do this?  Good Question!  The big win here is flexibility in a live environment.

Hello,

We upgrade from CACHE 2016 to IRIS 2021 and when we try to start a production gives the error behind.

I think the error could be that the Ens.Director is deprecated on IRIS 2021, is this possible? 

09/22/21-14:35:35:563 (16501) 1 [Utility.Event] Production AutoStart: ERROR in namespace 'REGINUS': 'ERROR <Ens>ErrException: <CLASS DOES NOT EXIST>zgetProductionItems+29^Ens.Director.1 *%Library.CacheStorage -- logged as '22 Sep 2021' number 1 @''' $ZU(56,2)='$Id: //adhocs-iris/2020.1.0.217.1/ISC_INTERNAL_BASE_20418_001/kernel/common/src/aclass.c#1 $ 9520 0'

The latest release of Serenji by George James Software introduces zero configuration debugging, so it's ready to go in just one click - no matter where you are or what you're doing, your on-the-spot debugger is ready to go. 

We have introduced a host of new features to enhance the debugging experience so you can focus on identifying and fixing errors, without losing focus by spending time setting up a launch configuration. 

Check out the new features in our release notes. 

If you've already started using Serenji 3.2.0 let us know how you're getting on! 

When overwriting the Read method (that has a %CacheString return type) on a new class that inherits %Stream.FileCharacter class, returns an error about incorrect return type, must be Binary, even if it matched the real signature.

Looking at the compile global information we can see:

^oddCOM("%Stream.FileBinary","m","Read",42)="%Library.Binary"

After further investigation we realise that there is a generator method looking at the OdbcType class definition.

Setting LONGVARCHAR results in:

^oddCOM("User.CStream","m","Read",42)="%Library.String"

We found out recently that when compiling an objectscript class that has a java projection, using the -d flag, it ignores it for the projection part:

After talking with intersystems luckily the've provided a solution that will be included in the next release:

i noticed -by reading .INT files of one class- that some of embedded sql select statements code blocks translates into code that uses lock command.

even if i use %nolock in the select, still cursors and arrow referencing notations "->" have the same results.

Hi,

i am trying to run a windows batch file using $ZF(-100)

$ZF(-100,"/ASYNC /LOGCMD","C:\batch_files\ab_bat.bat")

doesn't seem to be working (no error just the batch files contents no executed).

should this work?

Thanks

Hi Community

I have extended my operation class from Ens.BusinessOperation class . I want to execute below sql on cache.

&sql(Select demoVersion into :DemoVersion from demointerface.DemoInstances where ID=:demoID)

this line not even giving error.

Please suggest me how to make sure my sql query should work everytime , when i call the class method

Same code is working fine in production but not working in local:(

Thanks a lot

Prashanth Ponugoti
 

Since I saw many posts on Developer Community related to Python, and the very good articles and application written by @Eduard Lebedyuk I was wondering: "As a Object Script developer, why would I want to use an other  language in Object Script? If I ever need to execute something in Object Script, I would do it in Object Script!".

I thought those functionalities to use other languages in Object Script were made only for other languages developers who have to write Object Script code.

Recently I had to parse a huge CSV file : 1.7Gb and more than 5 millions lines.

InterSystems is pleased to announce a new Developer Download site providing full kit versions of InterSystems IRIS Community Edition and InterSystems IRIS for Health Community Edition.   These are available free of charge for application development use.

You can download directly from the InterSystems Developer Community by selecting Download InterSystems IRIS.

Over the past year or so, my team (Application Services at InterSystems - tasked with building and maintaining many of our internal applications, and providing tools and best practices for other departmental applications) has embarked on a journey toward building Angular/REST-based user interfaces to existing applications originally built using CSP and/or Zen. This has presented an interesting challenge that may be familiar to many of you - building out new REST APIs to existing data models and business logic.

Hello everyone

I am new to cache. I want to know how we can perform database tuning.

Thanks in advance!!

Hello everyone. I am hoping someone here can help me get my local instance running. I have set up these local instances in the past (pre IRIS) and never had much trouble, but I have spent so much time the last couple days trying to work through this problem and am out of ideas. It has been years since I have set up a local instance so this could be something I am doing wrong, but I am open to any suggestions. I am trying to setup a Vista database like I have in the past by creating a new database and namespace named VISTA, have created a folder with the FOIA .

Just wanted to thank InterSystems for sponsoring this year's HACKMIT!

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Getting Up to Speed on InterSystems API Manager

I have an ObjectScript class with a Log property of type %Stream.GlobalCharacter.  I need to search the end of each of the logs - is there a way to extract the last 10 lines of the Log stream for each object via SQL? Or is my only option to write an ObjectScript routine to walk the table and inspect each Log property one by one?

Thanks!

Hello gentlemen,

I hope you can help me because this is a very serious that I can't wait to resolve... Our back-up is currently taking 3 up to 4 Gb per day and we don't know why. We had 270 Gb yesterday and we are today at 274.3 Gb. We keep a computer history of the messages for only 50 days. Here is a picture of what's currently taking the most data place in our healtshare system:

(don't forget that our DB is also connected to the back-up, maybe it is related, I don't know)

Thanks you in advance,

Thomas

Hi community,

Do you have docker automl docker image with zpm?

In the first part we got a quick introduction on the IMAP protocol commands, now it's time to use IRIS and implement them and create our own IMAP client!

IRIS Email Framework

The IRIS platform has default interfaces and classes for working with email. Developers originally designed those artifacts for POP3 implementation. However, this doesn’t mean that we can’t use and extend these interfaces and classes to implement an IMAP client. So let’s talk about them:

• %Net.FetchMailProtocol: This is the base class for email retrieval. The IMAP client extends it.
• %Net.