Questions tagged [intersystems-iris]

InterSystems IRIS is a complete cloud-first data platform which includes a multi-model transactional data management engine, an application development platform, and interoperability engine, and an open analytics platform.

InterSystems IRIS provides a set of APIs to operate with transactional persistent data simultaneously: key-value, relational, object, document, multidimensional. Data can be managed by SQL, Java, node.js, .NET, C++, Python, and native server-side ObjectScript language. InterSystems IRIS includes Interoperability engine and modules to build AI solutions. InterSystems IRIS provides features for horizontal scalability (sharding, ECP) and provides High Availability features, Business intelligence, transaction support, and backup.
It is commercial software but with Free Community version which could be downloaded from: https://download.intersystems.com

Official website: https://www.intersystems.com/products/intersystems-iris/

Developers Community: https://community.intersystems.com/?filter=articles

App Store: https://openexchange.intersystems.com/

42 questions
1
vote
2 answers

Purge strategy for parent-child persistent objects

We are seeing performance issues in purging objects/tables that have parent-child relationships defined. Due to the number of child objects, we're seeing a very long duration to purge a single parent and all child tables. Is there a better way to do…
1
vote
1 answer

Do I need to enable LDAP authentication for my Cache instance ot use LDAP auntentication in a single CPS application?

Currently, I am working on a CSP application that is supposed to generate reports. Users will have varying access to said reports. To achieve that, I plan to use LDAP (because it's used in other systems where those users already exist).…
1
vote
1 answer

How change namespace of Soap ns2 message in %SOAP.Webclient

I've created a soap client connection using the wizard of Atelier and it has created all messages (request and response) and the business operation object. This soap connection will be used to connecto with other SOAP Webservices (changing the URL)…
1
vote
1 answer

Can SQL queries across namespaces be made?

Is it possible to make a query across tables in different namespaces? Eg: select A.TS as A_TS, B.TS as B_TS from ns1.schema.table as A left join ns2.schema.table as B on A.id = B.id At least, is it possible to get tables A and B using the same…
dmcontador
  • 660
  • 1
  • 8
  • 18
1
vote
1 answer

facing the error “command 'vscode-objectscript.explorer.refresh' not found” in Visual Studio Code (Version 1.49.0) with IRIS 2020.1.0.215.0

I'm facing the error “command 'vscode-objectscript.explorer.refresh' not found” in Visual Studio Code (Version 1.49.0) with IRIS 2020.1.0.215.0. My settings are the following : { "objectscript.conn": { "active": true, "host": "localhost", "port":…
1
vote
1 answer

How to solve Docker for Windows permission error

I am currently facing some "permission denied"-issues with Docker for Windows 10. I am using this image: Intersystems IRIS My Dockerfile for this image is: FROM store/intersystems/iris-community:2020.2.0.204.0 Furthermore I am using docker-compose,…
1
vote
1 answer

Intersystems IRIS Data Platform cant change default password

I am currently testing the docker container for the InterSystems IRIS Data Platform. I want to change the default password with this line (from dockerhub instruction:…
Celebrombore
  • 170
  • 11
1
vote
1 answer

How does Intersystems cache recall the covered code

I drag my .cls file to Intersystems studio, the old version code covered my latest version code, is there any way to get back my covered cls file ?
DylanLeeee
  • 31
  • 1
0
votes
0 answers

No columns were bound prior to calling SQLFetch

I am currently working on a project with the following techstack: Database: Intersystems IRIS Controller: PHP/PDO with IdiORM The problem is that the IDs are not in a common format. For example: ABX||242149||1||0||D So there are different keys…
0
votes
1 answer

Python - Unable to connect to 2 different databases like hive and iris in same python program

I am trying to connect to hive database and IRIS Intersystems Databases using jaydebeapi in python. I am able to connect to one database at a time. While trying to connect to other database, I am getting the below error "Class…
0
votes
1 answer

Intersystems Cache not generating data with Populate

Hello) I'm having a problem generating data in IRES, I'm using %Populate class inheritance, as well as the Popsec and VALUELIST properties. Here is my class: Class User.Car Extends (%Persistent, %Populate) { /// Description Property Brand As…
K_V_G
  • 3
  • 1
0
votes
1 answer

How to set up IRIS database with Quarkus

I'm trying to use Intersystems IRIS Database with Quarkus, but I'm getting problems making it work does anyone knows how to set up the Intersystems IRIS Database on Quarkus ? I did that on my pom.xml and also I added the…
0
votes
1 answer

How to concatenate and format date and time to timestamp/datetime in Intersystems Caché database

Utilizing the Intersystems Cache documentation and my limited SQL knowledge, I have figured out that Cache has it's own internal way to turn datetime into a six digit integer, but I can't figure out how to get it back to a human understandable…
0
votes
1 answer

Working with different timezones with Intersystems

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…
Mathew
  • 41
  • 5
0
votes
1 answer

How to export class to xml without namespace?

I am using IRIS (Intersystems) and trying to export a class to xml and remove the tag "xmlns" from mother class. These are my classes to create the XML. Class Test: Class Class.Test Extends (%RegisteredObject, %XML.Adaptor) { Parameter NAMESPACE =…