Hey Developers,

This week is a voting week for the InterSystems Developer Tools programming contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote and what's new?

I am new to Cache, we are trying to move a 4 TB database over the internet, but this will be take too long to copy the single backup file. In Oracle and MS-SQL Server there is an option of doing log shipping. Is there such an option in Cache?

I want to copy the initial backup file one weekend, then keep sending the Journals (logs) the new location.

Thank you,

Eudoro

In addition to IntelliJ IDEA, it's now possible to configure SublimeText3 to be able to compile code there too. And what you will need is just the language server I did.

Hi Community,

See how the new embedded Python feature enables you to write user-defined SQL functions and stored procedures in Python:

⏯ Embedding Python in SQL: Write Your Stored Procedures in Python

Hi,

I have a requirement to convert few screens having character based interface built in Cache to a web based interface in Java while still keeping Cache as the backend which means database will remain the same. Wanted to know if we have any tool in the market which can help doing that keeping in consideration that these screens in cache are using mumps code. 

If we don't have any tool, would appreciate if someone shares their experience in the manual conversion as well.

Let me introduce the support of InterSystems IRIS in IntelliJ IDEA. This plugin adds Syntax Highlighting support for ObjectScript, and auto import and compile on the server after saving a changed file. It uses LanguageServer written in Rust, where was added an ability to import and compile code.

NigelTSalm — Today at 23:45

Hi, I am loading zpm for the first time.

Hi,

we have a EnsLib.Workflow.TaskRequest wich is been send to an operation. The Task request contains a simple object, for that we´ve extendd EnsLib.Workflow.TaskRequest and added the object as an aditional property. The request is successfully created. But how to access the contents of this object from within the user portal when showing the task.

Our TaskRequest contains an object named Patient with some properties.

Is it possible execute create table from management portal?

I tried this:

CREATE TABLE SQLUser.Teste(ID INT NOT NULL,  coluna1 VARCHAR(255),  coluna2 VARCHAR(255),  coluna3 VARCHAR(255),  coluna4 VARCHAR(255)CONSTRAINT TestePK PRIMARY KEY (ID))

Error message:

Hi Everyone,

In the previous article, we combine ZPM with Config-API to load a configuration on module loading\install.
It could be useful for small applications, but for a large application, it's not convenient.

You can need to create multiple namespaces and install many zpm modules on different namespaces.
Using the configuration document on zpm load\install is a problem for this special case.
Moreover, even if you need only one module and one namespace, ZPM client is designed to install on the current namespace and it's not possible to switch to another namespace during the install.
So, If

Following instructions on this page https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=D2IMP… I am trying to create a Data Connector to be used as a base class for a cube with update support.
That page suggests that putting an SQL query inside XData block is not suitable for a Data Connector that supports updates.
Later it also suggests that to enable updates your SQL query must include 

WHERE $$$RESTRICT

Providing an example of it in XData block example like this

<sql>SELECT A,B,C FROM MyApp.MyTable WHERE $$$RESTRICT</sql>

Which I already have

Hi Developers!

We had a set of technology bonuses for the InterSystems IRIS Developer Tools contest.

And here is how projects collected it:

Announcing gj :: locate.  A simple extension for VS Code that will help you get to the source of your errors.

In VS Code, using either the Serenji extension or the basic InterSystems objectscript extension, this small add-on will open the appropriate class or routine and position you at the exact line where an error occurred.

No more tedious counting of lines to find <UNDEFINED>zCredit+206^Ledger.Invoice.1.  Instead, with gj :: locate you can get there with just a couple of clicks.

This 20 second video tells it all:

Download now and enjoy getting to the source of your errors.

Hello Everyone,

We are currently in process of implementing REST APIs using IRIS and we are also looking at using Intersystems API Manager. 

Our aim is to implement a Microservices Architechture where Services are small in size,  bounded by contexts, autonomously developed, and independently deployable. 

We are following a spec first approach where we are first defining the API specs into Swagger Hub and using IRIS API Management Service to build the REST classes i.e. the Specification class, Dispatch class and Implementation Class.

Methods in Implementation class invoke a Business service in

Hello developers! I present to you the project of editors in terminal mode. The full-screen editor of routines, arrays and text files in terminal mode can be useful to you when debugging your project in docker or when your web interface is unavailable or limited for some reason. Although this project is self-sufficient, I decided to make it as an addition to the ‘zapm’ module for the convenience of calling editor commands.

If your instance does not have a ZPM, then you can install the zapm-editor module in one line:

set $namespace="%SYS", name="DefaultSSL"

I can run Google Maps within a Zen app via the <ds:mapView> with no issue.

Is there a way to embed google maps in a ZEN PDF report?

An example of code would be most useful.

Thank you

IRIS 里有sha256withrsa加密算法的实现吗？

We are migrating from 2017.1 to Nice New Iris. Data conversion is fine. However, we would like to do a "global" Enable="false" on all the production's services and operations. Is this possible? Working through the operations and services will be tedious! Any code that can do this would be a great help.

Thanks

Please how can I schedule a call with InterSystems admin? We have a need  to back up our cache DB  server in azure using recovery services vault/snapshot. We Have come up with several designs but we need expert advice from InterSystems’ s team or anybody here in the community. I have been asked to contact  an InterSystems admin for support but I don't know how to schedule a meetings since they don't have teams presence with our company.

I want to convert the image to base64.

I have only a remote image URL.

please suggest the solution with allow cors origin.

There will be serious errors and garbled code when I use the Data Migration to connect to MySQL through JAVA gateway. In fact , there are always many problems when I import data to the Caché database.

Hello,

I'm using $ZF(-1) in a class method which will be invoked from a csp page.

What determines the environment of the spawned process?  If I use $ZF(-1,"echo hello world > output.txt"), the resulting file is owned by cacheusr:cacheusr.  However, when I use $ZF(-1,"printenv > output.txt"), the environment is from my personal unix account, no matter which Cache username I'm logged in under when running the web application.  

Thanks

How to I use ..CurrentDateTime() so it returns in format YYYY-MM-DDTHH:MM:SS+ and in eastern time?  Need code to be in DTL, not in ObjectScript.

Hi Community,

I am trying to access another process's content of objects like %request and %session. I am using the class/method "%SYS.ProcessQuery:VariableByPid". Does anyone knows how to get the value of the properties like %request.Data("ID",1)  from one process that is running on the DB server?

Example of what I am trying to do:

        set rs=##class(%ResultSet).%New("%SYS.ProcessQuery:VariableByPid")
        set tsc=rs.Execute(ProcessID,"%request")
        while rs.%Next() { 
            w "Name:"_$g(rs.Data("Name")),!
             w "Value:"_$g(rs.Data("Value")),!
        }
        do rs.Close()

Today we have only 'Snippets' to classes:

how i can custom this Snippets to show my labels or variables of atual routine?

gj :: connect is a demonstration extension that shows how to extend the Intersystems Server Manager to perform custom actions.

It makes use of the context menu contribution points to add both in-line and right click menu options.

It also demonstrates how to create a new top level folder in your workspace corresponding to the server and namespace selected in Server Manager.

Features

• Add in-line command to each namespace folder
• Add right-click context menu to each namespace folder
• Demonstrates use of getServerSpec api to read and use connection properties
• Demonstrates how to launch a url in an

You may think it isn’t too difficult to get from label+offset^routine to the actual source line responsible for the error.  For an expert it isn't that hard... most of the time.  But there are enough oddities and special rules that even an expert can get it wrong, whilst spending a lot of time trying to get there.

gj :: locate is the latest tool from George James Software – it debugs any error, class or routine by converting the location of an error in compiled .int code to the corresponding location in your source, and then taking you right there.

Image this scenario…

Hello,

First of all thanks for your time reading this question,

We would need some help,

The challenge is that our Ensemble does not start.

If we Launch Ensebmle we see:

When we open: C:\InterSystems\HealthShare_2\mgr\cconsole.log

We read:

04/13/21-13:00:29:878 (8084) 3 Error: ERROR #5001: Could not start SuperServer on port 56773, may be in use by another instance - Shutting down the system

When we use: netstat -oan

We observe:

TCP    [::]:56773             [::]:0                 LISTENING       2396

Then we write: tasklist /svc /FI "PID eq 2396"

And we have:

Nombre de imagen               PID

I checked out a Git-Branch and want to Import all Objectscript-Objects to my localhost.

While using Import without Compilation I receive a lot of errors.

request to http://127.0.0.1:57772/api/atelier/v3/TSTCBW/doc/MusLT01LCOD.int?ignore… failed, reason: connect ECONNREFUSED 127.0.0.1:57772

While using Import and Compile I receive much more of this errors.

Is there a setting, that I have to key in?

Or how can I synchronize my namespace to test my changes?

hi,

I have redhat 8.3, after installation Cache and everything looks good , when i stop the DB by  /usr/cachesys/cstop i get :  

Apr 18 16:10:22 opticanan Cache(CACHE)[115418]: Cannot remove database lock /cav/mln/cache.lck: Delete failed
Apr 18 16:10:22 opticanan Cache(CACHE)[115418]: Cannot remove database lock /cav/w/mlnw/cache.lck: Delete failed
Apr 18 16:10:22 opticanan Cache(CACHE)[115418]: Cannot remove database lock /cav/w/mgrw/cache.lck: Delete failed
Apr 18 16:10:27 opticanan Cache(CACHE)[115418]: Unable to open database lock /usr/cachesys/mgr/fdbms/cache.lck to delete it
Apr 18 16:10:27