Search

Hi Developers! Here in Developers Community, we have posts, which are categorized by tags. Tags - are specific topics, which relate to InterSystems products, InterSystems services, or any concept related to software development, deployment, or maintenance etc. Tag is a helpful thing because it gives the option to follow/subscribe to the tag, filter the search by the tag, understand how popular or not unpopular the topic and more. And we have a problem! Actually two problems. The tags for the post are selected by the author of the post, and we have the following issues: the author chooses wrong tags for a post, and the post lacks proper tags. And we think this problem could be solved with AI/ML approach and so we suggest you solve it during the InterSystems IRIS AI Contest. Here is the posts-and-tags repository, which uses the Python Gateway template, which contains two classes: Community.Post and Community.Tag. Clone it or Fork it and run: $ docker compose up -d and it will build an InterSystems IRIS image and will load these two classes along with data from Post and Tag globals. Community. Post class contains the data on all the developer community posts with fields: Name - for the post title, Text - for the post text, Tags - for the comma-separated list of tags. You can get the data with the following SQL query: select top 20 * from Community.post order by id desc And you can get posts which have the particular tag with the query: SELECT * FROM Community.Post WHERE ($LISTFIND($ListfromString(Tags,','),'Contest')>0) ORDER BY ID DESC Community.Tag class contains tags and its descriptions. The task Find the optimal set of tags, for every post which matches the text of the post. Two hypotheses how this could be solved: 1. Find a matching tag for the post upon the tag description. Every tag has a description, which could match the title and content of the post. 2. Find proper tags considering that the majority of choices from authors are the right choices. So if text similar to some post, it can have similar tags. Looks like a typical data categorization problem, right? Also, it would be great to introduce new tags which we probably missed but we have posts which could be represented by these tags. I'm not a data scientist so probably this problem can be solved with some professional approach. Maybe iKnow - InterSystems NLP engine can be used here too. Anyway: we have the problem, we have the data, and possibly we could find a solution using InterSystems IRIS. We are looking forward to see your solutions! Great! I was working on a webcrawler to take the posts... now we have the data =) Hi! Exploring the tables, the post table has this Column HasCorrectAnswer. Do you have the replies of each post too? Would be useful to explore these data and compliment my classificators.

In this article, we'll talk about an application that I use every day when monitoring applications and integration solutions on the InterSystems IRIS platform and finding errors when they occur. While looking for a solution for logging object changes in InterSystems IRIS, Ensemble, and Caché DBMS, I came across a great article about [logging with macros](https://community.intersystems.com/post/logging-using-macros-intersystems-cach%C3%A9). Inspired by the idea, I forked the project the paper had described and adapted it to some specific needs. The resulting solution is implemented as a panel subclass, %CSP.Util.Pane, which has the main window for commands, the Run button, and enabled command configuration. This application enables viewing and editing global arrays, executing queries (including JDBC and ODBC), emailing search results as zipped XLS files, viewing and editing objects, as well as several simple graphs for system protocols. The apptools-admin application is based on jQuery-UI, UiKit, chart.js, and jsgrid.js. You are welcome to have a look at the [source code](https://openexchange.intersystems.com/package/apptools-admin). ###Installation All installation methods are described in detail in the repo. However, the simplest approach is to use the package manager command: ``` zpm "install apptools-admin" [apptools-admin] Reload START [apptools-admin] Reload SUCCESS [apptools-admin] Module object refreshed. [apptools-admin] Validate START [apptools-admin] Validate SUCCESS [apptools-admin] Compile START [apptools-admin] Compile SUCCESS [apptools-admin] Activate START [apptools-admin] Configure START http://hp-msw:52773/apptools/apptools.core.LogInfo.cls http://hp-msw:52773/apptools/apptools.Tabs.PanelUikitPermissMatrx.cls?autoload=Matrix [apptools-admin] Configure SUCCESS [apptools-admin] Activate SUCCESS ``` The first suggested link must be opened in the address field of the browser. And in the loaded panel enter `?` and press the "Execute" button. The application then displays command examples.  ###Commands In the panel, you can run utilities, view and edit globals, and execute queries. Each launch is saved in history in the context of the namespace, so it can be found and repeated. In this context, the word "launch" means starting the execution of commands, and commands will mean everything that we enter in the panel. This screenshot shows an example of a global array `^%apptools.History` view command  As you know, automatic error detection and notifications can be handled by popular solutions like Prometheus. But often the severity of errors can be assessed visually. Very often I need to quickly get information about bugs in production in all namespaces. For this, I implemented a utility: `##class(apptools.core.Production).FindAndDrawAllErr` This starts a daily search request for errors for each namespaces that contains working products, and allows you to view these errors with a quick transition to visual tracing. You can run this utility like any others in the apptools panel with the `xec` prefix.  All useful commands can be memorized in the global extensions, in the context of the scope, to be found and repeated at any time.  ###Globals A large part of the apptools-admin application is dedicated to working with globals. Globals can be viewed in reverse order, as well as by applying a filter on both the link and the data. The displayed notes can be edited or deleted.  You can enter the `*` wildcard after the global name to get a list of globals with additional characteristics. A second `*` will add a new field, Allocated MB. A third one will add the Used MB field. This syntax resolves to a Union of the two reports, and the asterisks divide the report that is typically rather long into manageable sections.  When you get a report as a list of globals (in the screenshot above), you can follow the active links to view the global itself. You can also view and edit the global in the standard way from the management portal, by clicking `R` or `W` in the `Permission` field. Quite often, writing to the global is used to log the states of variables and objects when debugging a project. I use special macros for this: `set $$$AppL("MSW","anyText")=$$$AppObJs(%request)` In this example, `$$$AppL` forms a link to a glob with the `^log` prefix, and the date and time in the index value. `$$$AppObJs` is the object serialization macro.  You can view the protocol global in the panel, and the object can be displayed in the window fully formatted. ###Query The function that sees almost as much use as globals is query. You run this function by entering a statement as a command. For example, you can perform an SQL statement.  You can also save the result in the global `^mtempSQLGN`.  Subsequently, the saved result in the global can be displayed in the panel.  ###Converting Reports to Excel Format One of the things that was missing in the standard management portal was the ability to execute queries configured in the database JDBC or ODBC sources, output the results in XLS format, and then archive and send the file via email. To achieve this in the application, you simply select the Upload to Excel file checkbox before executing the command. This feature saves a lot of time in my daily routine, and allows me to successfully incorporate ready-made modules into new applications and integrated solutions.  To enable this functionality, you first need to configure the path for creating files on the server, user credentials, as well as the mail server. For that, in turn, you need to edit the nodes of the global program settings, `^%apptools.Setting`.  ###Saving Reports Globally Quite often, you need to save the results of a report execution to the global. For this, you can use these procedures: | | functions | |------------------------------|---------------------------------------------------------------------| |For JDBC: |##class(apptools.core.sys).SqlToDSN | |For ODBC: |##class(apptools.core.sys).SaveGateway | |For SQL: |##class(apptools.core.sys).SaveSQL | |For Query: |##class(apptools.core.sys).SaveQuery | For example, using the `##class(apptools.core.sys).SaveQuery` function, saves the result of the query `%SYSTEM.License:Counts` to the global `^mtempGN`.  You can then display in the panel what you’ve saved with the following command: `result ^mtempGN("%SYSTEM.License:Counts", 0)` https://lh5.googleusercontent.com/KCIekwZw3guq79GWxVdHYdAbWQc4u97-dr-hWT26lYE2oEzUTSkwCE4ki1zvNqRFBg6dKQshSqcy3YSgUbjFKgX3v7Ecpa5Bm_NEQuZhP8Fn8p1gzrmAdTR-Cg9jBeVcNWGukW3a ###Enhanced Functionality Modules What else simplified and automated my work? Changes that enabled me to execute custom modules when forming a query string. I can embed new functionality into the report on the fly — like active links for additional operations on the data. Let’s see some examples. We display the query result in the browser using the function: `##class(apptools.core.LogInfoPane).DrawSQL`  Let's add the word marking function `##class(apptools.core.LogInfo)`.MarkRed to parameter 5.  In the same way, you can supplement the output with additional features, for example, active links or tooltips. The globals editor in this solution is implemented according to the same principle. Here's a list of functions for outputting globals and queries in tabular form: | | functions | |---------------------------|----------------------------------------------------------------------------------------------------------------------------------------| |For globals: |##class(apptools.core.LogInfoPane).DrawArray("^mtempSQLGN") | |For SQL: |##class(apptools.core.LogInfoPane).DrawSQL("select * From %SYS.ProcessQuery") | |For Query: |##class(apptools.core.LogInfoPane).DrawSQL("query %SYSTEM.License:Counts") | |For global result: |##class(apptools.core.LogInfoPane).DrawSQL("result ^mtempSQLGN") | Working with the apptools.core.Parameter Class This link will open the CSP application in a browser in the context of an instance on which apptools-admin is installed: `http://localhost:52773/apptools/apptools.Form.Exp.cls?NSP=APP&SelClass=apptools.core.Parameter` Or select the active link in the panel.  The CSP application will be loaded for editing instances of stored classes, in this example: `apptools.core.Parameter.`   ###Creating a apptools.core.Parameter via the Table Navigator If you open this link in a browser in the context of the instance on which apptools-admin is installed: `http://localhost:52773/apptools/apptools.Form.Exp.cls?panel=AccordionExp&NSP=APP` Or select the active link in the panel.  The CSP application will be loaded for navigating the stored classes with the ability to edit them.  ###An example of a simple CSP application If you open this link in a browser in the context of the instance on which apptools-admin is installed: `http://localhost:52773/apptools/apptools.Tabs.PanelSample.cls` Or select the active link in the panel.  This example also shows the ability to edit class instances `apptools.core.Parameter.`  ###Graphs To visualize database growth, the application offers a page that displays a graph of the monthly measured database size. This graph is derived from the IRIS file.log (cconsole.log for Caché) on records "Expand" retrospectively from the current day. The program traverses the protocol, finds the database extension records and subtracts the incremental megabytes from the current database size. It turns out a graph of the growth of databases. For example, the screenshot below shows a graph of events in InterSystems IRIS formed by the protocol file.  Another example below: a schedule of events in the system based on the system protocol file.log (cconsole.log).  ###Summary The application we’ve discussed in this article was designed to help me perform my daily tasks. It includes a set of modules which you can use as building blocks for a custom administrator tool. I would be very glad if you found it useful in your work. You are welcome to add your wishes and suggestions as tasks to the project [repo](https://github.com/SergeyMi37/apptools-admin).

Hi Developers! The second InterSystems Online Programming Contest is over. Thank you all for participating in our IRIS Competition! As a result - 7 great apps! And now it's time to announce the winners! A storm of applause goes to these developers and their applications: 🏆 Experts Nomination - winners were determined by a specially selected jury: 🥇 1st place and $2,000 go to the iris-history-monitor project by @Henrique 🥈 2nd place and $1,000 go to the Production Manager project by @Nikolay.Soloviev 🥉 3rd place and $500 go to the JSON-Filter project by @Lorenzo.Scalese 🏆 Community Nomination - an application that received the most votes in total: 🥇 1st place and $1,000 go to the iris-history-monitor project by @Henrique 🥈 2nd place and $500 go to the simple-spellchecker project by @henry Congratulations to all the participants! Thank you for your attention to the contest and the efforts you pay in this exciting coding competition! And what's next? A whole series of programming contests awaits InterSystems Developers! Join the next IRIS Contest already in May! ➡️ More details in this post. Hi!Congrats for your victory @Henrique and all nominate @Nikolay.Soloviev, @henry! Thanks to the community team for their advice and @Evgeny.Shvarov for his help and availability. Thank you for your votes! Hi, Thanks @Lorenzo.Scalese ! Congrats to all participants and special thanks for this community for the incredible support Thanks @Lorenzo.Scalese and congrats for the JSON-filter and the deserved nomination Congrats to all participants and the winners: @Henrique, @Nikolay.Soloviev and @Lorenzo.Scalese For such incredible appsThanks to all community Congratulations @Henrique for your great achievement! Congrats to all other winners and participants for their interesting and useful contributions! Thanks, @Francisco.Ramalho ! I'm thrilled to be remembered by you. You are an inspiration for me and for those who want to bring innovation! Hey Community, You should know all the contest participants and their cool apps! Please welcome: 🔥 @Oliver.Wilms and his REST for Tasks on my Status Report. 🔥 @Sergey Mikhailenko and his project isc-apptools-admin. 🔥 @alex kosinets and his EXCEL as a REST application. 🔥 @Henrique Gonçalves Dias and his project iris-history-monitor. 🔥 @Henry Pereira and his simple-spellchecker. 🔥 @Lorenzo Scalese and his JSON-Filter. 🔥 @Nikolay Soloviev and his project Production Manager. Thank you all for your great contribution to the InterSystems' world of developers! Hi guys, We're pleased to invite you to the Online Meetup with the Winners of the 2nd IRIS Programming Contest on Friday, May 8 at 11:00 EDT! What awaits you at this virtual Meetup? Please find all the details in this post. Join us! 😉

Hello Developer Community! We are looking to better understand how our users configure and manage our products. If you have a few minutes, please fill out this quick survey https://www.surveymonkey.com/r/N2JX3TQ If you're willing to participate in an in-depth interview about your experiences, you might be eligible for a $100 gift card! Indicate in the survey that you'd like to talk to us and we will be in touch the second week in September! Feedback from real users like you in invaluable to us and helps us create better product. Thank you so much! If you have any questions, please contact me at Ksenia.samokhvalova@intersystems.com I look forward to hearing from you! Ksenia Ksenia SamokhvalovaUX Designer | InterSystemsKsenia.samokhvalova@intersystems.com

Hi Developers, We're pleased to invite all the developers to the upcoming InterSystems Multi-model contest kick-off webinar! The topic of this webinar is dedicated to the Multi-model contest. On this webinar, we will demonstrate the APIs for each data model in action. Date & Time: Monday, January 11 — 10:00 AM EDT Speakers: 🗣 @Benjamin.DeBoe, InterSystems Product Manager🗣 @Robert.Kuszewski, InterSystems Product Manager - Developer Experience🗣 @Evgeny.Shvarov, InterSystems Developer Ecosystem Manager So... We will be happy to talk to you at our webinar! ➡️ JOIN THE KICK-OFF WEBINAR Today! Don't miss our kick-off webinar! ➡️ JOIN THE WEBINAR HERE Hey Developers, The recording of this webinar is available on InterSystems Developers YouTube! Please welcome: ⏯ InterSystems Multi-Model Contest Kick-off Webinar Big applause to our speakers! 👏🏼 And thanks to everyone for joining our webinar!

Hi Developers! Here're the technology bonuses for the InterSystems Multi-Model Contest that will give you extra points in the voting: InterSystems Globals (key-value) InterSystems SQL InterSystems Objects Your data model ZPM Package deployment Docker container usage See the details below. InterSystems Globals (key-value) - 2 points InterSystems Globals are multidimensional sparse arrays that are being used to store any data in InterSystems IRIS. Each Globals node could be considered a key, which you can set a value for. InterSystems IRIS provides a set of APIs, including ObjectScript commands and Native API to manage Globals. Tools: Managing globals in the management portal Documentation: Using Multidimensional Storage (Globals) Using Globals Articles: Globals are Magic Swords for managing data The art of mapping Globals to Classes Videos: Globals QuickStart You can collect 2 points for using Globals via ObjectScript or Native API in your InterSystems SQL - 2 points InterSystems IRIS provides SQL access to data via ObjectScript, REST API, JDBC. Tools: VSCode SQL Tools DBeaver SQL in Management Portal Other SQL tools Documentation: SQL Access InterSystems SQL Reference Articles: Class Queries in ObjectScript Videos: SQL Things you should know Collect 2 bonus points by using InterSystems SQL in your application. InterSystems Objects - 2 points InterSystems IRIS provides the way to store and change instances of objects in globals via ObjectScript/REST API, Native API for Java/.NET/Node.js/Python, and XEP for Java/.NET. Documentation: Object Access Get 2 bonus points for the usage of Object Access in your application. Your data model - 2 points InterSystems IRIS can be used as a data platform that exposes your own data model API. You are able to use ObjectScript, REST API or Native API to expose your own API which provides any special data model, like Time-Series, Spatial, Graph, RDF/Triple, Column store, Document store. Introduce any of the new data-model API and collect 2 bonus points. ZPM Package deployment - 2 points You can collect the bonus if you build and publish the ZPM(ObjectScript Package Manager) package for your Full-Stack application so it could be deployed with: zpm "install your-multi-model-solution" command on IRIS with ZPM client installed. ZPM client. Documentation. Docker container usage - 2 points The application gets a 'Docker container' bonus if it uses InterSystems IRIS running in a docker container. You can collect the bonus if you use any of the following docker templates: IRIS Interoperability Template Feel free to ask any questions about using the listed technologies. Good luck in the competition! P.S. The current tech. bonus list is subject to change before the contest starts - stay tuned with the updates. Hi participants! In order to simplify the assessment for bonuses could you please include in the readme the links where your app uses a certain model type? E.g.: Object: https://github.com/intersystems-community/iris-multi-model-api-template/blob/8b3247f9dcd1e6e70274fde6bfdbe3f54ca0b95d/src/dc/Sample/MultiModelREST.cls#L85 SQL: https://github.com/intersystems-community/iris-multi-model-api-template/blob/8b3247f9dcd1e6e70274fde6bfdbe3f54ca0b95d/src/dc/Sample/MultiModelREST.cls#L95 Key-value: https://github.com/intersystems-community/iris-multi-model-api-template/blob/8b3247f9dcd1e6e70274fde6bfdbe3f54ca0b95d/src/dc/Sample/MultiModelREST.cls#L104 Hi Manager！ According to your request, I added the model corresponding link in the readme file!Hope to get technical score in the competition。 Application name：HealthInfoQueryLayer readme file：https://github.com/ZBT-95/-IRIS-/blob/main/README.md Thanks, Botai Zhang!

DataGrip is a multi-engine database environment targeting the specific needs of professional SQL developers, DataGrip makes working with databases an enjoyable and productive experience. To work with InterSystems IRIS from DataGrip you'll need to add InterSystems JDBC driver first (once per DataGrip) and after that add all your InterSystems IRIS connections. Part 1: Add InterSystems IRIS JDBC Driver 1. Go To File → DataSources 2. Go to + → Driver 3. Set Driver properties: Name: InterSystems IRIS Class: com.intersystems.jdbc.IRISDriver Add JDBC Driver file: path to /<IRIS>/dev/java/lib/JDK18/intersystems-jdbc-3.2.0.jar (version can change, also if you don't have InterSystems IRIS installed, you can download the drivers here) Add URL Template: Basic jdbc:IRIS://{host}[:{port}]/{database} (you can add additional parameters as described here) 4. Click OK to save the driver definition. Part 2: Add InterSystems IRIS Instance 1. In the same DataSources window go to +→InterSystems IRIS 2. Specify connection settings depending on your instance and click Test Connection. You'll see an error or connection successful. It it's a new local installation the defaults likely are: Host: localhost Port: 1972 User: _SYSTEM Password: SYS Database: USER 3. Click OK to save. That's it! Now you can query and explore InterSystems IRIS through Datagrip.

InterSystems US Classroom Training is now issuing digital badges for successfully completing training, and we are retroactively distributing these badges to our classroom learners since May 2020. The badges are issued through Credly, a company that manages digital credentials, and will be delivered via email, asking you to accept your new training badge shortly. If this is your first time earning a badge through Credly, you will be prompted to make an account and whether you wish to automatically accept InterSystems badges. Many learners received badges over the week - please check your emails to see if you have one waiting for you! Some courses, including custom trainings and InterSystems Change Control, are still in the works. As this is an ongoing project to transition to the digital badges, we appreciate your patience with receiving the badges. Share Your Accomplishment! Sharing your badge on LinkedIn, other social media, or via email makes your training badge public and is a great way to let others know of your achievement.

Can you please any one assist me for How to connect with the InterSystems IRIS in Java(Quarkus) version 3.0. As far as I know, there is no extension to connect directly to IRIS using JDBC from Quarkus yet but you always have the option to connect using REST or TCP. Hi, you will find here an example of Quarkus + IRIS + Hibernete : https://github.com/grongierisc/iris-orm-examples Thanks, Luis, for replying to me. In my queries, I am using Java JDK version 17 and Quarkus Platform version 3.1.0 (with the latest). Now, back to the point, which InterSystems jar version is suitable for this configuration? also we need to customise the Hibernate Dialect or no need for this version? Hello Guilaume, Thanks it's really helpful. Now I can able to connect the IRIS database. In theory you are all set. Just take for example the dockerfile. You can also read the pom.xml file to take some insperation. For example take a look how the jdbc driver is added to the project. ```xml intersystems jdbc 3.3.0 system ${pom.basedir}/lib/intersystems-jdbc-3.3.0.jar ``` To sum up, you need obviously the jdbc drive (you have one in the repo), the hibernate dialect, you also have one in the repo, for the hibernete dialet you can also have a look to the article of yuri : https://community.intersystems.com/post/using-new-intersystems-iris-hibernate-6-dialect-springboot-project. Have fun with Iris and quarkus. Maybe this article can help you: https://community.intersystems.com/post/using-new-intersystems-iris-hibernate-6-dialect-springboot-project Hello Guillaume Rongier, Can you confirm for me if the InterSystems JDBC driver is compatible with Panache Lock? Have a look at this project https://github.com/daimor/realworld-api-quarkus-irisI've migrated Realworld application made on Quarkus, to work with IRIS, it even uses CI to test it, and all tests passed Hello Dmitry Maslennikov, It's really helpful to learn how to connect IRIS with Quarkus, especially for real-world applications. However, I encountered an issue while using your application and adding a new column. The data type for that column is Enumeration, and I annotated it with @Enumerated(EnumeratedType.STRING). Unfortunately, I'm unable to create the table due to a DDL issue. I have attached the code snippet and error image below: Can you help me fix this problem and solve it?Thank you for your assistance. IRIS SQL does not have CHECK constraints, so, this syntax not available at all. Just try using a simple string, without enumeration. As a former Java developer, my suggestion is not to use Enumerations, at the end that field is a common String, if you want to restrict the value of that column do it from the code, not from the database. Yes, Dmitry Maslennikov We don't use CHECK constraint, by default Hibernate will generate this query. I don't know it has some issues in dialect file. It has become a mandatory requirement for us to use Enums in our application. I'm unsure why this functionality isn't achievable in Quarkus versions 3 and above. We previously achieved this in Quarkus version 2, and it worked seamlessly with other databases like MySQL and PostgreSQL. However, I'm puzzled as to why I can't annotate Enum types in the IRIS database.Can you please tell us if is there any possible way to achieve it? Thanks in advance. Fixed change the dependency for 1.1.1: <dependency> <groupId>io.github.yurimarx</groupId> <artifactId>hibernateirisdialect</artifactId> <version>1.1.1</version> </dependency> Thanks yurimarx Marx,Now, I was able to successfully connect to the database also create a table using Enum data type. Thank you very much for your help in this crucial time.

We often get questions about recent and upcoming changes to the list of platforms and frameworks that are supported by the InterSystems IRIS data platform. This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap. With that said, on to the update… IRIS Production Operating Systems and CPU Architectures Red Hat Enterprise Linux Recent Changes RHEL 9.2 & RHEL 8.8 were released in May, 2023. Red Hat is planning to support these releases for 4 years. InterSystems has completed additional testing of IRIS on RHEL 9.2 & RHEL 8.8 through a new process we’re calling “Minor OS version certification” that is intended to provide additional security that a minor OS update didn’t break anything obvious. Both RHEL 8.8 and 9.2 successfully passed our tests. With the release of RHEL 9.2, Red Hat has ended public support for RHEL 9.1. This is consistent with the “odd/even” support cycle that Red Hat has been using since RHEL 8.3. Upcoming Changes RHEL 9.3 is planned for later in the year. This will be a short-term-support release from Red Hat, so InterSystems won’t be performing Minor OS Certification or recommending it for production deployments. Previous Updates IRIS 2022.1.2 adds support for RHEL 9.0. 9.0 is a major OS release that updates the Linux Kernel to 5.14, OpenSSL to 3.0, and Python 3.9 IRIS 2022.2.0 removes support for RHEL 7.x. RHEL 7.9 is still supported in earlier versions of IRIS. Further reading: RHEL Release Page Ubuntu Recent Changes Ubuntu released 22.04.2 LTS & 20.04.6 LTS in February and March, respectively. InterSystems has completed performing additional testing of IRIS on 22.04.02 LTS through Minor OS version certification. Upcoming Changes The next major update of Ubuntu is 24.04 is on-schedule for April, 2024 Previous Updates IRIS 2022.1.1 adds support for Ubuntu 22.04. 22.04 is a major OS release that updates the Linux Kernel to 5.15, OpenSSL to 3.0.2, and Python 3.10.6 IRIS 2022.2.0 removes support for Ubuntu 18.04. Ubuntu 18.04 is still supported in earlier versions of IRIS. IRIS 2022.1.1 & up containers are based on Ubuntu 22.04. Further Reading: Ubuntu Releases Page SUSE Linux Upcoming Changes SUSE Linux Enterprise Server 15 SP5 was released June 20, 2023. SP5 includes Linux Kernel 5.14.21, OpenSSL 3.0.8, and Python 3.11. We’re currently working on Minor OS certification. Previous Updates IRIS 2022.3.0 adds support for SUSE Linux Enterprise Server 15 SP4. 15 SP4 is a major OS release that updates the Linux Kernel to 5.14, OpenSSL to 3.0, and Python 3.9 General Support from SUSE for Linux Enterprise Server 15 SP3 came to an end on 12/31/2022, but extended security support will continue until December, 2025. Further Reading: SUSE lifecycle Oracle Linux Upcoming Changes Oracle surprised us by releasing Oracle Linux 9.2 right around the same time as RHEL 9.2. We’re currently starting Minor OS certification. Previous Updates IRIS 2022.3.0 adds support for Oracle Linux 9. Oracle Linux 9 is a major OS release that tracks RHEL 9, so it, too, updates the Linux Kernel to 5.14, OpenSSL to 3.0, and Python 3.9 Further Reading: Oracle Linux Support Policy Microsoft Windows Upcoming Changes Windows Server 2012 will reach its end of extended support in October, 2023. If you’re still running on the platform, now is the time to plan migration. IRIS 2023.2+ will not be available for Windows Server 2012. Previous Updates We haven’t made any changes to the list of supported Windows versions since Windows Server 2022 was added in IRIS 2022.1 Further Reading: Microsoft Lifecycle AIX Upcoming Changes InterSystems is working closely with IBM to add support for OpenSSL 3.0. This will not be included in IRIS 2023.2.0 as IBM will need to target the feature in a further TL release. The good news is that IBM is looking to release OpenSSL 3.0 for both AIX 7.2 & 7.3 and the timing looks like it should align for IRIS 2023.3. Previous Updates We haven’t made any changes to the list of supported AIX versions since AIX 7.3 was added and 7.1 removed in IRIS 2022.1 Further Reading: AIX Lifecycle Containers Upcoming Changes IRIS containers will only be tagged with the year and release, such as “2023.2” instead of the full build numbers we’ve been using in the past. This way, your application can, by default, pick up the latest maintenance build of your release. We are also adding “latest-em” and “latest-cd” tags for the most recent extended maintenance and continuous distribution IRIS release. These will be good for demos, examples, and development environments. We will also start to tag the preview containers with “-preview” so that it’s clear which container is the most recent GA release. Previous Updates We are now publishing multi-architecture manifests for IRIS containers. This means that pulling the IRIS container tagged 2022.3.0.606.0 will download the right container for your machine’s CPU architecture (Intel/AMD or ARM). IRIS Development Operating Systems and CPU Architectures MacOS Recent Changes We’ve added support for MacOS 13 in IRIS 2023.1 Upcoming Changes Apple is anticipating MacOS 14 reaching GA in September with IRIS support to follow, likely in IRIS 2024.1 CentOS We will be removing support for CentOS/CentOS Stream as of IRIS 2023.3. Red Hat has been running a developer program for a few years now, which gives developers access to free licenses for non-production environments. Developers currently using CentOS are encouraged to switch to RHEL via this program. CentOS Stream is now “upstream” of RHEL, meaning that it has bugs & features not yet included in RHEL. It also updates daily, which can cause problems for developers building on the platform (to say nothing of our own testing staff). We haven’t made any changes to the list of supported CentOS versions since we added support for CentOS 8-Stream and removed support for CentOS 7.9 in IRIS 2022.1 InterSystems Components InterSystems Kubernetes Operator (IKO) IKO 3.6 was released last week. Caché & Ensemble Production Operating Systems and CPU Architectures Previous Updates Cache 2018.1.7 adds support for Windows 11 InterSystems Supported Platforms Documentation The InterSystems Supported Platforms documentation is the definitive source information on supported technologies. IRIS 2023.1 Supported Server Platforms IRIS 2022.1 Supported Server Platforms IRIS 2021.1 Supported Server Platforms Caché & Ensemble 2018.1.7 Supported Server Platforms … and that’s all folks. Again, if there’s something more that you’d like to know about, please let us know. AIX 7.3 TL1 defaults to OpenSSL 3.x$oslevel -s ; openssl version ; uptime7300-01-02-2320OpenSSL 3.0.8 7 Feb 2023 (Library: OpenSSL 3.0.8 7 Feb 2023) 08:58AM up 72 days, 11:32, 16 users, load average: 7.04, 8.57, 9.52 IRIS containers will only be tagged with the year and release, such as “2023.2” What about images on Docker Hub? No latest-cd, no 2023.2, no multi-arch images? In some cases, when I need speed of downloading images I preferer using this place On AIX, the OpenSSL package that comes with AIX is structured differently than in other operating systems. The OpenSSL 3.x package comes with implementations of OpenSSL 1.0.2, 1.1.1, and 3.0. Sadly, the OpenSSL 3.0 implementation which is included in AIX 7.3 TL1 is missing a few features that are critical to correct operation with IRIS. So, currently versions of IRIS use the OpenSSL 1.0.2 implementation. IBM is readying their updated package with the fixes to the OpenSSL 3.0 implementation included. To add on to what Bob said, TL1 first release had the wrong SSL3 - it was not usable to compile some common open source packages because of some SSL configuration options. TL1 SP2 had a usable release. 02-2320 means week 20 so it was released in week 20 of the year.The 7.2 situation is more problematical. To me (just my opinion) it doesn't look like IBM plans to update the default SSL in 7.2 to 3. Instead they offer an optional download from the MRS web site with an up to date SSL3 and some other related components. Its not an ideal sys admin picture. It gets a little worse - lets say you want apache from their toolbox. The toolbox will make you get an SSL bundle from the MRS website.

Hi Developers! Here're the technology bonuses for the InterSystems Python Contest 2023 that will give you extra points in the voting: Embedded Python - 3 Python Native API - 3 Python Pex Interoperability - 4 Python libs: sqlalchemy and dbt - 2 LLM AI or LangChain usage: Chat GPT, Bard and others - 4 NoObjectScriptLine - 5 Questionnaire - 2 Docker container usage - 2 ZPM Package deployment - 2 Online Demo - 2 Implement InterSystems Community Idea - 4 Find a bug in Embedded Python - 2 First Article on Developer Community - 2 Second Article On DC - 1 First Time Contribution - 3 Video on YouTube - 3 See the details below. Embedded Python - 3 points Use Embedded Python in your application and collect 4 extra points. You'll need at least InterSystems IRIS 2021.2 for it. Python Native API - 3 points InterSystems IRIS introduces a Python Native API library that helps to interact with IRIS from python. Check the latest python community driver that gives the latest support for the majority of popular python libraries: sqlalchemy, dbt, etc. Use it and collect 3 extra points for your application. Python Pex Interoperability - 4 points InterSystems IRIS has Python Pex Interoperability module that provides the option to develop InterSystems Interoperability productions from Python. Use it and collect 3 extra points for your application. It's OK also to use alternative python.pex wheel introduced by Guillaume Ronguier in this proejct and template. Python libs: sqlalchemy and dbt - 2 Use sqlachemy and dbt for IRIS community libs and collect 2 additional bonus points for each. LLM AI or LangChain usage: Chat GPT, Bard and others - 4 points Collect 6 bonus expert points for building a solution that uses LangChain libs or Large Language Models (LLM) such as ChatGPT, Bard and other AI engines like PaLM, LLaMA and more. AutoGPT usage counts too. A few examples already could be found in Open Exchange: iris-openai, chatGPT telegram bot. Here is an article with langchain usage example. Pure Python(NoObjectScriptLine) - 5 points We are introducing several python APIs in this contest! And the bonus is yet another challenge: build your python solution with InterSystems IRIS and try to avoid using even a line of ObjectScript! IRIS Classes with only Embedded Python methods are OK though. Do it and collect 5 bonus points more! Here is a template that demonstrates how you can use IRIS without a line of ObjectScript. Yes, it contains ObjectScript classes for demo purpose but you can delete it in your app. Questionnaire - 2 Share your feedback in this questionnaire and collect 2 extra points. Docker container usage - 2 points The application gets a 'Docker container' bonus if it uses InterSystems IRIS running in a docker container. Here is the simplest template to start from. ZPM Package deployment - 2 points You can collect the bonus if you build and publish the ZPM(InterSystems Package Manager) package for your Full-Stack application so it could be deployed with: zpm "install your-multi-model-solution" command on IRIS with ZPM client installed. ZPM client. Documentation. Online Demo of your project - 2 pointsCollect 2 more bonus points if you provision your project to the cloud as an online demo. You can do it on your own or you can use this template - here is an Example. Here is the video on how to use it. Implement Community Opportunity Idea - 4 points Implement any idea from the InterSystems Community Ideas portal which has the "Community Opportunity" status. This will give you 4 additional bonus points. Find a bug in Embedded Python - 2 pointsWe want the broader adoption of InterSystems Embedded python, so we encourage you to report the bugs you will face during the development of your python application with IRIS in order to fix it. Please submit the bug here in a form of issue and how to reproduce it. You can collect 2 bonus points for the first reproducible bug. Article on Developer Community - 2 points Write a brand new article on Developer Community that describes the features of your project and how to work with it. Collect 2 points for the article. The Second article on Developer Community - 1 point You can collect one more bonus point for the second article or the translation regarding the application. The 3rd and more will not bring more points but the attention will all be yours. First Time Contribution - 3 points Collect 3 bonus points if you participate in InterSystems Open Exchange contests for the first time! Video on YouTube - 3 points Make the Youtube video that demonstrates your product in action and collect 3 bonus points per each. The list of bonuses is subject to change. Stay tuned! Good luck in the competition! Added a template release that demonstrates how you can use IRIS without a line of ObjectScript to let you collect 5 bonus points. Yes, the template contains ObjectScript classes but it is for demo purposes of using Python from ObjectScript only. We also added 2 points bonus option for Embedded Python bugs found - please report them here. And here is the related video how to use the template: Thanks @Evgeny.Shvarov, nice template to start the embedded Python application Thanks @Muhammad.Waseem !

Hi Community, It's voting time! Cast your votes for the best applications in our InterSystems Python Programming Contest 2023: 🔥 VOTE FOR THE BEST APPS 🔥 How to vote? Details below. Experts nomination: InterSystems experienced jury will choose the best apps to nominate the prizes in the Experts Nomination. Please welcome our experts: ⭐️ @Guillaume.Rongier7183, Sales Engineer⭐️ @Sylvain.Guilbaud, Sales Engineer⭐️ @akoblov, Senior Support Specialist⭐️ @Eduard.Lebedyuk, Senior Cloud Engineer⭐️ @Steve.Pisani, Senior Solution Architect⭐️ @Alex.Woodhead, Senior Systems Developer⭐️ @Andreas.Dieckow , Principal Product Manager⭐️ @Aya.Heshmat, Product Manager⭐️ @Benjamin.DeBoe, Product Manager⭐️ @Robert.Kuszewski, Product Manager⭐️ @Carmen.Logue , Product Manager⭐️ @Luca.Ravazzolo, Product Manager⭐️ @Raj.Singh5479, Product Manager⭐️ @Patrick.Jamieson3621, Product Manager⭐️ @Stefan.Wittmann, Product Manager⭐️ @tomd, Product Manager⭐️ @Daniel.Franco, Senior Manager - Interoperability Product Management⭐️ @Timothy.Leavitt, Development Manager⭐️ @Evgeny.Shvarov, Senior Manager of Developer and Startup Programs⭐️ @Dean.Andrews2971, Head of Developer Relations⭐️ @Jeffrey.Fried, Director of Product Management Community nomination: For each user, a higher score is selected from two categories below: Conditions Place 1st 2nd 3rd If you have an article posted on DC and an app uploaded to Open Exchange (OEX) 9 6 3 If you have at least 1 article posted on DC or 1 app uploaded to OEX 6 4 2 If you make any valid contribution to DC (posted a comment/question, etc.) 3 2 1 Level Place 1st 2nd 3rd VIP Global Masters level or ISC Product Managers 15 10 5 Ambassador GM level 12 8 4 Expert GM level or DC Moderators 9 6 3 Specialist GM level 6 4 2 Advocate GM level or ISC Employees 3 2 1 Blind vote! The number of votes for each app will be hidden from everyone. Once a day we will publish the leaderboard in the comments to this post. The order of projects on the contest page will be as follows: the earlier an application was submitted to the competition, the higher it will be on the list. P.S. Don't forget to subscribe to this post (click on the bell icon) to be notified of new comments. To take part in the voting, you need: Sign in to Open Exchange – DC credentials will work. Make any valid contribution to the Developer Community – answer or ask questions, write an article, contribute applications on Open Exchange – and you'll be able to vote. Check this post on the options to make helpful contributions to the Developer Community. If you changed your mind, cancel the choice and give your vote to another application! Support the application you like! Note: contest participants are allowed to fix the bugs and make improvements to their applications during the voting week, so don't miss and subscribe to application releases! So! After the first day of the voting, we have the following results: Community Nomination, Top 5 iris-python-machinelearn by @André.DienesFriedrich BardPythonSample by @@xuanyou.du apptools-django by @MikhailenkoSergey iris-GenLab by @Muhammad.Waseem iris-vector by @Dmitry.Maslennikov ➡️ Voting is here. Expert Nomination, Top 4 iris-vector by @Dmitry.Maslennikov iris-recorder-helper by Alexey Nechaev Face Login by @Yuri.Gomes irisapitester by @Daniel.Aguilar ➡️ Voting is here. Experts, we are waiting for your votes! 🔥 Devs! Here are the results after two days of voting: Community Nomination, Top 5 iris-python-machinelearn by @André Dienes Friedrich BardPythonSample by @@xuanyou du iris-vector by @Dmitry Maslennikov native-api-py-demo by @shan.yue iris-GenLab by @Muhammad Waseem ➡️ Voting is here. Expert Nomination, Top 5 iris-vector by @Dmitry Maslennikov iris-recorder-helper by Alexey Nechaev Face Login by @yurimarx Marx iris-GenLab by @Muhammad Waseem irisapitester by @Daniel Aguilar ➡️ Voting is here. So, the voting continues. Please support the application you like! Hi, Dev's! And here're the results at the moment: Community Nomination, Top 5 iris-python-machinelearn by @André Dienes Friedrich iris-vector by @Dmitry Maslennikov BardPythonSample by @xuanyou du iris-GenLab by @Muhammad Waseem native-api-py-demo by @shan yue ➡️ Voting is here. Expert Nomination, Top 5 iris-vector by @Dmitry Maslennikov iris-recorder-helper by Alexey Nechaev Face Login by @yurimarx Marx iris-GenLab by @Muhammad Waseem irisapitester by @Daniel Aguilar ➡️ Voting is here. Please check out today's voting results: Community Nomination, Top 5 iris-vector by @Dmitry Maslennikov iris-python-machinelearn by @André Dienes Friedrich iris-GenLab by @Muhammad Waseem BardPythonSample by @xuanyou d native-api-py-demo by @shan yue ➡️ Voting is here. Expert Nomination, Top 5 iris-GenLab by @Muhammad Waseem iris-vector by @Dmitry Maslennikov iris-recorder-helper by Alexey Nechaev iris-python-machinelearn by @André Dienes Friedrich native-api-command-line-py-client by @Robert.Cemper1003 ➡️ Voting is here. Keep voting!Our participants need your support! Last day of voting! ⌛ Our contestants need your votes! 📢 Voting is here!

Hi Everyone, Our next online Developer Roundtable will take place on September 28 at 9 am ET. Our experts will cover the topic: "Running IRIS workloads in the cloud (AWS, GCP, Azure): VMs or Containers, networking setup, availability, mirrors, backups", presented by @Eduard.Lebedyuk , Senior Cloud Engineer, InterSystems We will have time for Q&A and open discussion. >> Watch the recording Links mentioned in the call and chat: 🔗 Slide Deck "Running IRIS workloads in the cloud (AWS, GCP, Azure) by @Eduard.Lebedyuk , Senior Cloud Engineer, InterSystems 🔗 Article: Highly available IRIS deployment on Kubernetes without mirroring 🔗 Keep your docker iris images in shape - article by Guillaume Rongier 🔗 intersystems-iris-dev-template - basic template available on Open Exchange for a development environment to work with ObjectScript in InterSystems IRIS. It helps you edit, compile, commit/push, debug and test your ObjectScript code. It also aids in packaging your application as a module installable with IPM. The template is embedded python compatible. 🔗 Reference to Docs on Metrics: iris_cpu_usage Percent of CPU usage for all programs on the operating system Not a Global Masters member yet? Log in using your InterSystems SSO credentials to join the program. Hi Community, roundtable starts in a few minutes. Join us using this link Hi Olga,Is the roundtable record available? Hi @Alexey.Maslov yes please see the recording hereWe discussed only 1 topic this time - Running IRIS workloads in the cloud;We will start the next roundtable with "Developing Python applications" demo by Evgeny Shvarov

Hello Community, Anyone who has (near or distant, with a preference for the 1st option) knowledge of the use of Amazon QuickSight with IRIS is invited to share his|her experience in this discussion. Thanking you in advance.

I am planning upgrade my PC OS to windows 10 to Windows 11. There is any compactibility issue is with windows 11 with JReport and Intersystes Studio. Intersystems Studio Version: - InterSystems Studio Client 2021.1.0 Build 215Server IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2021.1 (Build 215_0_21953U) JReport Designer Version :- JReport Designer 15.5 Anyone help to know there is any compactibility issue is there. Thanks in Advance.