Dear,

From time to time I get the following error after executing a select statement:

[SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]
[Location: <ServerLoop>] InterSystems.Data.CacheClient.CacheException [SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]

After repeating the query, the query succeeds.

How do I start debugging this type of issue?

Hi folks!

Want to share a lifehack with you on ObjectScript highlighiting withing VSCode for script files.

Script files are just files with lines of ObjectScript that we feed anywhere, e.g. into IRIS during Docker baking procedure.

Typical usecase - here is the Scriptfile

here is the Dockerfile where we feed it.

And here is how it looks like usually in VSCode:

Coudl be more beautiful, right?

Hello,

First of all thanks for your time reading our question, and thanks for your replies and help

We would need to know if a patient has less than 65 years old, using their birthday from the PID 7.1

So far we have developed the following code:

Hello, first of all thanks for your time reading this question ◀️

We would need to achieve the following task:

We have a Ens.Response message with this structure:

Hi community,

This is another article about how to perform actions that you can do in the web portal but via code.

Today.... Add a business item in your production by code

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems AI contest!

Date & Time: Friday, July 30, 2021 – 11:00 AM EDT

What awaits you at this Virtual Meetup?

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

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

Dear Experts,

I have to pull out a report of certain code tables and this is my first script and I need to write many.

1. If I have to refer to the table, seeing the reference in the components with reference to SQL table and column,

can I use Select < What I need from the table>

Inner join with reference table?

I tried, I used the code table reference in the components, but I am getting errors,

If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.
​​​So @Evgeny Shvarov suggested publishing my monthly summary of reviews here in DC.
It reflects my experience with the status I found at the time of my review.

How strange this is to me. I'm querying a table against a numeric(15,2) column call max_client_resp_service. When I query max_client_resp_service > 0 or any number, I get results, but they are not always right, for example where max_client_resp_service > 5 returns values less than 5, e.g.

Hi Community,

Please welcome the new video from #VSummit20:

⏯ New & Next: Cleaner, More Comprehensive Unified Care Records

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

Hi community,

I'm going to publish several articles on how to perform actions that you can do in the web portal but via code.

Today.... Web Applications via code

Is there a shorter way than

$P($ZD($H),"/",3)

?

SR Software Engineer – HealthShare