Hi there have been various posts around how to clean up globals without parent data but none have gone into how you solve these issues. 

Our database is approaching 600gb in size so i am looking into how to reduce this. 

We use standard purge tasks. 

Our cache stream class has a global size of 2463243 from running global size so it is what i would like to tackle first. 

1) is there any way i can find based on my oldest message session for where most of these globals 

0 2
0 64

Hi,

I have tried to install the module git-source-control into my USER namespace, but get the following error.

ERROR! ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method.  Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...)  WHERE errRowID={2763|2764}>
  > ERROR #6084: Unknown errors detected, but no error code reported

 

0 1
0 50

Is it a good practice to set the MAXLEN value of %Library.String property type?  Will it lead to wasted storage if its not really using it?

For example, I have to store a 5 characters long string into the below str field. Which of the statement is recommended? 

Property str As %String;

vs

Property str As %String(MAXLEN="5");

 

 

0 2
0 101

I had a customer the other day ask how GREFs are measured and how the relationship of the host, storage, and DB engine all influence that number measured in hundreds of thousands or millions.  Is there any good documentation that explains this and/or assists with calculating a GREF count?

0 2
0 92

I'm hoping someone here has some tips. I'm trying to filter by d/t in a routing rule. Basically if before a specific d/t, send to one feed. If after, send to another. The d/t time is in a yyyymmddhhmmss format. I've tried a couple things but can't get it to work as expected. Any tips to accomplish this would be appreciated.

0 2
0 68
Question
Roger Andre · Jun 21
Freeze MSM/MUMPS

Hello, today we had another freeze in the system. It was close to 09:55. Logs follow for analysis. Following are MSM/MUMPS logs with about 1050 active connections at the time of the freeze. Does anyone see something different?

0 3
0 143

Good Morning SMEs,

 

I am a .NET developer and new to using this IRIS Component. We are using InterSystems.Data.Clients ADO.NET component to connection to IRIS, I am able to open the connection but when i called Close, ADO.NET code showing connection is closed state in .NET code but in IRIS side it showing as connection is still open. The will close only after recycling apppool or closing IISExpress/calling application

 

Here are the steps I used to open the IRIS connection.

0 1
0 74

Hello! Need help...
Please tell a newbie how to connect to a remote database.
OS Centos 7, WebServer type Apache, version cache - cache-2014.1.5.851.1-lnxrhx64,
license:
[ConfigFile]
FileType=License 5.1

[License]
LicenseCapacity=Cache 5.0 Entree - Concurrent Users for Intel (Linux):40, Multi-Server
CustomerName=...
OrderNumber=2010...
ExpirationDate=4/26/2036
AuthorizationKey=...
MachineID=

0 15
0 196

Hello all,

I was looking at some code of a business service of which the author is unknown. It's very simple in what it does; it extends from Ens.BusinessService and has a method that performs SendRequestSync() to a business process. However, I noticed that the business service lacks an OnProcessInput() method. Rather, it uses a method called General() which has the same sort of signature/structure that OnProcess input does--pInput as [Custom Message Class], Output pOutput as [Custom Response Class]. 

0 7
0 126

Hi,
I am looking to define an architecture combining both IRISforHealth's FHIR server and HAPI's MDM capabilities. Is there anyone who has already implemented this type of solution?
The goal is to implement a single patient repository for multiple hospitals, so HAPI MDM is really interesting.
From what I've seen, some of the issues may be around compatibility between Caché and Hybernate.

Thanks

0 2
0 103

Hi Guys,

I'm getting the below TLS error in SSL_connect(), SSL_ERROR_SYSCALL, I've treid mulitple SSL/TLS configuration and still get the same error, so should I be asking the client that I'm trying to connect if there a specific certificate or configuration!?

 

0 4
0 111

Good morning,

We would appreciate if you could read us and if you have the opportunity, please respond to us.

 

The current situation is as follows:

We have 2 environments PREproduction and INTegration :

Ensemble version in PREproduction:

Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2018.1.6 (Build 717U) Thu Feb 24 2022 13:27:54 EST

Version of the tool to convert XML to ER7 and vice versa, the ITB, in PRE (we get it in the ITB.info.cls file):

0 1
0 38

Hello!  I need help reading a file and putting the contents into variables.

File path would be, c:\temp\zipcitystate.csv or txt

Data looks like this

00501,Holtsville,NY
00544,Holtsville,NY
00601,Adjuntas,PR
00602,Aguada,PR

I need to add the first area to variable ZIP, Second to CITY and third to STATE. they are separated by a comma.

 

Any help would be appreciated 

0 8
0 193

Hi Guys,

I have a service that picks up jobs and process them, is there a way that I can cap the number of attempts to pickup a certain job eg. 10 times if no response then just discard ? 

 

Thanks

0 1
0 84

Hello to all my fellow Cache Experts.   Quick question about the MONLBL output that identifies performance issues.  There is a metric value output by MONLBL called "Obtain [NEW] connection to Cache".   Supposedly that metric captures the time taken between the request reaching the CSP Gateway and a connection to Cache being reserved for the purpose of servicing the request.   All of that being said, if that metric value is high for many requests, such as 19.x seconds, then can anyone tell me what that metric really means and how to improve (lower) the new connection to Cache time.   The com

0 3
0 171

Hi,

Currently I am working to develop smart on FHIR app with FHIRaas with the help of fhirclient.js and facing one issue that .well-known/smart-configuration is raising following error "This endpoint does not have SMART on FHIR capabilities defined" Below snapshot is for reference:

 

Looking forward to resolve the above issue or workaround

Thanks

0 1
0 93

Hi Team,

We are facing an issue connecting to a remote Cache DB server using CacheODBC 2018 on the client side.

The connection works fine without SSL on the Cache server, but when SSL is enabled, we are getting the below error - "Failed to load cconnect executable!, SQL state 08S01 in SQLConnect"

Also, the connection works fine when the PHP script is run through CLI on client server, but fails with the above error when the script invoked from a client browser.

Could you please help us with any pointers in resolving the issue?

 

 

0 1
0 79

Good morning,

First of all, thank you very much in advance for reading and responding.

Also, thank you for any support, because it is a relief, support, contribution, help to have people with more understanding, knowledge and practice, reading, and thinking this doubt.

 

There is the following need:

Two 2 circuits are available:

1st DICOM Circuit of "Studio" ( Classic Service ).

Service: class: DICOM.BS.QueryService

Process: class: DICOM.BP.QueryProcess

0 1
0 60