Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

0 2
0 167

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,

0 5
0 155
Question
· Feb 20, 2023
Roles and user access

Hi Guys,

I'm looking for an easy to allow certain user to only have access to one CSP or Zen page from my application, my thoughts is to create a role to only access that specific page then allocate that role to my user, but can find the Zen page so I can allocate it to a role?

Thanks

0 1
0 252

Hi everyone,

I'm facing issues uninstalling Ensemble software from my system. I've tried using the command first ensemble-2018.1.0.184.0-win_x64.exe /instance LOCALENSEMBLE /qn REMOVE=ALL. Additionally, when I try to uninstall it through Settings > Apps and Features, it doesn't get removed and lists the app again there.

Has anyone encountered a similar problem or could provide guidance on the proper uninstallation process for Ensemble? Any help would be greatly appreciated.

Thanks!

0 1
0 160

Hi

when using $zt($P($H,",",2)) from terminal it gives the correct local server time but when using it in my cache code it gives an incorrect time (5 hrs difference)

but from the code it gives 13:14:54 !?

Thanks

0 4
0 217
Question
· Oct 9, 2022
HTTP request with open stream

Hi Guys,

This link (https://github.com/CassiaNetworks/CassiaSDKGuide/blob/master/node_exampl...) uses Javascript request to open a a steam and collect data in an array (screenshot below) and I'm trying to replicate this with Cache script with HTTP request which is connecting Ok but don't know how can I collect data because the code is hanging at Set tSc=Httprequest.Get(HttpURL) and cannot execute S BLEConnect=Httprequest.HttpResponse.StatusLine or any line after it.

0 9
0 495
Question
· Apr 29, 2024
Page not found in Zen application

Hi Guy,

Made a fresh new Install of our currently working application from our current server to a new one but when trying to run the application in the new server it raises a page not found error:

this is the web application setup

0 4
0 126

I have a scenario where I send a GET request to a broker and receive a FHIR response. When I attempted to use the built-in InterSystems functions to convert this FHIR response into SDA, the transformation failed—likely because it is not a standard FHIR request.

How should I handle this situation? Is there a recommended approach to processing FHIR responses in this context?

0 3
0 80

I would like to search for all messages where their body size is greater than 3MB.

I have searched through the common Header and body properties and I have not found a size property. I have looked at the extended properties but I am unsure if any of the extended classes allows me to find the Doc size.

I have stepped through most of the body property classes related to messages or documents that have an exposed property that filters by document or message size.

Is there a way to do this within the Message Viewer or Terminal?

Thank you in advance.

0 4
0 344

We have a custom business service that is triggered by a scheduled task. The service queries a table, iterates over the result set and sends a message on to a business process for each result. Happy path functionality is all fine.

However, when there is an error detected in the business service code, neither throwing an exception nor returning an error %Status behaves as we'd expect.

0 1
0 143
Question
· Jul 16, 2024
Add Zen component

Hi Guy,

I'm currently using a classmethod to load my page's display content in a form of html want look good, I'm wondering if I can add a Zen component in my classmethod eg. <dataCombo> or Label...etc?

I've tried the bit of code (circled in red) but didn't work

Thanks

0 4
0 125

Hello, dear colleagues.

I need to connect to a remote JavaGateway from an Ensemble service.

I am trying to use the EnsLib.JavaGateway.Service with a remote host where the JVM is running.

I can successfully ping the remote Java Gateway from EnsLib.JavaGateway.Service, and Ensemble reports that the service status is OK.

There are no network issues, and all necessary ports are accessible.

0 1
0 68

Hi Friends ,

We have requirement to load data into chache tables from external database (ref data). This process will take 1 min to complete all data load.

Currently I have created Business Service to trigger Business Operation with out bound db adapter to load data into cache tables.

process will be trigger when i restarted business service.

But requirement is , this business service should be triggered from outside ensemble environment i.e , this should expose as REST endpoint and share with the external team.

0 1
0 223
Question
· Sep 8, 2023
Viewing stored images

Hi Guys,

In my Zen page I've a grid with a list of uploaded images and it's working fine when running from the Server where the application resides where I can just click to an image and my code displays the image in a second screen (MSDS.Image.StreamServer.cls) ,

0 1
1 235
Question
· May 14, 2024
dynaTree looping

Hi Guys

I'm using the below to populate a tree to just show the root with a folder icon but whenever I click on a folder it loops back to the original folder, how can I disable the root folder from expanding to the next, I only want to show the main opened root folder and not to go any further?

0 1
0 96