We are experimenting with IIS, as the PWS will be gone in newer versions.

The code which is executed, takes 15ms to run. If we execute it through PWS (REST), there is some overhead and the total execution time is 40ms, which is acceptable. However, if we go through IIS, it takes 150ms or sometimes even more.

Both PWS and IIS are running on the same server as IRIS in this case. No optimisations have been done on IIS.

Any suggestions on where to look/what to optimize on IIS?

2 4
2 133

I am trying to locate a method that would allow me to differentiate between InterSystems preinstalled/system namespaces and "our own" namespaces. I am interested both in Cache and Iris answers if they are different. Yes, I can list what to disregard, like if not HSLIB or if not DOCBOOK but hoping for a more universal and elegant answer.

0 3
0 117

I don't have a current project where I am needing to create a new operation that uses SOAP at the moment but as someone who still has some SOAP connections in her Production, I was curious if VSCode had an equivalent to the SOAP Wizard that helped create all of the SOAP classes needed based on the provided WSDL? Does anyone know? Or has this become a manual process?

Thanks in advance for help curbing my curiosity!

0 4
0 114

I have the JSON message below. I am struggling with parsing the data in the OtherProcedures section. That section can be null, or have from one to many other procedures. Any help is greatly appreciated. I have tried using/setting an iterator to go thru the data but not having any success with that.

0 5
0 105

Hello everyone,
After upgrade to InterSystems ObjectScriptv2.12.3 extension an annoying "bulb" occured in the beggining of code line. If point upon it, there are some actions being offered. In my case, an action "Wrap in try/catch" is always among them, even if the code line is already within try/catch block. Another action which appears sometimes is "Extract to method". If accept, new method is inserted into the class with only one line body inside. IMHO, not too clever "AI solution" as well.

0 2
0 106
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 87

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

0 2
0 92

Hi, I was working with %sStream.FileBynary and following the doc when I find an info that I'm not sure of.
In the part of the doc where it talks about saving streams, it does not precise where it is saved.
I tried to fill my stream, then rewind, then set the file and finally saved.
And it puts in my default directory with the temporary name.
If I do a zwrite of my stream, I get these properties about the file and directory.
(StoreFile) = "zKc2m8v1.stream"
(NormalizedDirectory) = "C:\InterSystems\Community\mgr\user\stream\"

0 6
0 78

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 81

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 3
0 79

Good morning, 🙂

I would like to ask a question, which has to do with how to manage %GlobalCharacterStream representing JSONS.

Thank you for reading this question, thank you for your help, and thank you for your time and attention.

Specifically, in a certain Process, we were querying 2 Operations, whose response we were converting to a Property called "informesAutorizadosRangoFechas" (reportsAuthorizedInRangeDates) which is %GlobalCharacterStream whose content is a JSON with the same structure.

0 4
0 77

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 76

In Cache End of file throws error but in IRIS no indication of End of file. I have to do an explicit $ZOF. How are you handling/detecting End of File in IRIS?

In cache this line will throw End of file error - F PREC=1:1 U FILE R REC D SOMETHING

But in IRIS this goes to forever, has anyone noticed this behaviour in IRIS?

0 2
0 76

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

1 3
0 75

I created %ZSTART, having just learned about it. I included some minimal code to test it, as follows:
%ZSTART
SYSTEM
WRITE "SYSTEM.",!
QUIT
JOB
WRITE "JOB.",!
QUIT
LOGIN
WRITE "LOGIN.",!
QUIT
CALLIN
WRITE "CALLIN.",!
QUIT

Now Terminal still works as normal, and sure enough I get "LOGIN" displayed, but when I start Studio I get an error message such as the following. I wonder what Caché ODBC has to do with it.

0 3
0 71

Hello Community,

I have below issue -

I have an ID with 123456.(ID as a dynamic value coming from request message)

I wanted it to be displayed as "123456" in Json Stream.

Code Example:

set object = ##class(%ZEN.proxyObject).%New()

set object.ID = ID

set x = ##class(%ZEN.Auxiliary.jsonArrayProvider).%WriteJSONStreamFromObject(.json,object)

Case:1
ID : 123456

Will output:

{

"ID": 123456

}

but I need :

{

"ID": "123456"

}

0 3
0 68

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 66

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 64

Hi guys,

I try to make a test of encryption, decryption of a simple text.

I can crypt my text, but I can't decrypt it, do you see somewhere a dummy error of my part ?

Thanks for help

ClassMethod UnitTest()

{

set inputPlainText = "David"

// get private key

set privKeyFileName = "C:\temp\toto.pem"

set privobjCharFile = ##class(%Stream.FileCharacter).%New()

set privobjCharFile.Filename = privKeyFileName

set privKey = privobjCharFile.Read()

0 2
1 62

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 63