I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created

CREATE PROCEDURE Silk.sp_InsertRecord (
IN RecordDate TIMESTAMP,
IN UserName VARCHAR(50),
IN RecordType INT,
IN RecordID VARCHAR(50),
IN CategoryID INT,
IN ApprovalDate TIMESTAMP,
IN FileSize BIGINT,
IN WorkstationName VARCHAR(50)
)
BEGIN
INSERT INTO DummyRecords (
RecordKey,
FilePath,
RecordDate,
UserName,

0 0
0 103

I have an IRIS installation that is using 8-bit charset encoding (set to deu8 / Latin 1). I would like to convert everything (database and system) to Unicode

Charset encoding is something asked during installation, is it possible to change this on the fly ? The installer clearly say that Unicode systems cannot be converted. What about 8 bit ?

Same for database : is there possible conversion ?

My current plan is the following :

0 5
0 412

I added a Response Message Class to a call in the Business Process Designer.

When i click on Response Actions or on Response Builder i get a message

"You must specify a response message class in order to add or edit response actions."

no matter which response message i choose i always get the above warning.

how do i fix this?

Thanks

0 4
0 204
Question
· Sep 11, 2024
Determine Job/Process State

Hi, I'm working on a large extraction from a database and need to parallelize the processes during the extraction.

Here's what happens:

  1. The user starts the extraction from.
  2. Several jobs are started using the Job <Method> instruction.

At the end, the user expects to find a document containing the results of all the extractions. What I'd like to do is start a new job that checks whether the previously started jobs have finished or are still working and consequently produce the document.

0 8
0 274
Question
· Oct 10, 2024
Simple Way To Compare Streams

Is there a simple way to compare Stream data between two objects?

We have used $ZCRC to create a checksum and that seems to be work.

We have also read each line of the streams and compared them and that seems to work too.

We just think there has to be a simpler way than looping through all the lines of the stream.

Any suggestions would be appreciated.

0 7
0 188

If several application servers are connected using ECP, and one of them create many locks, so many that lock table became full :

Should we expect only that application server to be impacted ? (usually, when lock table is full the system became instable). Or, are other application servers going to be impacted the same way ? (because that lock table is synchronized and maintained in sync across all servers)

0 3
0 95

I have been trying to track down an issue we are seeing in our TEST environment with Memory usage.

We have Several BP's for years now that take a HL7 message, parse it apart, and make calls to a Custom EnsLib.SQL.OutboundAdapter to have it execute Insert/Select/Update/Delete stored procedures against a MS SQL Database via JDBC connection. We are using Microsoft's JDBC 12.2 driver to do this.

What we are seeing is that IRIS.WorkQueue globals are being defined for these calls but then the IRIS.WorkQueue is not being cleaned up and taking up large amounts of Memory.

0 5
0 104

I need to execute code whenever a production component setting is updated, such as when a service port is changed and the `ens.config` table is updated. This code will handle tasks like logging these updates to a custom table for external reporting purposes.

How can I invoke custom code on these updates?

Ideally, I need to monitor all namespaces that are interoperability-enabled. Whenever a production component setting is changed in any namespace, I need to run the code.

0 2
0 89

We are doing healthcare interface development.

Developers have Ensemble installed locally on their laptops - code will be developed locally then deployed to integration, test/UAT and ultimately production servers in due course.

One of the other applications we are developing around happens to utilise an Iris desktop client to a remote Iris server. We want to have the application available on the developers laptops alongside the local Ensemble instance.

0 3
0 97

I want to try out iris-DataViz app to visualize my own data. I cloned the repo and docker-compose up -d in AWS. IRIS portal works, but on port 8051 I get nothing. I checked my AWS security groups. I reversed IRIS webserver port and 8051 and I can connect to Management portal using port 8051. I don't understand what is refusing connection on port 8051 running in iris-DataViz container.

0 1
0 86

We encountered difficulties while attempting to establish a JDBC connection to Intersystems using AZURE Databricks, resulting in an inability to retrieve data. The JDBC version utilized was intersystems-jdbc-3.3.1.jar. If anyone has successfully employed Databricks for establishing a connection, we would appreciate information regarding the libraries you used

0 5
0 362

Hi,

I tried to create what is know as a "class variable". As far as I understand the only analogy to class variables would be the "class parameters".

I tried to use a class parameter but I cannot change its value at runtime.

Parameter STATUSES = {{}};

Property repr As %String;

Method %OnNew(repr) As %Status
{
w ##class(Test...).#STATUSES
w ..#STATUSES

...

}

0 6
0 146
Question
· Sep 17, 2024
Cache-2018.1.9

Hi, Support Team

I´m working with Cache for many years, currently i have running version cache-2018.1.7.721.0-win_x64.exe

However we are facing some compatibility/requirements challenges, in that way i´m hereby request your support to provide next version/build of Cache 2018.1 (e.g cache-2018.1.9.xxx.x-win_x64.exe )

Nevertheless , I already downloaded IRIS for testing purpose if can also provide trial/limited licence for detail testing will be apreciated.

Thanks in advance for your attention.

Regards

Rajendra

0 8
0 250
Question
· Sep 25, 2024
LDAP Authentication Question

I am trying to track down a problem we saw this morning with our TEST environment. We had a momentary issue where InterSystems HealthShare Health Connect could not connect correctly to LDAP. When we tried to login and could not connect to LDAP, the system would Delete our users.

the Test LDAP function would return a "Can't contact LDAP server". I went through the Certificates, made sure they had the correct permissions and were not expired.

0 2
0 169

Hello, I need to use IRIS to connect to an MSSQL base.
It has to be done via ODBC, I can't use JDBC at this time by client option.

I am trying to use Microsoft Driver
libmsodbcsql-13.1.so.9.2

But I can't, my attempts result in:
Connection failed.
SQLState: () NativeError: [11001] Message:

I have done all DSN configuration, and my configuration is listed in SQL Gateway Connections. I know it's working, because when I run a test with isql I have the information that connects to the bank.

2 3
1 912

We have an ObjectScript application that runs in Cache' and IRIS. Our typical installation involves a .zip file containing several files necessary for the installation and operation of the application. Steps are: expand the .zip file to a folder that will not be used by the application. Do ^%RI for the installation routines in the production namespace. Do the Installation routine. We have a customer that is trying to do a silent installation. He does not want to have to respond to any prompts on the installation.

0 3
0 147