Caché | InterSystems Developer Community

Question

CPU and Memory utilization per namespace and business component

Hello,

Very much keen if we could gather the per namespace and business component utilization of InterSystems cache server.

For e. I have a PRD server where its CPU utilization is at max all the time and I want to know which namespace and its business process (service/Operation/Process) is utilizing what number of CPU and memory.

** I can get the CPU and Memory utilization per Cache.exe and PID, but not able to get the Namespace and ConfiguratioName to which that particular PID belongs.

Thank you,

#Interoperability #InterSystems IRIS #Caché #Ensemble

0 5

0 219

Question

omer · Jan 15

Where and How can i see the Stream that contains the response back to the client of a CSP application

Hey, So the title pretty much describes the question:
Where and How can i see the Stream that contains the response back to the client of a CSP application.

When the request is being processed and finished we return a response to the client - We do that by writing the data to a stream and that stream is sent back to the client.
I wanted to know how i can access the point right before that Data is actually written to the client back (meaning the place where the response is actually being send back, the last point of contact).

#CSP #Caché #InterSystems IRIS

0 9

0 168

Question

Caio Timm · Jan 22

Transform rows to colums or colums to rows

Hello guys,

I need to tranform columns into rows or rows into columns.

I'm using only SQL Cache.

The code:

SELECT
    codRepresentante
    ,vendasAbril
    ,vendasAgosto
FROM
    Ped.MetasRepresen
WHERE ano = 2024

The columns:

#SQL #Caché #InterSystems IRIS

0 1

0 142

Question

Lucas Galdino · Jan 19

cconsole alarm: ROLLFAIL: <STORE>rbbulk+27^ROLLBACK

Hi experts, please, do you know cause this errors in cconsole?
I'd like know what can I investigate.

#Error Handling #Caché #HealthShare

0 1

0 94

Question

Andre Ribera · Jan 21

In Studio is there a way to access the code that flags whether a project has unsaved changes? (is there a property that controls the "star" on unsaved projects?)

I'm working on some code that would benefit from being able to see whether or not a project file has been saved in Studio.

I can see when I make changes, that the project name has an asterisk added to it:

#Studio #Caché #HealthShare #InterSystems IRIS #InterSystems IRIS for Health

0 2

0 96

Question

Gabriel Silva d... · Jan 17

Problems with data replication in Caché 2016.2

Hello everyone,

I’m facing issues with replicating data from my Caché 2016 database to a PostgreSQL database. I need to handle around 300 data updates per minute, and whenever certain tables are modified, those changes must be reflected in other databases.

So far, I’ve tried various approaches, including:

#API #Azure #Databases #Data Import and Export #Performance #SQL #Caché

0 6

0 171

Question

Oliver Wilms · Jan 19

Where did my variables go? Without Exclusive NEW, now I get <UNDEFINED>

I inherited some legacy MUMPS / ObjectScript code. A code review identified an exclusive NEW and that is not allowed per our coding standards.

The original code contains:

RUN(CALL,DRVNAME)
S $EC=""
S ^TMP($J,"RMPV","DRVNAME")=DRVNAME
N TMPFILE,OLDIO
S OLDIO=$IO
I $G(^TMP("RMPV","SILENT"),1) S IOP="NULL",%ZIS=0 D ^%ZIS I '$G(POP,1) U IO
D INIT^@DRVNAME
D ; scope variables
.N (DUZ,CALL) ; Protect %response
.S IOF="""""",IOM=80,U="^"
.D @CALL
U OLDIO
Q

#ObjectScript #Caché #InterSystems IRIS for Health #InterSystems IRIS

0 3

0 140

Question

Ali Chaib · Jan 9

404 Not Found when sending FHIR bundle

Everytime I try to send a POST FHIR bundle I'm getting the following response: 404 Not Found. I'm not really sure why, although it works fine with a GET!

This is an example:

Response:

It might be something related to request path but not really sure.

And this is the HTTP service I'm using

#API #FHIR #ObjectScript #Caché #Ensemble #InterSystems IRIS

0 1

0 132

Question

isayas mola · Jan 15

how i can connect to cache database from visual studio 2017-2022?

#Caché #InterSystems IRIS

0 6

0 154

Question

omer · Jan 12

InterSystems Response Content-Length

Hello,
In short, I am trying to get the Content-Length of my response,

We have a CSP application, when we get a new request we begin to process it, throughout the app we WRITE to the response in different places,
now when the response is about to be sent back to the client - we would like to know its Content-Length (in the RESPONSE HEADERS).
So it comes down to two questions:
1. How can we access the Content-Length of our response?

#CSP #Caché #InterSystems IRIS

0 1

0 137

Question

LI LINFENG · Jan 6

Using the Intersystems ObjectScript plugin, how can I automatically import to the server when I delete the code file locally on my client machine?

I have installed three plugins on VS Code: Intersystems Language Server: v2.3.6, Intersystems ObjectScript: v2.10.5, and Intersystems Server Manager: v3.6.2. I connected to the Caché database and connected a workspace to the InterSystems server. Then I edited the code locally on my client machine.

#VSCode #Caché

0 6

0 208

Question

Dan Murt · Jan 3

CSP Page is catching Hyper event error when trying to call server side method

Hi Community,

I have a CSP page I am developing with the intent of pulling files from an SFTP site and placing them in a folder on the local network.

I am having an issue where the CSP page is catching a JS error. The error in the browser is - A JavaScript exception was caught during execution of HyperEvent: SyntaxError: Unexpected identifier 'downloading'. (However, the unexpected identifier changes after refreshing page, or after removing the Write statement with the work 'downloading' in it.)

I think I have narrowed it down to a piece of the Javascript code -

#CSP #JavaScript #Caché #InterSystems IRIS

0 9

0 258