We have a scenario where an ObjectScript-based production calls a lookup service (SOAP in C#) to get information used in a value-set mapping process. The results can be cached in an IRISTEMP global to prevent a network call for every value, but that can hang around for quite some time on production systems.

The next logical step would seem to be to encapsulate strategies (LRU, MRU, etc.) and eviction code into an ObjectScript class that can be reused (we are not in a position yet to leverage embedded Python).

0 2
0 110


Method Execute (args...) As %Status {
 #dim statement as %SQL.Statement
 set statement = ##class(%SQL.Statement).%New(2)
 set statement.%Dialect = "CACHE"
 do statement.prepare(query)

 #dim rs as %SQL.StatementResult
 set rs = statement.execute(args...)

My questions are: 1) how do I get the size of args **2) how to get all values of **args **3) is it possible to modify the **args?

0 6
0 114
· Mar 1, 2020
SQL Inbound Adapter Errors


I created a BS with a SQL Inbound Adapter.

Query = "SELECT rowid, fname ,lname,datesent
FROM labs

DeleteQuery = " update labs set datesent = Getdate() where rowid = ?"

KeyFieldName = "rowid"

i am getting the following errors.

"NOT assuming network disconnect error based on: Gateway failed: DropStatement."

"Skipping previously errored row '235'"

0 1
0 239

Hi all,
By using VS code, I want to copy multiple files to local directory, then sync them to server, but I can't find where local directory is stored?
In Atelier IDE, I could open a view of server and can copy the code to the project, then code is saved in the local directory. When I copy multiple files to the local directory -> choose sync in Atelier -> the code will be synchronized to the server
How to do this from VS Code?

0 14
0 525

Does InterSystems IRIS will support Visual Studio 6.0 Enterprise Edition (Visual Basic)?

We are in the process of transitioning Intersystems Cache 2017 to Intersystems IRIS 2020 version.

For terminal based applications we can able to use the same DAT file used for Cache with minor changes.

For Web based we are using Visual studio 6.0(Visual Basic). Will IRIS supports Visual Studio 6?

0 2
0 178

Quite a complex scenario we are trying to solve but should be able to understand.

We're developing a task executer that runs on a server with a certain timezone.

The tasks run every day at a defined time, but in different timezones.

We're saving in database at what time we want to execute the task, and in what timezone (don't go to the save in UTC pitfall, as with DST it will be at different times)

What I want to do if when opening a task from the database, convert 02:00 Europe/Madrid, either to UTC or to local (server) time.

0 11
0 363
· Apr 4, 2022
FTPS TLS session resumption

We are attempting to update some old FTP interfaces to use FTPS and having an issue with an outbound operation to a FileZilla server.

The connection to the the server works, however it fails to transfer files with the error "TLS session of data connection not resumed."

It appears that "TLS session resumption" is no longer optional in FileZilla Server, and I cannot find any details in the IRIS documentation about it.

Does IRIS support TLS session resumption, or know how to set up FTPS to a recent install of FileZilla Server?

0 3
0 531

Hello guys,

I'm trying to install HealthShare on a virtual machine. The original language of this virtual machine was Russian, unfortunately I don't speak Russian hehehehe.
So I changed the original language to English, but when I installed HealthShare the portal was in English, but the terminal was in Russian and during installation it doesn't show me any option to select the language.

0 2
0 110

Morning everyone,

I would appreciate some advice please- hopefully there is plenty of experts out there.

We are setting up an sFTP share between hospital trusts here in the UK and I have set the outbound operation up using a custom extension of EnsLib.HL7.Operation.FTPOperation.

We are configuring a VPN tunnel to run between the sites also so there is a bit of firewall / network routing to take place to enable the connection but to add in a complication we are on a mirrored cluster and usually present on a Virtual IP address.

0 2
0 245