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'

Hi Community,

New video is already on InterSystems Developers YouTube:

⏯ Showcasing New X12 Enhancements

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! 

At the top right corner in Clinical Viewer we have a wrench icon with which Administrator is able to change the layouts as and if needed. 

Are there any logs created when anyone modifies the layout and save the layout. 

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:

 #VSummit21

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

I am writing a report for a client that will create a report of the current process with a format that mimicks the Management Portal process display. I am writing a cterm script file to generate the report.

In the loop that process the results I am writing the columns in a formatted manner that will result in a CSV format very similar in content and order the process page. However, it appears that the write statement is limited in size such that I can not write out all of the elements of the sys.process query. My query result processing that works correctly is of this format:

send: WHILE rset.

I'm working on a project were we are going to be receiving a non-HL7 formatted flat file that will contain a single result message per line and each result messages may  contain repeating OBX fields that will need to be parsed out so that can be sent as an HL7 ORU messages that contains multiple OBX segments.

The record map I currently have doesn't appear to be able to parse out the repeating OBX fields in the source file, currently my Record Map uses the “|” as the first field separator and the “^” as the second and the “~” as the repeat separator.

Deploying InterSystems HealthShare code, supporting lookups and artifacts like ssl certs, keys etc is relatively straight forward using Gitlab Runners.  Not only does this approach enable managing the code base and deploying with git type workflows, but it also lends to a speedy recovery and repeatable environments for some implementations.

Hey Developers,

Please welcome the new video by @sween on InterSystems Developers YouTube:

⏯ Hands Off HealthShare Deployment Workflow with GitLab Runners

Gitlab Runners and InterSystems Healthshare Code Deployment and VSCode oh my. More details in this post. 

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
 

Hi All,

I would like to merge json files. From a BPL we're running an operation to get data from a REST service cursors. We would like to run the REST calls until no cursor is present in the response of the rest call.

This works fine, but I would like to combine/merge the json outcome and write it to the disk.

See my attempt below for merging 2 json files.

Class Test.TestClass
{

ClassMethod xxx() As %Status
{
    Set tSc    = $$$OK
    
    set jsonObj1 = {}.%FromJSON("C:\temp\1.json")
    set jsonObj2 = {}.%FromJSON("C:\temp\2.json")
    
    Do jsonObj1.%Remove("NextCursor")
    Do jsonObj2.

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.

Hi Community!

You've possibly noticed ES switcher in articles.

If not - we recently introduced the option to switch to the Spanish version of the article. 

I run most of my reviews using Docker Desktop on Windows 10.
According to the recommendations, I clean up docker and downloaded repositories after tests: 
Repos are simple but Docker is somewhat resistant to release the consumed disk space.

Hey Community,

New video for an easy start on InterSystems Partner Directory:

⏯ How to list a solution on InterSystems Partner Directory

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.

I want to start this project and wants to know the best practices, you guys using to arrange the project. I have done lot of mvc projects and API's in c#. But Intersystems is new to me. Please give me some suggestions like how can I Arrange the objects. Like for eg. Where can I store the productions objects like services,process and operations. will that be like under each resouces folder name? and what are the base classes, and how can I store them? basically please give me some idea about how Can I arrange them . 

Thank you 

Sai

I want to install a new FHIR server from the Management Portal using the below steps, but not able to find FHIR Configuration setting under my newly created foundation namespace. 

1. Open the Management Portal and switch to the Foundation namespace where you want the FHIR server installed. If you do not have a Foundation namespace, go to Health, and select Installer Wizard from the top menu bar. The Configure Foundation button allows you to create a new Foundation namespace. Be sure to activate the namespace after creating it. Done
2. Navigate to Health > MyNamespace > FHIR Configuration.

Hi Everyone! 

During the HackMIT 2021, we have been running an online game for undergraduate students called "Treasure Hunt". Thanks to all who took part in the game!

The Treasure Hunt prizes were raffled today at 10 am ETS on Zoom (see the recording here). Please meet the Raffle Winners! 

🎁   JBL Quantum 300 Gaming Headset goes to A. Kuro Andengattil 🎉

🎁   Apple AirPods Pro goes to Pulkit Girdhar 🎉

🎁   Amazon Echo Dot goes to Joshua Qin 🎉

🎁   Nike Utility Speed Backpack goes to Chua Hua Lun  🎉

🎁  Amazon Kindle 8G Paperwhite goes Samrat Mukherjee 🎉

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 .

The challenges are gone :(

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

Hi,

Business service is not moving .csv to Archive file. is there any setting to missing?

Thanks