All time

InterSystems is proud to announce another developer preview release, as part of the developer preview program for the 2022.3. Many updates and enhancements have been added in 2022.3 and there are also brand new capabilities, such as the new FHIR SQL Builder, improvements for Columnar Storage, and support to Oracle Linux 9 (not in this preview yet).

2 4
0 463
InterSystems Developer Community is a community of 25,876 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Question
· May 27, 2021
ERROR#5002

User antiterrorism is assigned the following SQL procedure privileges:

ERROR #5002: Cache error: <UNDEFINED>SQLUserPrivsExecute+57^%SYS.SQLSEC ^oddPROC("ENSEMBLE_ENS","BAIYAOJIREQUEST_EXTENT",27)

SOURCE ELEMENT: %CSP.UI.Component.SQLTables (SQLProcs)

0 1
0 542

Hey Developers!

This week is a voting week for the InterSystems IRIS for Health FHIR Contest!

So, it's time to give your vote to the best FHIR solutions built with InterSystems IRIS for Health.

🔥 You decide: VOTING IS HERE 🔥

How to vote? This is easy: you will have one vote, and your vote goes either in Experts Nomination or in Community Nomination.

4 6
0 423

The DeepSee Shell Best Practices Series - Example of using the MDX subquery flag in the DeepSee Shell

We have different flags for DeepSee advisors to look into the execution details and the methods DeepSee is using to do calculations.

flag [flagname] [on|off] – Turn a diagnostic on or off.

flag cmbr on|off – Show current member processing.

flag compound on|off – Show rewrite of compound queries.

2 0
0 543
Article
· Feb 24, 2024 2m read
The bewitched line terminator

I want to address the nasty problems about reading a flat text in ASCII, UTF*
explicitly excluding HTML, EBCDIC, and other encoding.
According to Wikipedia there are at least 8 variations of control characters.

  • CR+LF is typical for Windows
  • LF is typical for the Linux/UNIX world
  • CR is Mac's favorite

As you can deduct from the names the inspiration comes from mechanical typewriters.

26 0
2 542

I am inspecting our DB globals in order to reduce sizes of the worst offenders if possible. When I come to a large global, I am interested which of its nodes are the largest. Hence code below with unexpected different results. Any explanations why are results different?

1 6
0 536

As the announcement of Studio's deprecation has been made, users may be wondering about making a smooth transition to VS Code.

George James Software has extensive experience in VS Code, through regularly contributing to VS Code itself and building and maintaining a number of Extensions. This, combined with our expert knowledge of InterSystems technologies, gives us an in-depth understanding of what the process involves and means we have the unique capabilities to ensure a smooth migration from InterSystems Studio to VS Code.

We offer bespoke consultation, with recommendations that are tailored to your organization's specific needs. Alternatively, we will be hosting a monthly public webinar that is designed specifically for users migrating from Studio to VS Code.

If you're ready to make the switch and would like to find out more, please come and speak to us at the Global Summit next week - you'll be able to find George James Software in the Partner Pavilion. Our team will be happy to chat with you about how you can ensure your migration is seamless.

Alternatively, you can send me a direct message here on the Developer Community, or email us at info@georgejames.com.

8 3
0 482

Hi,

I am running InterSystems iris 2021.1 from the container and I have version 2020.1.1 is installed locally. While running studio locally I am getting below error message:

"Version mismatch. Studio version 2020.1.1 unable to connect to server version 2021.1
Upgrade to a later version of the client to resolve this error"

Looking Forward

Thanks

0 4
0 538

The pandemic that struck the world in 2020 made everyone follow the news and the numbers that involve the COVID-19.

Why don’t you take that opportunity to create something simple and pleasant, to follow the number of vaccinations worldwide?

To face this challenge, I'm using the data provided by Our World in Data - Research and data to make progress against the world’s largest problems.

They have a dedicated repository on Github with the data of COVID-19, and I took the vaccination data to help me with my tracker.

Open Exchange app
4 4
0 462

Hey Developers,

Check out the latest video on FHIR API Management:

⏯ FHIR API Management: Basic Configuration

https://www.youtube.com/embed/EYZ4dXNZNSY
[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]

⏯ FHIR API Management: FHIR Dev Portal

https://www.youtube.com/embed/9yEm7ZAZENI
[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]

⏯ FHIR API Management: Logging and Monitoring

https://www.youtube.com/embed/xcHjcBTLw8o
[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]

⏯ FHIR API Management: Security

https://www.youtube.com/embed/7ImJPCdp96A
[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]

3 0
0 542
Announcement
· Dec 28, 2017
Atelier 1.1 Release

InterSystems is ready for 2018 since Atelier 1.1 is now available as a stable release! Bring on the new year!

To subscribe to the NEW Atelier release channel, please follow the instructions on the Atelier Download page.

Stick with the beta update channel if you want to be an Atelier insider and get the latest new features and enhancements before anyone else. #VIP

With this release, you can:

7 0
0 542
Question
· Nov 19, 2017
Force inner select to be executed

I have a query that I am attempting to run, but inner query is being rolled up into the overall query - per the optimizer (and jobexam observation). While I know that if the inner query runs first, I will eliminate a number of records (making the result set smaller, and return quicker).

Just an example of what I am attempting to do:

0 8
0 534

Hi

I get always the following error when I query our FHIR repository with a specific TAG

/csp/healthshare/fhirserver/fhir/Encounter?_tag=

ERROR #5002: Cache error: <INVALID OREF>zSearch+86 ^HS.FHIR.Repository.Operations.1

I've deleted rows from cache database. On the table HS_FHIR_Repository_Resource.Encounter as we had duplicate records...

Any help would be great

Kind Regards,

Joao Palma

0 2
0 540
Question
· Jun 8, 2017
COS Expression

What is COS Expression? Is the related to SQL Expression?

Can you give a basic code or query related samples? If anyone give a sample, it's understanding easily.

0 2
0 540

the boss started using his new mac laptop, and now we are getting macintosh's own html escape characters being stored in the database especially in our text blocks, when we then print it we see things like don%u2019t instead of don't

so for example instead of the apostrophe we see %u2019 being stored. We've already noticed %u2018, %u2019, %u201C, %u201D, %2026

I'd like to replace the %u2019 with the nearest equivilent (especially when he starts to use left and right quote marks)

0 2
0 540