Hello,

I have established an ODBC connection with our client based on credentials they provided.    The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties.    However when we try to execute a query in IRIS we are getting error code -226.   I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client.   

We have tried with PostgreSQL as well as with TSQL.  Same result for each.

Has anyone seen this error before and could it be pointing me in a certain direction?

Hey Developers,

We're pleased to invite you to the upcoming webinar in Russian called "Virtual Summit + Open Exchange"!

🗓 Date & time: Febraury 16, 10:00 (UTC+3, Moscow time)

🗣 Speaker: @Eduard Lebedyuk, Sales Engineer, InterSystems 

Hi everyone, I am trying to return a cloned version of my ADT that I have made changes to in a Business Process.  So far I have the following in my process.  

&sql(Select MemberId INTO :pMemberIDval from CDSM_MemberAPI.MemberInfo where MemDOB = :ptDOB and MemLname = :ptLname and MemFname = :ptFname)

set newrequest = pRequest.%ConstructClone()

set MemberIDPID4 = newrequest.SetValueAt(pMemberIDval, "PID:4.1")

The following does return the value I am populating the clone with to the log

  set newrequestPID4 = newrequest.GetValueAt("PID:4.

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Multi-Model Contest!

Date & Time: Friday, Febraury 5, 2021 – 10:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used, bonuses, questions. Plans for the next contests.

Since some months ago we automatized source code analysis for projects on Github, so anyone with an open source project can have its code analyzed with no cost.

You only need to create the file ".github/workflows/objectscript-quality.yml" in your project with following contents:

name: objectscriptquality
on: push

jobs:
  linux:
    name: Linux build
    runs-on: ubuntu-latest

    steps:
    - name: Execute ObjectScript Quality Analysis
      run: wget https://raw.githubusercontent.com/litesolutions/objectscriptquality-jenkins-integration/master/iris-community-hook.sh && sh .

Hi Developers,

We're pleased to invite all the developers to the upcoming InterSystems Grand Prix contest kick-off webinar!

The topic of this webinar is dedicated to our mega Grand Prix contest. We invite to use IntegratedML, Native API, multi-model, Analytics and NLP, Open API and Interoperability, IKO.

In this webinar, we'll talk about the topics to expect from participants and show you how to develop, build and deploy applications on InterSystems IRIS data platform.

Date & Time: Monday, Febraury 8 — 10:00 AM EDT

Speakers:  
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

🗣 @Thomas Dyar,  InterSystems Product Specialist - Machine Learning

February 11, 2021 – Alert: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’

InterSystems has corrected a defect that can cause incomplete query results. This defect affects:

• InterSystems IRIS and InterSystems IRIS for Health 2019.1.0, 2019.1.1, 2019.2, 2019.3, 2019.4, 2020.1.0, 2020.2, and 2020.3
• HealthShare Health Connect 2019.1.0, 2019.1.1, 2020.1.0
• HealthShare Products 2019.2, 2020.1 and 2020.2

(In HealthShare and HealthShare Health Connect, this defect only affects Personal Community with 64,000 patient proxies and possibly customer-built custom queries.

Hi developers!

Recently we announced the preview of Embedded Python technology in InterSystems IRIS.

Check the Sneak Peak video by @Robert.Kuszewski.

Embedded python gives the option to load and run python code in the InterSystems IRIS server. You can either use library modules from Python pip, like numpy, pandas, etc, or you can write your own python modules in the form of standalone py files.

So once you are happy with the development phase of the IRIS Embedded Python solution there is another very important question of how the solution could be deployed.

One of the options you can consider is using the ZPM Package manager which is described in this article.

Hi Developers!

Here're the technology bonuses for the InterSystems Grand Prix Contest that will give you extra points in the voting.

Below are the details and useful links on all the technical bonuses.

Hi,

While installing IRISHealth-2020.1.0.215.0-macx64 on Mac computer I am getting the following error message.

Any suggestions please.

Thank You

===================================================================================

Updating system TEMP and LOCALDATA databases

Installing National Language support

Setting IRISTEMP default collation to IRIS standard (5)

Loading system classes

Updating Security database

ERROR HAS OCCURRED: Error in security tables, Error: ERROR #903: Domain xxx.com.

Hi folks!

Each IRIS installation has a /lib folder which is intended for 3rd-party libraries being used in the solution.

For IRIS installation the typical path is:

/usr/irissys/lib/

In ZPM the shortcut is ${libdir}.

What is the macro or internal function to obtain it programmatically?

Hi Developers!

Please welcome the new video on InterSystems Developers YouTube:

⏯ Embedding AI Services

This is a demo to make use of a simple WebSocket Client with Embedded Python in IRIS.

How to Test it

• Run an Iris Session in Docker
• Select your WebSocket Echo Server
• Enter the text you want to send or generate it
• Send it and see the result

$ docker-compose exec iris iris session iris "##class(rccpy.WSockPy).Run()"

*** Welcome to WebSocket Embedded Python Demo ***

Collecting websocket-client
Using cached https://files.pythonhosted.org/packages/4c/5f/f61b420143ed1c8dc69f9eaec5ff1ac36109d52c80de49d66e0c36c3dfdf/websocket_client-0.57.0-py2.py3-none-any.

Hi Developers,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Building REST API with InterSystems IRIS Docker Container in 5 Minutes

In the context of IKO (Iris Kubernetes Operator) the question of Service not redirecting dynamically to the correct Pod is still pending.
In production this can be dangerous since an overload (or any other simpler problem) can cause you to change the main Pod and leave the application inoperable until we intervene.

Intersystems support warned that this is still an issue of IKO, but there are some possibilities that I am studying.

Flyway is a open source product used to develop database code to migration, ddl version control, automate database procedures, etc. It is the most used product to do DevOps automation procedures to database. Do you consider create iris support to flyway?

https://flywaydb.org/documentation/contribute/contributingDatabaseSupport

Hi.

How can I add/substract hours from $Horolog in ObjectScript and the date part of $H is also affected?

Regards,

Matjaž

Hi Community,

Find out how you can use the open-source iKnow engine in Python within InterSystems IRIS.

⏯ Using the InterSystems iKnow Engine in Python

Hi,

I use terminal + dbeaver,When I open the new terminal again,  will prompt the license information.

Is this database free？

Image search like Google's is a nice feature that wonder me - as almost anything related to image processing.

A few months ago, InterSystems released a preview for Python Embedded. As Python has a lot of libs for deal with image processing, I decided to start my own attemptive to play with a sort of image search - a much more modest version in deed :-)

A tast of theory 🤓

In order to do an image search system, fist it's necessary select a set of features to be extracted from images - these features are also called descriptors.

Making a blog using Python + IRIS Globals

Since I started to use internet (late 90's), I always had a CMS (content management system) present to make easier post any information in a blog, social media or even an enterprise page. And later years putting all my code into github I used to document it on a markdown file. Observing how easy could be persisting data into Intersystems IRIS with the Native API I decided to make this application and force myself to forget a little of SQL and stay open to key-value database model.

What is a blog?

Hi,I am a novice.How to call "ClassMethod" in SQL statement？

I don't understand why it's wrong?

Hey Developers,

The InterSystems Multi-Model Contest is over. Thank you all for participating in our exciting coding marathon!

And now it's time to announce the winners! 

A storm of applause goes to these developers and their applications:

Hey Community,

We're pleased to invite you to the InterSystems AI+ML Summit 2021, which will be held virtually from January 25 to February 4! Join us for a two-week event that ranges from thought leadership to technical sessions and even 1:1 “Ask the Expert” sessions. 

The sessions will be in both German and English. And this summit is free to attend!

See details below:

Hi,

When wanting to use VS-Code for server-side editing.. - In VS-code I can right click on a server item (eg a class) to see a set of menu options including 'Server Source Control... ' and 'Server Command Menu...' at the bottom.

I noticed that these options are somewhat connected to my server-side source control hooks class that inherits from %Studio.SourceControl.Base, however, I am seeing different behavior between my custom subclass of this, and, the provided %Atelier.SourceControl subclass.

How should the subclass of %Studio.SourceControl.

Hi Community,

As you may know, this year we're holding InterSystems AI+ML Summit 2021 virtually from January 25 to February 4. All sessions, both in German and English, will be free to attend.

Let's find out more about the exciting sessions that await us and book a virtual seat today!

Check the agenda below:

Hi,How to specify column name (ddl)?

I cannot find those folders under my IRIS install dev folder.  Those were in my cache install dev folder.

Will InterSystems drop those support?  If yes, why are there some discussion about Python/Iris in this forum?

Of course, I wish IS continue to support those.

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.

If you didn't know the guys, check it out, it well worth your time.

ZPM is a fantastic package management product. I have 7 apps published and these apps not using zpm because it need install external products using apt-get install.

Is it possible do apt-get install using ZPM?