Hi, I hope this post helps.

The bottom line: MAXLEN is relevant mostly for odbc/jdbc connections and you need to specify an appropriate value within your  tables (classes), otherwise the data might be truncated when you query it, or even fail when you try to insert data.

Long story:

the sql GUI in the portal is very lenient in reference to the MAXLEN  , for example you can insert data into a table where there is data longer then the size of a column, if you're using fhir sql the columns in the tables are mostly MAXLEN =50 even if there is much larger data, additionally if you create a table from

Hi Guys

Two of the HC servers I manage (a mirrored pair) have lost the ability to debug code, and I am unsure as to why this has happened. Clearly something has changed, as the other three are working just fine.

When I select a Class Method as debug target, add a few break points and run it, I get the following Output

Debugger executing '##class(InPhase.Test.CanUpdate).TestBIU()'
Executing ##class(InPhase.Test.CanUpdate).TestBIU()

<COMMAND>zDebugStub+40^%Debugger.System.1

Program has terminated.
Target has exited debugger

The classmethod being Debugged ##class(InPhase.Test.CanUpdate).Te

#Mapping
@Jenna Makin 
@Ashok Kumar T 
@AndreClaude Gendron 
@Saul Bloom 
@Anthony Filaski
Folks,

I need help mapping following JSON elements with HS.SDA3 Container. Could you please share if you have any mapping details.
Source ------->Target (SDA3)
Medication (Custom Persistent class with HS.SDA3.Medication)
Procedure(Custom Persistent class with HS.SDA3.Procedure)
Referral (Custom Persistent class with HS.SDA3.Referral)
Appointment (Custom Persistent class with HS.SDA3.Appointment)
Immunization (Custom Persistent class with HS.SDA3.Vaccination)
Diagnosis (Custom Persistent class with

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).

My client certificate is in PEM format, the decrypted key was extracted using SSLOpen.

Alert: SQL Query using “NOT %INLIST” fails to return results

InterSystems has corrected an issue that can cause a small number of SQL queries to return incorrect results.  See below for the specifics on impacted queries.

This issue exists in the listed versions of the following products:

• InterSystems IRIS® data platform
• InterSystems IRIS for Health™
• HealthShare® Health Connect

As well as:

• Other InterSystems products based on the above products.

Impacted versions:

• 2021.1.3, 2021.1.4
• 2022.1.3, 2022.1.4
• 2023.1.0, 2023.1.1, 2023.1.2, 2023.1.3
• 2024.1.0

Only queries with the following

Attending Global Summit 2024? Sign up for a personal training sessionwith one of our technical trainers.

🌟 This week the spotlight is on @Susan.O'Leary, Learning Services Training Manager!

Sign up for a 45-minute session to talk to Sue about interoperability/integrations or Unified Care Record. Refresh your memory on previous classroom training, discuss a technical concept, or start learning about InterSystems technologies.

📧 Email GSTechExchange@intersystems.com or visit the Tech Exchange concierge desk at the Summit.

Find more details about technical trainers and their specialties.

Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ Introducing Smart Data Services @ Global Summit 2023

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).

This article aims to provide some more information on mg_web and to explain why it's worth a look for ObjectScript developers.

The first thing to understand is

hi there,

I recently created a shell script to run the integrity check.

I used this as reference - Introduction | InterSystems IRIS Data Platform 2023.3

I found the example from above url having a line - "

kill ^IRIS.TempIntegrityOutput(+$job)

it isn't working when I used in a script. it returns the pid of my iris session instead.

I had to simplify the example to run following lines instead - 

Do CheckList^Integrity(,,,,5)
do Display^Integrity(,1,)
 

script runs fine and can see integrity check results as expected.

however, the output seems cumulative, and output includes all historical run results as

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

Not sure what I'm missing? 

I've installed and mapped all classes similar to our old working system and I can access all classes in studio with not issues and do queries in management portal, but when trying to build all I get a message "Nothing to compile " usually rebuilding always compiles all classes even if they are already compiled, not sure if this one of the

Hi all,

When making a Business Process reusable, I needed to make the target of a <call> configurable as a business host setting. This can be done through indirection. Here's how:

The setSchema () method is not implemented in CacheConnection, so how should I switch Schema?
 

Technical surprises using VECTORs
>>> UPDATED

Building my tech. example provided me with a bunch of findings htt I want to share.
The first vectors I touched appeared with text analysis and more than 200  dimensions.
I have to confess that I feel well with Einstein's 4 dimensional world.
7 to 15 dimensions populating the String Theory are somewhat across the border.
But 200 and more is definitely far beyond my mathematical horizon.

When using something like BeyondCompare when working with production class exports, the XData block "items" content very rarely if ever wind up in the same order making Beyond compare a total mess.

Is there a way of either sorting it on the export, or would I have to find (or write) some XSLT-based tool to go into the exported class and sort all the items? Does anyone know of a tool like that available?

Thanks!

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'

2 entries were displayed from 5 records.

Now when I look in Subject Name Filter, it still display all the distinct values of Subject Name.

I want this to display only Chemistry and Social (as Name filter got applied).

In documentation, it is mentioned that

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.

Hi

I've installed Ensemble 2018 then enabled IIS from Win features, then realized that CSPGateway doesn't exit so I downloaded and installed CSPGateway-2018 from WRC.

so now I'm trying to set up a Website application and facing some issues, and I think IIS and CSPGateway in inetpub are not connecting or synchronising properly but mostly is accessing Web gateway via IIS my understanding is that I can access using the following url http://machinename/csp/bin/Systems/Module.cxw  using my machinename or IP but it's not happening.

I can access the gateway from Managment portal with this url http://loc

Hello Community,

I just go through the IRIS latest documentation and I found the openAPI property is  "x-ISC_DispatchParent" was mentioned in sample swagger and its the actual property used in spec-first approach. However in some place the property was mentioned like "x-ISC_DispParent"  and bit discrepant
/confused. So, Just want to ensure Is this is an issue in documentation?

Thanks.

Ashok.

Dear experts,

I'm using a test enviroment to test freeze & thaw scripts on windows. I executed command:

..\bin\cache -s. -U%%SYS ##Class(Backup.General).ExternalFreeze()

then was saved log in cconsole:

04/28/24-10:38:55:070 (6588) 0 Backup.General.ExternalFreeze: Suspending system
04/28/24-10:38:55:070 (6588) 1 Backup.General.ExternalFreeze: Warning, d:\test\databases\logic\ is not being journalled
04/28/24-10:38:55:070 (6588) 1 Backup.General.ExternalFreeze: Warning, c:\test\mprllib\ is not being journalled
04/28/24-10:38:55:085 (6588) 1 Backup.General.ExternalFreeze: Error:

Hey Developers,

Watch the latest video on InterSystems Developers YouTube:

⏯ Identifying Structured and Coded Data in HL7 FHIR Resources

Is there a way to exclude specific members from a class when exporting to an XML or UDL file? Bonus question: is there a way to import from that file without overwriting those members that were excluded?

The use case is to export an interoperability production class without the ProductionDefinition XDATA. We plan to source control the production items through the Ensemble Deployment Manager, but we still need to export any custom code in the class definition itself.

I am receiving an XML input to my router and in the routing rule I need to traverse through the xml data , apply a for loop and fetch data.

How can I do that ?

Input :

<?xml version="1.0" encoding="UTF-8"?>
<Input>
   <data>
      <Ids>
         <Id>
            <Type>A</Type>
            <Value>123</Value>
         </Id>
         <Id>
            <Type>B</Type>
            <Value>456</Value>
         </Id>
      </Ids>
   </data>
</Input>

I would like to read 123 from above xml in a rule ..

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'

Thanks!

Hi,

In Ensemble we have a http service that need to handle various ISO200022 xml structures .
We would want to use the Virtual Document message structures to pass this xml document on to the reset of the Production for processing. 

Access for Global Masters:
Please access Global Masters via ➡ this link.

Log in using InterSystems SSO ("Login with InterSystems" button on the left). 

At InterSystems, we strive to give you the best quality in everything. Including the realization of our Global Masters program. 

The vendor of this platform has been acquired by another company, and unfortunately, we will no longer be able to continue hosting our esteemed Global Masters program on this platform. We are currently evaluating new platform providers to facilitate the transition of the Global Masters Advocate Hub.

Beginning April 26th, we will temporarily suspend access to the Global Masters program as we transition to a new platform.

FAQ:

Hi,

Is there anyway available to get the current status of Write Daemon through code?

Generally, this information is present in Management Portal->System Operation->System Dashboard->System Usage->Write Daemon.

Thanks & Regards,

Syed

Hi Team, 

Is there any way to disable all operation ( or services) in a production entirely? 

For example when restoring from one HealthShare environment to another we may need to get the configs (IP, port, ssl etc ) updated before staring the operation. We set the production autostart to disabled but still need to disable the operation one by one if we want to start production without operations enabled.  

Thank you for your help. 

there is a setting in VSCode "objectscript.export: {noStorage: ture} "  allow export cls from server to client, without storage definition. 

However, wheneven I complied and save cls in my vscode client, the storage definition was added back. If I don't want it, I have to deleted the part manually. 

Does anyone have something to teach me? thank you

The current jdbc driver version is 3.1.0, but it is not published in the public mvn repository, only the old version, see:

https://mvnrepository.com/artifact/com.intersystems/intersystems-jdbc

It is very bad to the Java Community. And why not publish IRIS Hibernate dialect in mvn repository too?

These actions are important to Java Developers.