Nueva publicación

検索

Pregunta
· 2 mayo, 2025

SQLCODE: -99 when executing dynamic SQL on specific properties

#SQL #InterSystems IRIS

Hi, I am unsure how to remove this restriction; when I am performing dynamic SQL using ##class(%SQL.Statement).%ExecDirectNoPriv(, .query, args...)

It works fine, but the moment I add specific properties from the persistent class I am performing the select on into the WHERE clause, I get: ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation. Despite using %ExecDirectNoPriv, I've tried with prepared statement as well, exact same situation.

I have read that it is possible to set privileges on individual properties on a persistent class, but I have no clue where to remove or change these privileges; the only solution I found is to add the role %All to UnknownUser, but that is not a fix but despite attempting to add full privileges for the persistent class for UnknownUser, I keep getting this privilege error.

5 comentarios
Comentarios (5)3
Inicie sesión o regístrese para continuar
Pregunta
· 2 mayo, 2025

IRIS Multiple Instance on a single Linux VM - status

#TrakCare

I have a Linux server that has multiple instances installed on it (according to my documentation).

What is the best command to show:

- what instance are installed?

- what instances are running?

I did run 'iris list' but it shows only one instance.

3 comentarios
Comentarios (3)1
Inicie sesión o regístrese para continuar
Pregunta
· 2 mayo, 2025

is this possible to call routines(.mac) directly in java?

#Java #Caché

Hello, we are currently using the Cache Database released in January 2018.

There are no specific classes or SQL mappings in the namespaces where data is stored.

Only a few routines(.mac) and stored data are in the global area.

In this case, when accessing the Cache DB through Java, is it essential to write SQL mappings or wrapper classes? The reason I ask is that our team doesn't have advanced developers who specialize in Cache.

Alternatively, is it possible to directly call pre-existing routines from Java?

I apologize for the translation;

2 comentarios
Comentarios (2)3
Inicie sesión o regístrese para continuar
Pregunta
· 1 mayo, 2025

What does S $ZT="^%ETSDK" mean in MUMPS / InterSystems ObjectScript?

#Backup #Caché #InterSystems IRIS for Health

Hi all,

I'm reviewing an older Cache routine and came across this line of code: from file ^ZDBKCRON

S $ZT="^%ETSDK"

Error trap

/home/oper/script/cache_db_backup -t        # Daily CacheDB Backup

 produced the following output:

 <NOROUTINE> *%ETSDK
<ERRTRAP>

-----------

From what I understand, this is setting up an error trap, but I'm not entirely clear on how it works, especially in modern InterSystems IRIS environments.

Could someone please help explain:

  1. What exactly does this line do?
  2. Is %ETSDK a standard system routine? I can't find it in our environment.
  3. What is the best practice for error trapping now — should we be using $ETRAP instead of $ZT?
  4. How can I safely replace or modernize this code?

Any guidance is appreciated!

2 comentarios
Comentarios (2)2
Inicie sesión o regístrese para continuar
Anuncio
· 1 mayo, 2025

Developer Community Recap, April 2025

#Resumen #Comunidad de Desarrolladores Oficial
Hello and welcome to the April 2025 Developer Community Recap.
General Stats
✓ 143 new posts published in April:
  – 33 new articles
  – 35 new announcements
  – 66 new questions
  – 9 new discussions
✓ 316 new members joined in April
✓ 14,851 posts published all time
✓ 16,004 members joined all time
Top posts
Top authors of the month
Articles
#InterSystems IRIS
Hey chat, what's up with my Interoperability
By Dmitry Maslennikov
How to get server/instance info
By Kurro Lopez
Ask your IRIS classes with Ollama, IRIS VectorDB and Langchain
By Yuri Marx Pereira Gomes
Command the Crew
By Henry Pereira
Note about the StayConnected setting for TCP adapters
By Hiroshi Sato
Part I: Studying for IRIS Developer Professional Certification with the "Ask Developer Community AI"
By Yuri Marx Pereira Gomes
Part IV: Studying for IRIS Developer Professional Certification with the "Ask Developer Community AI"
By Yuri Marx Pereira Gomes
Part III: Studying for IRIS Developer Professional Certification with the "Ask Developer Community AI"
By Yuri Marx Pereira Gomes
Part II: Studying for IRIS Developer Professional Certification with the "Ask Developer Community AI"
By Yuri Marx Pereira Gomes
SQL statistics with Grafana, InfluxDB, and Telegraf
By Lorenzo Scalese
Lifting InterSystems IRIS to the Cloud: Migration Options
By Developer Community Admin
Setting Up an ODBC/JDBC Linked Table Connection to MySQL from Iris
By Dimitri Olchanyi
InterSystems for dummies – Machine learning
By Kurro Lopez
When to account for useIrisFsGroup in your IKO Deployments
By Ariel Glikman
Thoughts on Coding with GenAI
By Timothy Leavitt
Mini Tip of the Day - Preloading the License into the Docker IRIS Image
By Luis Angel Pérez Ramos
GPG Interoperability Adapter for InterSystems IRIS
By Eduard Lebedyuk
Considerations when Migrating from Oracle, MSSQL etc to IRIS
By Irene Mykhailova
Testing Metadata Inconsistencies in InterSystems IRIS Using the DATATYPE_SAMPLE Database
By Andreas Schneider
Set, Get, and Don't Fret with JSON
By David Hockenbroch
Generating an ObjectScript Class from JSON Response Using ChatGPT
By Jean Millette
Testing Metadata Inconsistencies in InterSystems IRIS Using the DATATYPE_SAMPLE Database (Part II) - Silent Corruption
By Andreas Schneider
Response times when using Dynamic and Embedded SQL
By Irene Mykhailova
Minimum IRIS container footprint
By Jose Ruperez
 
#InterSystems IRIS for Health
 
#Other
 
#HealthShare
 
Announcements
#InterSystems IRIS
Langchain IRIS Tool - YouTube Video
By Yuri Marx Pereira Gomes
Alert: InterSystems IRIS 2024.3 – AIX JSON Parsing Issue & IntegratedML Incompatibilities
By Daniel Palevski
[Video] Building Smarter Applications with InterSystems IRIS
By Anastasia Dyubaylo
[Video] Embedded Python Best Practices and News
By Anastasia Dyubaylo
[Video] Integrating DBT and Apache Airflow with InterSystems IRIS
By Anastasia Dyubaylo
Code Your Way to InterSystems READY 2025
By Anastasia Dyubaylo
Python developers, be heard!
By Raj Singh
[Webinar] SQL Cloud Services
By Anastasia Dyubaylo
Early Access Program: OAuth2 improvements
By Andreas Dieckow
Maintenance Releases 2024.1.4 and 2023.1.6 of InterSystems IRIS, IRIS for Health, & HealthShare HealthConnect are now available
By Daniel Palevski
[Video] A Whirlwind Tour of the Analytics Buffet
By Anastasia Dyubaylo
[Video] Modern Observability with InterSystems IRIS & Open Telemetry
By Anastasia Dyubaylo
 
#Developer Community Official
 
#Open Exchange
 
#Learning Portal
 
#IRIS contest
 
#Global Masters
 
#InterSystems IRIS for Health
 
#Summit
 
#Supply Chain Orchestrator
 
#HealthShare
 
#InterSystems Ideas Portal
InterSystems Ideas News #21
By Irène Mykhailova
 
Questions
#InterSystems IRIS
S3
By Touggourt
GENERATE JWT / OAUTH2.0 SIGNATURE
By Sanjib Pandey
How to create a custom scheduler
By Saman Marasinghe
IRIS Terminal remote connection
By Touggourt
Trying to add #include %occErrors at the beginning of a class declaration fails because VS Code flags it as an error and won't save it
By Nuno Almeida
Query variable column names
By Touggourt
Go to Definition or Go to Declaration - what's the difference in VSCode?
By Evgeny Shvarov
How to convert persistent object to dynamic object
By Evgeny Shvarov
Best Practices for Git Integration with Developer Namespaces in IRIS
By Alex Efa
Validate XML message against XSD schema
By José Francisco Jodar
One property crashes IRIS query
By Jerry Petrole
Performant SQL For Paging Results (DataTables, Select2, etc.)
By Michael Davidovich
Subroutine execution issues in WorkMgr
By Ashok Kumar T
IRIS xDBC protocol is not compatible error while python execution
By Ashok Kumar T
Assigning a business host setting to a section
By Otto Medin
MAXSTRING %ToJSON()
By Michael Davidovich
SourceControl errors
By Patrik Spisak
Error in iris-rag-demo
By Oliver Wilms
Global mapping priority
By Touggourt
Tasks to production
By Touggourt
My AI use case - need help with Ollama and / or Langchain
By Oliver Wilms
Field Validation on INSERT error installing git-source-control
By Steve Pisani
What the heck is a "Reentrant request"?
By Julius Kavay
Linked Stored Procedure Call - Need Results to populate further logic
By Scott Roth
Confusing container tags on containers.intersystems.com
By Andreas Schneider
IntegratedML
By Touggourt
Debugging %Net.HttpRequest
By Michael Davidovich
Using CCR with Angular Applications
By Ali Nasser
web applications definitions syncing between primary and backup nodes
By Feng Wang
Setting Python
By Touggourt
Which DB Resource to provide to a web application related role for a deployed app?
By Evgeny Shvarov
I want to use ollama and IRIS for my AI use case - How do I connect to ollama?
By Oliver Wilms
Struggling with a SQL SELECT that is returning multiple searchable rows
By Scott Roth
Code Tables vs Cache SQL Tables in HealthShare Provider Directory
By Scott Roth
SQLCODE 25 - Input Encountered after end of query
By Touggourt
WorkMgr execution issues
By Ashok Kumar T
How to access a stream property in a SQL trigger
By Pravin Barton
What is the REAL content of $THIS (because it seems, $THIS is not always the expected $THIS)?
By Julius Kavay
Clearing Web Sessions from Terminal
By Jeffrey Drumm
 
#InterSystems IRIS for Health
ErrException: zOutputToIOStream+^EnsLib.HL7.Message
By Scott Roth
%OSCertificateStore use windows- Trusted root only
By Mark OReilly
REST application gets 403 Forbidden
By Oliver Wilms
OAuth2: Retrieve access_token and prevent login if it's valid
By Laura Blázquez García
Download intersystems IRIS 2024 releae software
By Amit Gandhi
HL7 add OBX segment at specific locations - Resolved
By Gary M Lusso
Business Rule Editor - Using Foreach Action and how to account for the counter
By Scott Roth
HL7 control characters showing up - resolved
By Gary Lusso
Does deleting a StreamContainer delete the contained Stream Object?
By Julian Matthews
Setup IRIS for Health (HL7 & FHIR)
By Rushi Chandel
How to Output from a DTL Transformation in EnsLib.EDI.XML.Document?
By Nimisha Joseph
HL7 , renumber the OBX 4 -resolved
By Gary Lusso
FTP Inbound Errors
By Thembelani Mlalazi
HL7 DTL formatting
By Gary M Lusso
Error when trying langchain-iris-tool
By Oliver Wilms
Problem with ollama container in langchain-iris-tool
By Oliver Wilms
Connection URL from Python to IRIS
By Oliver Wilms
DTL help - resolved, great help
By Gary Lusso
Special character appearing in downstream system but not seen in HL7 message.
By Martin Browne
In the rule's when condition(), how can I get the EffectiveEndDateTime of the parent ruleset?
By Will
 
#HealthShare
 
#Other
 
#Ensemble
 
#Caché
 
Discussions
April, 2025Month at a GlanceInterSystems Developer Community
Comentarios (0)1
Inicie sesión o regístrese para continuar