Question
A.R.N. H Hafeel · May 16, 2021
IRIS or Cache?

Hello all, 

I am in a bit of a situation where I could get your help please. 

I want to get certified with IRIS, but I also do see that there is an availability named Cache. 

Are they both the same or different? if different please explain it to me as how? 

Also what is the difference between IRIS, IRIS for Health, Deep Sea? Please explain to me.

Also what do you think I should get my self certified with? 

Please leave your comments below. 

Cheers. 

00
0 2 122
Question
Anna Golitsyna · May 12, 2021
$preprocess failure

There is an undocumented command, $preprocess, that can be called as below. In this case it takes the class name and converts its code into a text array. That includes comments as well. Two questions about it if you know:

00
0 8 99
Question
Jude Mukkadayil · May 12, 2021
Cache sql query

Hi ,

     I am trying to retrieve the contact type column data of a patient based on the recent date as shown below.

for instance

 contacttype      Datefrom

contact 1.       24/03/2020

contact 2.        20/05/2021

i need to retrieve the second contact2 based on the recent date.

i tried  like below but not working .

Case max(datefrom) >0 then contacttype

End as contacttype

 

Can anyone please tell me why this is not working.Any other options?

Thanks 

jude 

 

00
0 3 94

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.

 

00
0 2 95

Hi Team,

I have a requirement to delete the Ensemble interfaces , as per User request. I would like to write a routine for that and once I execute, it should remove the interface components through code.
Could you please provide code samples for the following actions ?

  • Deleting an individual rule from a rule class
  • Deleting a class from Ensemble
  • Deleting a Host (Service/Operation/Process) from the Production.

Appreciate the help.

Thanks,

Purushothaman.T

10
0 4 71

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

 

00
0 1 48

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

 

00
0 9 92

Let's say I have a persistent class Sales.
I need to create a report that shows the amount of sales for each branch.
By simply using the class Sales for the source of the cube, I can show what I want with one little exception - the branches that did not have any sales are not shown.
Is there a way around that that does not involve creating a whole new table just for this cube or using a Data connector (they have horrible documentation and I am unable to figure out how to use them properly)?

00
0 3 59
Hello! I have a question how to parse Library.ListOfObjects to JSON

I send post data like this from client using rest and want parse "templates", after save "codeForm","codeName" in database

{
    "whoIs": "",
    "templates": [{
            "codeForm": "FORM_FIOGROUP",
            "codeName": "operationDate",
            "orderNumber": "1",
            "codeFormat": "YYYY-MM-DD",
            "header": "DATE",
            "dbfFormatType": "Date",
            "dbfFormatLength": "8",
            "valueFrom": "Payment"
        }, {
            "codeForm": "FORM_FIOGROUP",
00
0 4 70

Hello,

We have a need to track Database changes over time - down to the SQL level of granularity if possible. Such as: User xyz runs routine ^abc and we get something similar to a changelog that tells us: table A had this value updated, insert, update etc....

Is that possible using IRIS level tools (Audit Log, Journal File, etc...) , is there a way to convert the global sets and kills from the journals into SQL level changes?

 

10
1 2 101

I want to consume external websocket api, URL looks like this:

wss://site.com/ws/v2/?&token=<token>

Checked with external tool (Simple WebSocket Client) that websocket works and I can consume the data.

In Cache the relevant functionality is offered by %IO.Socket class.

set sock = ##class(%IO.Socket).%New()
set sock.SSLConfig = "MyEmptySSLConfig"
set sock.TranslationTable="UTF8"
do sock.Open("site.com/ws/v2/?&token=<token>","443", 10,.sc)

However I get this error:

00
0 17 757

I have run into two annoyances when using VS Code for server-side editing of Objectscript and was wondering if anyone knows of any solutions or workarounds.

 

1. In .mac routine files, class names that aren't fully qualified (e.g. ##class(example) instead of ##class(Package.example)) fail to be understood, so the class will have a red squiggly underneath it and a problem that reads

"Class 'example' does not exist. InterSystems Language Server".

00
0 1 55
Question
Karl Kirk · Mar 1, 2018
Cucumber / Gherkin integration

Are there any BDD testing automation implementations within Mumps/Cache Objects already in existence?

We are looking at using Cucumber for our Java regression test automation and would like to use similar feature file testing with the Cache code.


Looking to use something existing before building it.

Regards,
-Karl

20
1 5 512

Hello everyone!

Some time ago, I changed the configuration in SQL Runtime Statistic to "Turn on Stats code generation to gather stats at the Open and Close of a query". With this change, the CACHE base (cache/mgr/cache/) has grown a lot to reach 198GB.

Yesterday, I returned the configuration of SQL Runtime Statistic to the default which is "Turn off Stats code generation" and the cache base is no longer growing.

My question is?

00
0 3 72
Question
Cache Cache · Apr 22, 2021
Cache code conversion tool

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.

00
0 6 134
Question
kizito Ayogu · Apr 12, 2021
Cache Systems Backup

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.

00
0 2 92

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

00
0 9 92