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.  


0 5 30

We are seeing more and more customers being lured with latest infrastructure technologies, particularly Composable Infrastructure. Coming with all sorts of data center consolidations and costs savings.

Question is: are there any concerns for HealthShare/TrakCare being run on these platforms or things to look out for? Anyone out there, already on these platforms?


To be more specific this is HPe Synergy with 480 Compute blades booting as bare metal.



0 3 61


I'm trying to add a DR async member to a mirror but when I add this member I get this messages in the mirror monitor (on the DR member):

The message im talking about is the "missing Mirrored Databases report".

The only step I did was the " System Administration -> Configuration -> Mirror Settings -> Join as Async" an fill the blanks. Maybe Im skipping a step? 

0 3 33
Higor Granzoto · Apr 14, 2021
Java Connection Strategy

We are planning to build a REST API with the Java Quarkus Framework.

  • There'll be a connection pool;
  • The DataSource instance will be automatically injected from the connection pool;
  • We will use JDBI to do SQL instructions and this will give us automatic Connection and Statement management;

This Caché instance already have COS applications running and consuming connections and licenses.

After doing this, we will migrate to IRIS.

0 0 34
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.

0 1 68



I'm doing a query in SQL and I need to sort my data by some non-repeated field.


Unfortunately, my data is grouped in a way that I cannot guarantee that any column will not have repeated data, so one solution would be to take the row number.


Also, the Cache is not accepting Row_Number () in my querry and I would like to know if there is another solution to return line numbers or some way to add this function to the Cache.


Best regards.

0 7 117


I am creating an import tool to convert a client's JSON data into IRIS classes.   The sample file is over half a gig.   I am copying the data into an instance of %Stream.FileCharacter;.    My first few attempts worked fine.   However I started getting an error thrown when I try to create a DynamicAbstractObject using the  %FromJSON method.     See the code below.   The error code given is not in the documentation, at least not the doc that I was searching.   

0 3 90
José Hélington ... · Mar 20, 2021
Compile problem base

Hi, I have a class that extend to other classes.

If I compile one of this classes, no problem is generated.

But if I try to compile the first class using flag c-ukb, all that extend from that and have the Date component generate an error.

The error is about the method %GetPaneContents from abstract class.

Do you already passed this? How can I solve my problem?

0 2 75

Hi everyone.

I wonder, whether is it possible to get description of emoji in COS.

For example, I have data with emojis like 🙏 in database, that should be delivered to transaction system via service. But service doesn't support emojis, so I want to convert emoji to its unicode description like "Person with Folded Hands". Is it possible? I'll be grateful for help

0 1 69


Olá a todos!

Estou com dificuldades de fazer meu select para retornar palavras que contém acentos.

Na minha tabela TESTE, por exemplo, tenho palavras no campo NOME como Fábio e Fabio, porém se eu coloco a instrução:


a instrução só traz FÁBIO.

Como eu faço para trazer todas as palavras: FÁBIO, FABIO, FABÍO, FABIÓ, FÁBÍÓ, FÂBIO, etc...

Conto com sua ajuda!


0 9 100

I have  a SQL query that I want to run against MS SQL from cache ensemble using the SQL outbound adapter. If I run this query direct from MS SQL Studio it take about 7 seconds MAX and returns about half a million rows. The row only contains one column it is a number all same size and if I run this query in the production in ensemble it takes for ever the production finishes without getting the response back. The same query run in cache outside the ensemble environment writing results to a file it returns results taking about 3minutes to complete.

0 0 72
Guilherme Silva · Mar 9, 2021
Working with CSP files

i have a problem with CSP files, i can create a CSP file with termination ".csp" or ".CSP" and this configuration is case sensitive, but a CLS file, this configuration is not case sensitive. there is a way i can change this to the CSP file don't be case sensitive?

0 2 70

We have an interface that need to be disabled then re-enabled when it starts to queue up. I wrote the following code to do this functionality in a process. This works in our development domain, but in production it says it fails to disable the job - it only shuts down the interface without updating the production/starting the interface back up. Error message: "Failed to stop job '36831290' within 60 seconds. Status '<unknown>" 

Is there something wrong with how I'm trying to do this? 

set tSC = ##class(Ens.Director).EnableConfigItem(itemname,0,0) 

0 1 71


First of all thanks for your time to read and reply,

We would need some help,

We have an ORM_O01 which has a NTE.3 with a Line Feed

Our Process converts the XML to ER7 using the ITB as follows:

set context.mensajeHL7 = ##class(ITB.HL7.Util.Convert).XMLToER7(hl7,.tSC,"2.5")

When we show the ER7 we observe:

INTE|1||Psa libre\X0A\ Indice psa

We have thought about the following solution, where mensajeXML is the XML representation of the ER7 shown:

0 1 70

Where can I download the Cache ODBC drivers?

Where can I download the Cache ODBC drivers for Windows?

I need to connect to a cache database by odbc but the FPTs that I have found do not work, 
could you tell me where to download the ODBC drivers



0 7 163