Syndicate content 0  
 
Question
· May 2
Compact & Truncate

Hi Guys,

I never ran a Compact & truncate process before and we do have a 4.6TB database with 1.9TB free space available that I would like to recover

0 8
0 47

Hi Guys,

My Cache.dat has a expanded a lot and some globals occupy a lot of disc space with just junk data so I would like to kill some globals and shrink the cache.dat file because I'm running out of disk space?
So is there a way to do that without having to do it through the Truncate & Compact databases?

Thanks

0 4
0 46

I recently set up InterSystems in the Azure cloud environment. So far, no issues. Recently, I was tasked with uploading the IRIS.dat file (FoIA VISTA) into the instance. I was guided by my teammates to do the following: System Administration > Configuration > Local Databases. The problem is that I need to transfer the .dat file to the instance, because, as it is running on a local machine, it cannot retrieve files from my local drive. Is there a reliable solution, such as a transfer method or way of using the Web Gateway endpoint, one can provide to assist?

0 2
0 45

Hello Community,

I'm executing the same query with same column name but in different case. An unique cached query generated while query executed first time. The query preparser only normalize the keywords and send to the SQL engine generates the Hash. Eventually use the cached query next use.

Now my question, The hash values are same for both of the queries. Then why it creates two cached queries.

Query1: select * from MyLearn.Test where Name['Kev1'

Query2: select * from MyLearn.Test where NamE['Kev1'

0 0
0 44 
While performing the IRIS upgrade on our backup test server I noticed the following error in the messages log after restarting IRIS:

04/26/24-16:28:36:788 (5701964) 1 [Utility.Event] (HSHCPRT) Failed to retrieve journal file #9567 from FCHHSHCPRTTX02/PRT: Failed to allocate a 33686036 byte tcp buffer for zlib compress.

Stumped on this one, I logged a WRC and looked at some things with support but was not able to resolve the issue. Any help would be greatly appreciated.

0 3
0 44

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 44

The users wants the ability to modify the logic used to populate PID:22 depending on the value of PID: 39. The logic is as follows

If both PID:22 and PID:39.2 are null then set PID:28 to "Unknown"

If PID:22 and PID:39.2 are not null and are the same value, then populate PID:28 with PID:39.2

If PID:22 and PID:39.2 are not null and are different, then set PID:28 = "Undetermined"

Setting this condition in a transform is straight-forward,.

0 3
0 43

Hi Everyone,

We are using SQL based KPI's to display reports in IRIS dashboards. We have applied the filter functionality in these SQL based KPI reports.

I need your help for below scenario.

Below is my full report. Filter is applied on Name and Subject Name in this report.

Now I have used filter on Name and selected values 'Virat' and 'Big Show'

0 1
0 40

I'm trying to configure an SSL/TSL configuration in our test environment so we can send ADT messages to an external server. I've verified connectivity/firewall to the external server.

type is set to Client, Server certificate verification is set to Require.

I have received a certificate from the external supplier and linked that in the "File containing trusted Certificate Authjority certificate" field. (I've also imported it into the cert store and tried using %OSCertificateStore).

0 2
1 40

It's not clear to me, when using the InterSystems Container Repository, which version is the best / most recent non-preview Community Edition version to use.

I see lots of 2023.2.x versions, a single 2023.3 and 2024.1 version, but also a latest-cd and latest-em (with no explanation as to what cd and em mean).

I assume the trick is to use one of the latest-xx ones? If so, which?

Unfortunately I haven't been able to find any explanatory information anywhere about the nomenclature conventions used.

Many thanks

0 3
0 37

Hi Community!

We know how frustrating it can be to receive a lot of emails (and we definitely don't want to add to your load), so here is how you can set up email notifications for the InterSystems Ideas portal.

By default, all registered users are subscribed to all categories of ideas. To change this, just enter your Ideas Portal profile, select "Edit Profile," then click inside the item "Weekly summary email," click on "Categories to highlight" and choose what you're interested in.

2 0
0 36
Article
· Apr 30 3m read
mg_web for ObjectScript Developers

A few weeks ago I posted an announcement about a JavaScript-based interface for our mg_web WebServer interfacing addon module. mg_web isn't just restricted to use by JavaScript developers though. Many readers will be ObjectScript developers who are more used to using CSP as their web gateway. Some may even have much older legacy WebLink-based applications (and be wondering how to support them given that IRIS does not support WebLink).

3 0
2 36

Hey Developers,

Watch the latest video on InterSystems Developers YouTube:

⏯ Identifying Structured and Coded Data in HL7 FHIR Resources

https://www.youtube.com/embed/_2NksmmiUiQ
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 35

in the InterSystems management portal, I am in the lookup table viewer (interoperability>lookup Tables, I would like to use import function to convert our existing table from other system to intersystems lookup table.

so I converted our existing one like below and saved it as xxx.xml file locally. when I try to import, it says it is not a valid export file.

my question is " what's the valid format for a file to be valid to use to import for lookup table?"

0 4
0 34
Question
· 18 hr ago
help with HL7 Transformation

Hi,

I'm new to IS and the HL7 transformations using the DTL. I need some clarification on the foreach action.

I want to iterate over IN1 segments, and output only segments that contain certain allergy types in IN1-2 with foreach. Inside the foreach block, I check for allergy type "FA" in IN1-2 and, if found, send the segment with only the required fields (fields #1, #2, #3, and #5 to be exact). Please see the foreach block below:

0 2
0 34

Hello everyone,

I have an issue related to Visual Studio Code and its InterSystems extension when exporting routines from the database to the file system.

The code entered via the terminal editor is encoded in DOS code page 437, but when I export it to my file system, even if I set the file opening to DOS CP 437, the accented characters which are two bytes long cause problems.

0 0
0 30

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in March 2024:

New Videos
№ Video Views
1 How to Migrate Your Instance to Apache - Linux Unix 16682
2 What is InterSystems TotalView For Asset Management 1180
3 InterSystems IRIS Business Intelligence - Tips & Tricks 394
4 Clinical Research Data Pipeline Using FHIR & OMOP 86
5 #11 InterSystems Developer Community Roundtable - March 5, 2024 75
6 How to Migrate off the Private Web Server - Windows 65
7 Health Data De-Identifier 55
8 Tutorial - Adding OpenAI to Interoperability Production 52
9 How to send messages to Microsoft Teams 44
10 Near Real-Time Analytics with InterSystems IRIS & Debezium Change Data Capture 33
11 What is the HL7 FHIR Specification 27
12 Generating meaningful test data using Gemini 27
13 #12 InterSystems Developer Community Roundtable - March 26, 2024 23
14 Easily Extracting Insights from Unstructured Data using SQL Search 23

0 0
0 29