Question Ravi Akkiraju · May 9, 2021

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 % = tmpTable.%UpdateValue("myTempTabl

1
0 252
Announcement Olga Zavrazhnova · Apr 28, 2021

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!

 

5
0 291
Article Vinicius Maranhao Ribeiro de Castro · Apr 2, 2020 5m read

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.

The second part discussed and showed in detail the steps needed to configure IAM to validate the access token present in the incoming request and forward the request to the backend if the validation s

1
0 1260
Question Jukka Pitkänen · May 4, 2021

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 = re
2
0 317
Question Rick Prichett · May 3, 2021

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;

6
0 402
Question ED Coder · Apr 30, 2021

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()
    {
     RET = res.GetData(2)
}
    
    sc=res.Close()
    
    Set sc=con

5
0 473
Question Rico Rivera · Apr 23, 2021

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 WIJ.
Exiting with status 3 (Success)
04/23/21-09:14:58:844 (10096) 0 Automatically configuring buffers
04/23/21-09:14:59:422 (10096) 0 Allocated 1164MB shared memory (large p

5
0 1411
Question Mike Dawson · May 4, 2021

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 

2
0 347
Question Andre Larsen Barbosa · May 3, 2021

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? 

8
0 751
Announcement Anastasia Dyubaylo · May 4, 2021
0
0 143
Article Phillip Booth · Jan 30, 2020 3m read

Over the last couple of weeks the Solution Architecture team has been working to finish off our 2019 workload: this included open-sourcing the Readmission Demo that was brought to HIMSS last year, so we could make it available to anyone looking for an interactive-way of exploring the tooling provided by IRIS.

While in the process of open sourcing the demo we were immediately hit hard with a showstopper. The underlying patient data that was used to build the demo could not be used as part of an open-source project because it was not owned by InterSystems; it was owned by our Partner Baystat

2
2 1483
Question Fábio Campos · May 3, 2021

Hi,

I'm getting thousands of errors like the ones below:

2021-05-03 14:11:44 [SQLCODE: <-400>:<Ocorreu um erro fatal>] [Cache Error: <<READ>Dispatch+14^%SYS.BINDSRV>] [Location: <ServerLoop>] [Client info: <Username: KIORAS, Node Name: 3IK0VLS5UU, IP Address: 192.168.1.223, Executable Name: EXTRService.exe, Internal Function: B0>] [%protocol: <52>] $Id: //ce/2018.1.2/kernel/common/src/aclass.c#1 $ 23468 104


2021-05-03 14:35:39 [SQLCODE: <-400>:<Ocorreu um erro fatal>] [Cache Error: <<READ>ServerLoop+16^%SYS.DBSRV>] [Location: <ServerLoop>] [Client info: <Username: KIORAS, Node Name: D

1
0 688
InterSystems Official Benjamin De Boe · Apr 21, 2021

Preview releases are now available for the 2021.1 version of InterSystems IRIS, IRIS for Health and HealthShare Health Connect.

As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability release next month. Please share your feedback through the Developer Community so we can build a better product together.

InterSystems IRIS Data Platform 2021.1 is an extended maintenance (EM) release. Many important new capabilities and enhancements have been added in continuous delivery (CD) releases since 2020.1, the previous EM releas

6
0 987
Question Oscar Muñoz · Apr 15, 2021

Hello everybody,

I am creating a WS as a server, but when I ask for the WSDL it is giving me an error because it cannot find the class.
I have added the following instructions:

set ^SYS("Security","CSP","AllowClass","MiProyecto.MiClaseWS","%SOAP.WebServiceInfo")=1 
set ^SYS("Security","CSP","AllowClass","MiProyecto.MiClaseWS","%SOAP.WebServiceInvoke")=1

I have created an entry in the WS security configuration

In the Application Roles tab I have put the %All permissions

(The Namespaces "Samples" in the image is due to security reasons)

If I invoke the service in the following way, http://

6
0 437
Question Emanuel Lazar · Apr 30, 2021

objects in javascript :

var oM = new Object;

var mMode=["down","up","click"] ;
var key,val ;
    for (key in mMode)
    {

       val = mMode[key] ;
        oM[val]={} ;
        oM[val].id   ="" ;
        oM[val].type ="" ;

       ...

 }

so I can access the .type directly as :

oM.down.type

or:

oM["down"].type

what is the syntax in CACHE or IRIS, to achieve such approach via class/key/property...?

acctually: class/object/key/property anlaogue to ^GLOBAL(key,"property")=val

9
0 351
Article Robert Cemper · Apr 26, 2021 3m read

Why SSH ?

If you do not have direct access to the server that runs your IRIS Docker container
you still may require access to the container outside "iris session" or "WebTerminal".
With an SSH terminal (PuTTY, KiTTY,.. ) you get access inside Docker, and then, depending
on your needs you run "iris session iris" or display/manipulate files directly.

Note: 
This is not meant to be the default access for the average application user
but the emergency backdoor for System Management, Support, and Development.
34
0 1335
Article Guillaume Rongier · Nov 23, 2020 1m read

Introduction

This is iris-key-uploader a frontend in Angular with it's rest API.

The aim of this project is to easily import key file to Iris from a web ui.

Why this project

Unfortunatly the IRIS panel to change key doesn't give the opportunity to upload the license.

As you can see, you can only browse from the server side.

What if, you don't have a direct access to it ?

You would like to have a simple web page to upload the new key and activate it.

This is the purpose of this project.

Demo

Demo

UI

http://localhost:52773/keyuploader/index.html

Build

Run the server

docker-compose up -d

Install w

6
0 583