#InterSystems IRIS

Hi.

How can I prevent the error:

2024-12-27 08:05:46 [SQLCODE: <-400>:<Fatal error occurred>] [Error: <<READ>XDCall+9^%SYS.DBSRV>] [Location: <$system.IO server loop>] [Client info: <Username: Operator, Node Name: PM_MIP_SRD01, IP Address: 10.40.1.108, Executable Name: Operative.dll, Internal Function: KÂ>] [%protocol: <65>] $Id: //iris/2023.2.0/kernel/common/src/sysio.c#2 $ 3514 121

It seems that this error occours when connection on PDA is lost and established again.

Tnx.

Regards,
Matjaž

Hello everyone,

I'm trying to get back into shape with IRIS. My current goal is to practice with ObjectScript and VS Code. I installed both on my Mac, and everything worked like a charm—perhaps that's why I'm still a big fan of Unix.

Hello guys,

I need to tranform columns into rows or rows into columns.

I'm using only SQL Cache.

The code:

SELECT
    codRepresentante
    ,vendasAbril
    ,vendasAgosto
FROM
    Ped.MetasRepresen
WHERE ano = 2024

The columns:

I need to do an audit of Linked tables which are using a specific SQL Gateway connection, and there are many.

This is defined by the parameter CONNECTION contained within the table class which extends Extends %Library.Persistent

Is parameter exposed within a table somewhere?

I got this error

Connection via irisconnect failed:
Matching SSL server config not found in ssldefs.ini or registry

and I put the ssldefs.ini file on C:\Program Files (x86)\Common Files\InterSystems\IRIS

why I still have this error?

Import from DC-PT, @Edilson Eberle Carvalho

We have some *.mac routines and we need to preserve their source,
as these routines have intellectual authorship and can only be used per session
with the right to use (they cannot be viewed or edited).
The question: how to keep only the routine object in the IRIS namespace,
without interfering with its execution?

Hi ,

I have a scheduler task and an associated class that works.

Class Sample.Util.CreateTask Extends (%SYS.Task.Definition, %Persistent)
{

Parameter PROPERTYVALIDATION = 1;

Parameter TaskName = "Sample.Util.CreateTask";

Method OnTask() As %Status
{
// Perform the logic
}

}

Is there a way to Enable or Disable the above task "CreateTask()" from an external function/Method/class ?

Hello,

I'm trying to add another segment to an HL7 MDM message. More specifically OBXgrp(1).OBX. The addition itself works,. When I look at the message in the trace, the segment with the content can be seen. However, it is not displayed as an OBX segment.

Build Map Status = 'ERROR <EnsEDI>ErrMapRequired: Missing required OBXgrp(1) element at segment 6'
'ERROR <EnsEDI>ErrMapSegUnrecog: Unrecognized Segment 6:'' found after segment 5 (TXA)'

Hi All,

How can I customize the file path of my FTP outbound adapter.

I have a custom business operation that extends "EnsLib.FTP.InboundAdapter", in which I need to update the file path of my FTP server location.

I have the need to query an external database and write the result set/snapshot to an internal %Persistent [ DdlAllowed ] table that I built. I have built inbound SQL Services before and write them externally to replace SSIS jobs, but how would querying a database via a Service and writing the data to an internal table work?

Can I just take the inbound query structure and write it to the class file of the internal table in a DTL? If so, what would be the Target? Or does this need to be done within a BPL as a Code block?

I already mentioned in a Previous post I am trying to build a list from a repeatable field within a HL7 message. I figured out how to build the list by using a context list string variable within the Business Process (BPL) and doing a

For some build scripting with the InterSystems Package Manager, I'd like to first uninstall a package with `zpm "uninstall"` and then load it from disk using `zpm "load"`. That way anything that got deleted from the source will also be deleted from IRIS.

The problem is that `zpm "uninstall"` takes in a module name and I only have the directory path to the package source. Is there a way to get the module name for an installed IPM module given the source path? It's okay to assume that it has previously been installed from that same directory with `zpm "load"`.