Where are the SQL Show History entries for each user stored?

InterSystems has corrected an issue that can cause InterSystems IRIS® and Caché to not take advantage of large pages for shared memory on Windows, even though these products report that large pages are allocated. This can have detrimental effects on system performance.

The issue results from a change in Windows 10 that requires modification of InterSystems IRIS® and Caché. Note that this issue also affects all InterSystems products that are based on InterSystems IRIS® or Caché.

Hi Community,

Welcome to the second InterSystems Spanish technical article writing competition! Write an article in Spanish on any topic related to InterSystems technology:

🏆 2nd Spanish Téch Article Contest 🏆

Duration: February 6 - 28, 2023

Prizes for everyone: Everyone who publishes an article on Spanish Dev Community during this period will receive a special prize!

Several main prizes included!

➡️ Full details can be found in the original post.

Out of curiosity, I was looking in ^ROUTINE global to see how routines are stored internally.

I found out that lot of nodes are displaying "~pointer" as associated value (eg: instead of a string).

What are those pointers ? My guess is that it references some cache internal structure (eg: some nodes inside a B-Tree).

Is there a easily way to see what is behind ? Are pointers useful for user globals or is this something purely internal to Cache database ?

Hi Community,

A long time ago, I create a package for a String datatype that works with Regular Expression. It is quite a simple solution.

This can work well with packages like the OpenAPI-Suite, where you can then use the "Regular Expression String" as the type for properties of the validator objects where the Swagger contained a Regular Expression.

I am proposing we start a common package of datatypes for use. The package name to use can be provided by the admins.

The old package of mine can be removed, as it is also on a very old git profile on an email I no longer have.

Have a iris.dat file that was zipped in axis but , now I unzipped it and can see the file in my c drive but when I go to iris management console to perform a new db to pull in the current iris.dat file , in the wizard I do not see the iris.dat file listed.

Need some help with getting it restore the Cache backup in my iris community edition. 

thank you,

This error I am getting when I am updating cache.dat file:

02/13/23-22:38:11:880 (3444) 3 Error: ERROR #5002: Cache error: <FUNCTION>LoadDLLs+27^STU - Shutting down the system. 

This error I am getting whenever I am compiling any of my production or compiling Enslib.HL7.Adapter.TCPOutboundAdapter

#5002: Cache error: <SUBSCRIPT>ConstructCompileTree+72^%occInherit ^oddCOM("")

Can anyone help me with this ? 

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems Startup Accelerator Pitching Sessions @ Global Summit 2022

XData blocks in Caché classes has a MimeType property, and dcoumentation says

MimeType — The MIME type (more formally, the internet media type) of the contents of the XData block. The default is text/xml

But unfortunately I can't set any other values, such as text/html or application/javascript, because XData still expect only XML. 

So, question is, for what reasons this property was appeared?

It would be very usefull to set in this property anything other then text/xml, and Studio would highlighted it as developer expected.

Hi Community,

I would like to take advantage of our topic on capture for Health Data Warehouses (on DC-FR) to show you how to quickly create HTTP SOAP and REST clients. IRIS, as well as applications available on Open Exchange offers solutions to generate them from a WSDL or a swagger specification.

SOAP client

Nothing could be easier than creating a SOAP client. All you need is the WSDL.A wizard is available from the IRIS Studio. It allows you to generate not only your classes for a web service client but also the “Business Services” and “Business Operations” if you want to consume them with the interoperability framework.

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on Github when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you did a major change and expect a changed review just let me know.

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems Developer Tools Contest – a great opportunity to have a discussion with the InterSystems Experts team as well as our contestants.

Winners' demo included!

Date & Time: Thursday, February 16, 5 PM GMT | 12 PM EST 

Is it possible to retrieve the SQL-Executing process ID (PID) from a process spawned from a UNION %PARALLEL? I have a value set in the SQL-Executing process that I need to replicate in the UNION %PARALLEL spawned process(es). The SQL-Executing process writes the value to a global subscripted by its PID so determining the SQL-Executing PID from the spawned process is what I need. I expected $ZPARENT from the spawned process would hold the SQL-Executing PID but the PID returned is different.

With thanks,

Michael Hill

Hi guys,

I'm working on a project with my client.
They have a visit table which has about 7,000,000 records. The table is used in a random search page witch holds 20+ conditions to be combined.
The table is defined as below:

CREATE TABLE SQLUser.

All,

Trying to download IRIS from the left menu.

Have been getting this error:

I originally contacted support as noted in the alert on 12/20/22 and have yet to get a response. 

Any idea of how I can get the software?

Thanks!

Using InterSystems Embedded Analytics March 6-10, 2023 – Virtual   9:00am-5:00pm US-Eastern Time (EST)

This course is offered only a few times each year so take advantage of this session!

• This five-day course teaches developers and business intelligence users how to embed real-time analytics capabilities in their applications using InterSystems IRIS Business Intelligence and Natural Language Processing.
• The course presents the basics of building data models from transactional data using the Architect, exploring those models and building pivot tables and charts using the Analyzer, as well as creating dashboards for presenting pivot tables, meters, and other interactive widgets.
• The course also covers securing models, tools and elements (dashboards, pivot tables, etc.) using the InterSystems security infrastructure.
• Additionally, the course presents topics such as customizing the User Portal, troubleshooting and deployment.
• This course is applicable for users of InterSystems IRIS Data Platform, InterSystems IRIS for Health, and DeepSee.
• Register Here

Hi folks,

I am announcing a new package I have loaded on the OEX, which I am also planning on entering into the contest this month.

In a nutshell, what it offers you are the following.

• Base classes to use on Persistent (table) classes for InterSystems IRIS to keep record history  
• These classes enable the historizing of persistent class records into another persistent class when touched.  
• This provides for a full history of any record. 
• It allows for record rollback to a specific version.  
• It can automatically purge old history records.

Do you need it?

Messages.log file contains lots of useful information about IRIS. Sometimes the file gets big, and it is not easy to get to the data I am interested to review. It would be nice to jump to a specific date and time we suspect a problem may have started.

Whenever I need support from InterSystems, WRC will ask to send them messages.log file. Dependent on where IRIS is deployed, it may be cumbersome to obtain messages.log file for sending it to InterSystems.

My team works on deploying IRIS containers in Kubernetes in the cloud.

In today's fast-paced and highly competitive manufacturing industry, efficient machine communication and data exchange is essential to maximize productivity and minimize downtime. That's where MTConnect comes in. MTConnect is an open, royalty-free standard that provides a common language for communication between machines, devices, and software applications in a manufacturing environment.

Very simple, how to debug? The settings recommended in the docs don't work. I need a convenient way to keep track of what a function returns, like in other languages, by displaying it in the console.

It's well-known that Studio and probably VS Code have options to expand ObjectScript commands and functions to their full names (Ctrl-E and Ctrl-Shift-E in Studio), therefore some methods to accomplish this should exist. The question is: how to do it programmatically?

Hi Developers!

Here is the score of technical bonuses for participants' applications in the InterSystems Developer Tools Contest 2023!

Hi Developers,

This January, you posted a whopping 94 new questions on the Developer Community: 

Hi! recently I have to apply api-key validation to a web app with a lot of endpoints and I'm going to tell you how I did it in a centralized way.

I'm going to explain you how we can apply in a generic way (or not) api-key validation to all the endpoints of our web app.

For this feature I take as a template the class Base.cls of this repository iris-rest-api-template

I modified a bit this class to be able to check api-key security. The idea is that in your features you copy this class in your projects and you extend it for your own implementations.

It's not too late to strap into the DX Jetpack for VS Code, take it for a test flight, and consider voting for it.

Online demo on Gitpod is HERE.

Ignore any initial notifications about ports being opened.

The ServerDiff extension will ask for permission to reinstall itself in order to use the `quickDiff` API proposal that it relies on. Click 'Yes'.

Open the README.md by double-clicking on it, thenshow as a preview (command is "Markdown: Open Preview", shortcut is Ctrl + Shift + V).

Enjoy your flight! Comments welcome below.

Hi Community,

It's voting time! Cast your votes for the best applications in our InterSystems Developer Tools Contest:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

Hi Community,

In the first part, we describe all packages, used libraries and REST services.

Now, I would like to add some details about converter and validator services.

By default, OpenAPI-Suite sends an HTTP request to converter.swagger.io if the specification version is less than 3.0 and another HTTP request to validator.swagger.io to simplify the structure of the specification document.  

Although the usage of online utilities is convenient, in some cases it could be better to have our own instance of the converter and validator.  For example, if OpenAPI-Suite is provided on a server in an organisation for ObjectScript developers, it may be preferable to avoid requests to external services (privacy, avoid request rate limits). 

Just run: 

docker run -d -p 8085:8080 --name swagger-converter swaggerapi/swagger-converter:latest
docker run -d -p 8086:8080 --name swagger-validator-v2 swaggerapi/swagger-validator-v2:latest

Hi Community,

Please read this when you have the time and keep an open mind. Also, you are welcome to tell me it is a terrible idea.

The main reason for this post

If you look at NPM, it has 1.3 million packages. Now ask yourself, is this an achievement or a nightmare?
How many of those packages are no longer supported?
How many of those packages break compatibility on version changes?
How do you know which one to use?

Hi Community,

This article is a continuation of my article about  Getting to know Python Flask Web Framework

In this article, we will cover the basics of topics listed below:

1. Routing in Flask Framework
2. Folder structure for a Flask app (Static and Template)
3. Getting and displaying data in the Flask application from IRIS.

So, let's begin.

I just released an update of the gj :: codeSpex extension containing a new feature - Exclusions.

There's now a short video demonstrating how exclusions can help you focus on the packages you're less familiar with. The video also illustrates how with the ObjectScript Class View extension you can easily explore the inheritance of your classes.

Both extensions are members of the DX Jetpack, my entry in the 2023 Developer Tools contest. Voting closes very soon, so if you like what I've created please encourage me to do more by VOTING FOR ME here.