All time
Question
· Jun 27, 2024
ZF(-100) and qpdf

Hi,

I have seen your post on using qpdf with the zf(-100) function and was wondering if you could be so kind to share an example line of code. I can use pdf from the DOS command line no problems with the following:

qpdf --encrypt test123 test123 256 -- c:\test\basement.pdf c:\test\basementenc.pdf

Trying the following from the iris terminal I get a RET=2 in messages.log and the PDF is not created.

d $ZF(-100,"/logcmd", "qpdf", "--encrypt test123 test123 256 --", "C:\test\basement.pdf", "c:\test\basementenc.pdf")

Kind Regards,

Jason

1 1
2 173
InterSystems Developer Community is a community of 25,852 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

The SYS.Mirror CatchupDB() method requires a System File Number/Inode value as a parameter. I have not yet found a suitable internal method to get this value. Is anyone aware of a utility method that would do this? I do know I can get this value with a small amount of Python or by calling out to the OS. However I wanted to stick with pure Objectscript in this project if possible.

Failing in this I will use embedded python to run the line or two of Python needed to get this value.

Thank you for any hints

0 5
0 169

Hi all,

I was wondering is there is already a sample of a Helm chart or better even an IKO manifest to deploy a REGISTRY and/or EDGE container to a Kubernetes cluster.

The samples I found show how to deploy to docker using docker-compose but I want to deploy into a better runtime orchestrator.
Regards Joost

0 2
0 172

Hi Community,

I have below scenario

We have IRIS BI Reports in my application. Now these reports currently being acessed by users through dashboard url's.

I want to create a automated utility (background cache system task) which run these bi reports and export them to a specific path.

I am looking for a system method through which we can open these dashboard url's through code and export the excel report to a speciific path.

Thanks in advance.

0 1
0 173

HealthShare Unified Care Record Fundamentals

October 31-November 4, 2022 9:00am-5:00 US-Eastern Time (EDT)

  • This 5-day course teaches HealthShare Unified Care Record users and integrators the HealthShare Unified Care Record architecture and administration tasks.
  • The course also includes how to install HealthShare Unified Care Record.
2 0
0 174

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in April 2022:

New Videos
№ Video Views
1 Creating Pivot Tables with InterSystems IRIS Business Intelligence 171
2 Containerizing InterSystems IRIS Applications 100
3 Online Meetup with Globals Contest Winners 65
4 InterSystems Globals Graph Database 51
5 Update on Intelligent Chart Review 62
6 Global Mindmaps InterSystems IRIS and Mind Elixir 57
7 Cubes Demonstration 53
8 GlobalToJSON AEC 37
9 GlobalWrite ePy vs ISOS 13

0 0
0 174

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in March 2022:

New Videos
№ Video Views
1 Flexible Data Modeling with InterSystems Globals 1012
2 Introducing InterSystems HealthShare Extended Decision Support 313
3 InterSystems Solutions in AWS 299
4 What is the InterSystems IRIS FHIR Accelerator Service 234
5 Poor Man's Analytics with Rich SQL 141
6 Online Meetup with Python Contest Winners 83
7 InterSystems Globals Contest Kick-off Webinar 61
8 Exploring Machine Learning with R Language Gateway 54
9 Caelestinus Healthtech incubator – Kick off ceremony 37

0 0
0 174

Strategic Interoperability

Executive Overview

This white paper discusses the critical requirements for the U.S. Departments of Defense (DoD) and Veterans Affairs (VA) to share Service members’ medical records – including real-time access to a complete composite health record – and it proposes an immediate solution via implementation of a health informatics platform. This approach will provide significant and clearly visible results in a matter of months, while positioning the Departments for strategic improvements in the years ahead.

0 0
0 174

Modern SQL engines are enormously complex pieces of software. Even when they appear stable and mature, subtle bugs can hide in their optimizers, type systems, predicate evaluation, or execution layers. These bugs rarely announce themselves loudly. Instead, they quietly produce incorrect results, behave inconsistently, or fail abruptly under specific combinations of SQL constructs.

This is precisely why tools like SQLancer exist. SQLancer automatically generates SQL queries and uses logical “oracles” to detect when a database behaves incorrectly. It has revealed hundreds of real bugs in widely used systems such as MySQL, PostgreSQL, SQLite, and DuckDB.

With this in mind, I attempted to bring SQLancer to InterSystems IRIS, starting with the NOREC oracle — a powerful method for detecting optimizer correctness issues. The journey, however, uncovered not just potential SQL correctness problems, but also a surprising number of driver-level and server-level failures that prevented SQLancer from running at full strength.

This article summarizes why SQLancer is important, how the NOREC oracle works, and what unexpected findings appeared while testing IRIS.

Open Exchange app
14 3
1 113

Hi,

Just thought I'd share quite a handy hook that has helped me out when developing on Health Connect Cloud with VS Code and GitBash. When developing on Health Connect Cloud, if changes are made directly on the server such as routing rules or component deployments, they aren't automatically included in source control, therefore you must export from the server into your local files and push to your remote repo. I'm sure there are easier methods to deal with that which I'm in the process of testing, but as a quick solution I thought it would be handy have a pre-commit hook which triggers a reminder in GitBash - see below.

6 1
1 153
Question
· Feb 26, 2025
Maximum license usage

Hello everyone

I have a question about the maximum number of active license users for CACHÉ.

When I run the command: Do $System.License.ShowCounts()

I get the following return:

1 Current active users
3 Maximum active users
0 CSP users currently active
1 Maximum active CSP users
0 CSP sessions currently in 'grace period'
1 Maximum CSP sessions in 'grace period'

0 3
0 170
Question
· Feb 6, 2025
I don't know what I did wrong.

I set up all the credentials and IP, Port, Namespace, SSL/TLS Server Name and .ini file but I still cannot connect to db. and It says

Iris ODBC][State : 08S01][Native Code 459]
[C:\Windows\system32\odbcad32.exe]
Connection via irisconnect failed:
Matching SSL server config not found in ssldefs.ini or registry

0 2
0 171

Hello,

I am currently trying to edit server side code for TrakCare using Visual Studio Code with intersystems-community.vscode-objectscript version 2.12.11-beta.1.

I can correctly check out the .mac file but when I try to either File > Save or use command 'ObjectScript: Import and Compile Current File' I get a very generic error .

I cannot find any details anywhere in the Output section.

I have reinstalled all extensions several times.

0 3
0 170

New to Python. Attempting to use pypyodbc to select data from a table in one Cache database, and inserting into a similarly configured table in another. Process works fine except for tables containing Date types. NULL values in date columns are handled without issue, but when data is present, insert fails with:

An error occurred: argument 7: TypeError: 'NoneType' object cannot be interpreted as an integer.

Source table:

0 2
0 171
Question
· Sep 19, 2024
Access Windows file server

we are trying to access a windows file server from our file adaptor, which has been setup using a Linux CIFS mount
The mount requires a user/password to access the files on the windows server. How do we get the integration engine
to pickup the right username/password?

0 2
0 171

Hi:

I have been adapting the IRIS WHIZ addon as part of the contest. I will soon fork the code on github so the changes are available.

The next phase is I am storing the date from and to time for a more complete search cache

zenPage.getComponent(36).value

it works in the chrome console ok

I'm not sure in external JS how to set the page it is on as a zenpage to use the zenpage functions

0 3
0 170

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Caelestinus 2023 – Final DEMO Day

https://www.youtube.com/embed/iw8w2BE61xY
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 173

1 0
0 173