I'm trying to use the EnsLib.SQL.Operation.GenericOperation component in a production to read a column from a Redshift table that is set up as VARCHAR(65535) and am getting the following error.

An error was received : ERROR #5023: Remote Gateway Error: JDBC Gateway getClob(0,1) errorRemote JDBC error: Cannot convert the column of type VARCHAR to requested type long..

1 5
0 147

I was looking for an easier way to build the FHIR Query String, given the Record Map request that is passed into the DTL.

I built this Function, but when I run a message through it, my Query String that is passed back into the DTL is a Reference Pointer and not the String I am looking for.

0 3
1 135
Question
· Aug 10, 2024
VS Code Connection

What is wrong in this snippet??

Its an iris lab so nothing so personal that someone can't use it

{

"workbench.colorTheme": "InterSystems Default Dark Modern",

"intersystems.servers": {

"irislab": {

"webServer": {

"scheme": "https",

"host": "35.188.112.210",

"port": 29363

},

"username": "tech",

"password": "demo"

}

},

"objectscript.conn": {

0 1
0 172

A nice feature that we recently added to version 2.12.6 of the VS Code ObjectScript extension is controlled by this new setting:

objectscript.serverSourceControl.respectEditableStatus

When set true in JSON, or checked in the Settings Editor, a server-side file will be read-only if the source control class for the namespace reports that it is not editable.

4 0
1 103

I just installed IRIS 2022.1 onto a new VM in the MAG (Azure Government) cloud. The install was successful. Everything looked fine.

When attempting to stop this instance of IRIS, the system hangs at "Withdrawing from License Domain". Eventually, my session is disconnected. The instance then has a status of "sign-on inhibited". To stop this instance, I need to force it.

Any ideas? Thanks in advance.

0 0
0 57

InterSystems FAQ rubric

If you do not specify the option to remove the mirror attribute of the mirror database when deleting the mirror configuration, the database cannot be restored to a normal state and will be mounted read-only the next time it is mounted. To restore the database to a read-write state, you must remove the mirror attribute using the system routine ^MIRROR.

The procedure is as follows (execute in the %SYS namespace):

4 0
2 247

Hi,

I created a property in a Business Process class and added that property to the "settings" parameter to display it as a field in production settings.

Property ServerName As %String(MAXLEN = "");

Parameter SETTINGS = "ServerName:Server Config";

Property names cannot contain characters such as underscore or whitespace. Is there any way to change the display name in production so that I can show this setting as "Server Name" and not "ServerName"?

0 3
0 139

I have a question about using OnInit() within a Ens.BusinessOperation.

When you include OnInit(), does OnInit() only execute when you start a Business Operation? Or does it execute OnInit () every time you send a REST request to the operation. I am trying to pinpoint when the best time is to execute the POST command to get the Token

I am needing to get a Bearer Token from a REST POST call and return the Authorization key prior to making the rest of the REST calls to pull down data.

0 13
0 250

I'm fairly new to InterSystems and I've been tasked with building a portal that can show DataCheck States among other details, the GetStateBySystem seems to be fit the bill but I don't see a why to call directly from the .Net SDK. I tried sql and can get data from the table but does include "state" information ("starting, stopping, running etc..."). I did find github example around .Net but none fit the bill. If anyone can point me to the right example or documentation it would be greatly appreciated.

Thank you,

0 0
0 60

Hi:

I have been adapting the IRIS WHIZ addon as part of the contest. I will soon fork the code on github so the changes are available.

The next phase is I am storing the date from and to time for a more complete search cache

zenPage.getComponent(36).value

it works in the chrome console ok

I'm not sure in external JS how to set the page it is on as a zenpage to use the zenpage functions

0 3
0 111

As I begin our adventure into using an External FHIR Repository, I wanted to see what opinions people have about a design Idea I was working on.

I want to create a way that my Team has the ability to send a Message Type, and the system knows from that Message Type which FHIR queries to execute and return the Response back to the user, sort of like a FHIR Query Hub. Does this sound reasonable?

0 0
0 78

In the previous article we presented the d[IA]gnosis application developed to support the coding of diagnoses in ICD-10. In this article we will see how InterSystems IRIS for Health provides us with the necessary tools for the generation of vectors from the ICD-10 code list using a pre-trained language model, its storage and the subsequent search for similarities on all these generated vectors.

6 1
1 288
Question
· Jul 29, 2024
Task FeatureTracker

Does anyone know what this task does exactly? And what problems would I have if I didn't use an SSL certificate?

I got the error: "SSL/TLS error in SSL_connect(), SSL_ERROR_SSL: protocol error, error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed"

Has anyone encountered this problem before?

0 4
0 135
Question
· Jul 30, 2024
Generate JWT token

Hi there,

My purpose is to encrypt a communication using JWT tokens. I am developing on IRIS and my purpose is to generate a JWT token that will run on an older version of Cache (so I have to use functions that are compatible with the older version, Cache).

I wrote this code in IRIS:

s username = "user-test123"
set st = ##class(%OAuth2.Utils).TimeInSeconds($ztimestamp,0)
set et = ##class(%OAuth2.Utils).TimeInSeconds($ztimestamp, 60*15)

0 0
0 217

I was watching this video about IRIS and GitHub and all is clear to me how it works and how code from each branch is getting deployed to each IRIS environment but the process to deploy is manual. My question is how can I, if possible, to utilize gti-source-control from GitLab CICD pipeline to deploy code automaticaly after PR approval instead going to the Git UI?

Thanks

0 2
0 387