If I have an online backup running and a snapshot backup is run whereby a freeze/thaw is done, will the online backup be affected ?

Hi developers!

I have an existing CSP app and I want to add a role to it. How can I make it programmatically?

We are running a restore of a mirrored database on the secondary mirror member via the DBREST restore procedure.

Since it is run from an interactive session, if the session times out or the vpn is severed, the restore is affected..... is there a way to run the restore in a background process instead ?

Hi Community,

We're pleased to invite all the developers to the upcoming InterSystems FHIR Accelerator Contest Kick-Off Webinar! The topic of this webinar is dedicated to the FHIR Accelerator programming contest.

On this webinar, we will talk and demo how to use InterSystems IRIS FHIR Accelerator as a service.

Date & Time: Monday, May 10 — 01:00 PM EDT

Speakers:  
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager
🗣 @Regilo Regilio Guedes de Souza, InterSystems Service Executive
🗣 @Anton Umnikov, InterSystems Senior Cloud Solution Architect
🗣 @Patrick Jamieson, InterSystems Product Manager - Health Informatics Platform

Hi Team, 

      A month ago, we purchased the cache license for a 10user limitation. We are a 6developers and using 3different development (internal)servers for this same license. All Developers aren't login at the same time. We have a limitation for login 2developers at a time in a server. But sometimes, we are facing a <LICENSE LIMIT EXCEEDED> issue.   We don't know why we are facing this one.  So anyone please guide me, why we are getting this type of issue. I have attached the errored screenshot.

Thanks, 
Ponnumani G  

Hello,

I am trying to find out if it is possible to decode the Azure access token in IRIS. Has anyone ever tried this before? I need to decode the token to extract the "Scope" details in order to verify the scope to make sure client is permitted to do the request they have done.

If you could point me to any information, that'd be great. 

Thank you.

Utsavi

I need to show the absence of data, so I have to join the list of predefined values with a result of a select statement.
However, it seems like Table Value Constructors in JOIN are either not supported, or I do not understand the syntax.
Basically, I am going for something like this:

Select v.valueId, m.name 
 From (values (1), (2), (3), (4), (5)) v(valueId)
     left Join otherTable m
        on m.id = v.valueId

Is it supported in Cache SQL or not?

Hey developers,

We want to hear from you! Give us your feedback on the past InterSystems Developer Tools Contest! Please answer some questions to help us improve our contests.

👉 Quick survey: InterSystems Developer Tools Contest Survey

I'm just starting off with ZPM and noticed that examples of library-type packages and full applications abound, but I have not unearthed any that demonstrate packaging an interop production. It doesn't seem like it would be too big of a jump from a full application to an interop production, but that is likely ignorance speaking.

So, does anybody know if this is possible/advisable -- or if I am just way off on the intent of ZPM?

Thanks!

Hi Community,

We're pleased to welcome @Wenyi Liu as our new Chinese Moderator in the Developer Community Team!

Let's greet Wenyi Liu with big applause and take a closer look at his bio!

I want to create a Sample Database for Cache InterSystems and want to access it via Cache Entity Framework Provider. But, I cannot find a particular engine of Management Portal to create a database. 

Can you guide how to install Management Portal in Windows?

Hey community,

The InterSystems Developer Tools contest is over. Thank you all for participating in our exciting coding marathon!

And now it's time to announce the winners! 

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

As per the documentation, this is supposed to delete the contents of the lookup table, but it is deleting the table as well.

https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls…

Delete the contents of the lookup table pTable.

Purpose: I need to use a temporary Data lookup table within a DTL for repetition count of a key field. 

Steps:

Initialize - s tmpTable = ##class(Ens.Util.LookupTable).%New()

Lookup & add new entries - 

..Lookup("myTempTable",sThisPhone)

s % =

In this article, I am going to give some examples to get your own docker image with InterSystems Caché/Ensemble.

Hi Everyone,

It's now more than 450 applications on Open Exchange - exciting! That's so important for app's developers to hear your thoughts about their applications.  So - if you tried at least 1 app / project on Open Exchange: 

⇨ join the Open Exchange Reviews Marathon and enter the raffle for a prize: Logitech C920S Pro HD 1080p Webcam!

Is there a way of coding in ZEN for the graphic below for ZEN PDF reports?

Hi Developers!

This is a release of how did we improve the Developer Community in April 2021. The key features:

• Copy-to-clipboard button in code blocks
• Post translation page
• Private reply to post
• InterSystems Official Releases & Alerts page

See the details below.

In this 3-part series of articles, is shown how you can use IAM to simply add security, according to OAuth 2.0 standards, to a previously unauthenticated service deployed in IRIS.

In the first part, was provided some OAuth 2.0 background together with some IRIS and IAM initial definitions and configurations in order to facilitate the understanding of the whole process of securing your services.

Episode 18 of Data Points features a discussion with Regilo Souza, Patrick Jamieson, and Evgeny Shvarov about the new InterSystems IRIS® FHIR Accelerator Service. This new product offers a turnkey solution for FHIR application developers, and there is an upcoming developer community programming contest around it!

Hi! I have a promblem with ##class(%File).Exists -method and scandinavian characters.

Ensemble: Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2018.1.2 (Build 309_5U)

I have a business service (EnsLib.EDI.XML.Service.FileService (charset=binary)) which reads XML-files from the server and transmits those to the business process. BP request class is EnsLib.EDI.XML.Document. In BP I have code block 

 SET SourceConfigName = process.%PrimaryRequestHeader.SourceConfigName
 SET SrcPath = ##class(Ens.Director).GetAdapterSettingValue(SourceConfigName,"FilePath",.tSC)
 SET AttachFileName = request.

Needing to know how to define a property that can either be sent in my response as 

"members": null,

or 

"members": [
                {
                    "dob": "1905-05-01",
                    "firstName": "BOB",
                    "middleName": "T",
                    "nameSuffix": "",
                    "genderCode": "M",
                    "lastName": "COLLINS",
                    "memberId": "123421741",
                    "relationship": "Subscriber"
                }
            ],

Not sure if this is possible.  Currently defined as 

Property members As %VarString;

I am updating the PV1 segment with values from the database but when I get two values back I dont know how to separate them with a tilde and insert. Any advice for me on that?

so if I get two values returned

my PV1.7 segment should be :  

My current code is as below: It works fine for one value, but when there are more than 2 values returned I need to find a way to include it

Set res=##class(%ResultSet).%New("%DynamicQueryGW:SQLGW")

Set sc=res.Prepare(sqlstring,,conn)

Set sc=res.Execute()

while res.Next()
    {
     s RET = res.GetData(2)
}
    
    s sc=res.Close()
    
    Set sc=conn.

We're working hard to bring you the learning content you need -- help us by taking this 2-min survey to tell us what you're looking for!

May I ask what the solution is to the error below?

Recovery started at Fri Apr 23 09:14:58 2021
     Current default directory: c:\intersystems\cache\mgr
     Log file directory: c:\intersystems\cache\mgr\
     WIJ file spec: c:\intersystems\cache\mgr\CACHE.WIJ
Recovering local (c:\intersystems\cache\mgr\CACHE.WIJ) image journal file...
Starting WIJ recovery for 'c:\intersystems\cache\mgr\CACHE.WIJ'.
  0 blocks pending in this

Hi, Community!

Please share your experience on code deployment on production site. Do you compile ObjectScript on Production? Is it OK? 

Or you only compile on Test site and copy cache.dat to a Production?

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ ObjectScript Package Manager ZPM: Installing, Building, Testing, Publishing IRIS

Hello Community,

We want to send ALL updates from our Cache server to a remote SQL Server instance that will be used as a reporting data warehouse.

Has anyone done this already and if so what is the best way to go about setting this up?

Thanks

Regards

Mike 

Hi Developers,

Enjoy watching this new video presented by @Evgeny Shvarov:

⏯ Package First Development Approach with InterSystems IRIS and ZPM

Hello. I have a query in the database that returns several rows, I need to get an "X" number of results randomly.I tried traditional commands from other languages but was unsuccessful.Does Caché have something like that? 

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in April 2021: