I want to switch between different DSNs in business operations to query different servers, but the DO ..Adapter.DSNSet("DSNName") code will report a 15-second connection timeout error when switching DSNs. What should I do?

Hey Community, 

New video is already waiting on InterSystems Developers YouTube: 

⏯ Nora, A Virtual Assistant for Clinicians: Innovation with Microsoft Teams & Northwell Health 

See the latest news from Learning Services, including:

• New custom paths for Implementation Partners
• Learning paths in system administration, healthcare analytics, and VS Code development
• Documentation feedback options

Intersystems recently announced a partnership with unqork. I would like to know if someone already used this tool, or another tool, and how was the experience. Is there within the intersystems ecosystem (partners) any low-code tool that generates COS? Tks

A permanent job opportunity has arisen for a Caché/Ensemble /Iris developer with at least 2 years experience. My client is a specialist resource provisioner of developers for high profile clients in the finance,  healthcare, retail, distribution and credit business that are mainly based in central London. My client is looking for a highly-motivated individual who thrives in an environment where problems are open-ended. If you want to apply for the job you must be a UK resident, have a proven track record of building applications using InterSystems technologies and are able to work

At the recent virtual conference I saw the demonstration on being able to run Python within ObjectScript and run ObjectScript within Python thanks to a feature called Language Bridge.  Is this available now? If so, am I able to install it?  I am currently running HealthShare 2020.1.  I have a little bit of experience using Irisnative with Python but was intrigued with the more seamless-looking features offered by the Language Bridge.

Thanks for any insight.

Marlin Mixon

Hi all,

I have a process that recive a datetime in ISO 8601 format (YYYY-MM-DDThh:mm:ss+001) to %timestamp value.

Example: set myDatetime  = "2021-11-04T11:10:00+0100"

I've triyed use $SYSTEM.SQL.CONVERT(myDatetime,"SQL_TIMESTAMP") but it doesn't work.

Any idea?

Regards,
Kurro Lopez

I'd like to bring your attention to my two Virtual Summit sessions, even though they're not HALF as cool as Embedded Python.

Git & GitLab for Shared Development Environments details the newly-released git-source-control package (see also on the Open Exchange) which provides a new best-of-breed solution for server-side IRIS/Git integration, especially for shared remote development environments. (I need to write up a post about this package specifically and plan to do so soon.)

I am trying to create a scheduled task but get not implemented error when I try to run it.

Class PICIS.Core.Tasks.CleanEntry Extends %RegisteredObject
{

ClassMethod ClearTasks(pBackupFile As %String = "d:\Temp\BackupTasks.xml", pDelete As %Boolean = 0)
{
    // Create backup file
    Set tBackup = ##class(%Stream.FileCharacter).%New()
    Set tBackup.Filename = pBackupFile
    Do tBackup.WriteLine("<?xml version=""1.0"" encoding=""UTF-8""?>")
    Do tBackup.WriteLine("<Tasks>")

CHAS Health is looking for a full time Interface Engineer II

AMAZING Benefits Package! Medical, Dental, Vision

Paid Time Off (PTO) CHAS Health offers up to 6 weeks of PTO per anniversary year for full time employees.

Loan Reimbursement Program that provides reimbursement for student loan payments up to $5,250 per year for CHAS Health employees working a minimum of 30 hours a week who have completed 90 days of employment and are in good standing. This program is for employees with qualified student loans that are not eligible for state or federal loan repayment programs.

I have just created a new Global Master Topic, "IRIS Cheatsheets". IRIS has introduced a lot of new functionality, especially in scripting languages, FHIR R4 support, enhanced Interoperability Tools, and IRIS Analytics. Having spent 35 years working on Windows-based PC's and Laptops, I have surprisingly little knowledge of Linux, Docker and Git. Furthermore, I have written almost every application and Interface in ObjectScript with splatterings of SQL, .Net, and Java Gateways and the most basic knowledge of WinSCP, Putty, SSH. All that changed when I received my first Raspberry Pi. I first had

Hey everyone,

We're pleased to welcome @Duan Haihua as our new Chinese Moderator in the Developer Community Team!

Let's greet Duan Haihua with big applause and take a closer look at his bio!

Hi All,

I'm having a strange issue where doing a .setValue on a ZEN datacombo is updating it with the value as-is, not the corresponding display value. Eg, if I connected it to query that returns two columns: ID,Name, and do a setValue(ID), I would expect the text in the datacombo to update showing Name. Instead it updates show ID, which I only want to use internally.

Hello,

How I can unpack rar archive with 7z program in COS?

Are you an InterSystems Implementation Partner? As you build customer-focused applications, take advantage of comprehensive online learning resources. Now available are three custom learning paths in finance, healthcare, and all industries—offering a solid foundation for anyone looking to build applications with InterSystems products!

Hey Developers, 

Learn about new features in the InterSystems HealthShare Health Insight 2020.1 and 2020.2 releases and plans for future releases:

⏯ New & Next: Deliver actionable intelligence with HealthShare Health Insight 

In my previous articles I demonstrated the steps to connect, retrieve and save data to Caché from Appeon PowerBuilder by using ODBC.
In this article I will demonstrated how to Delete data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC 

I am using Company.cls from Samples-Data (https://github.com/intersystems/Samples-Data/tree/master/cls/Sample) 

So Let's start:
 

Step 1 : First of all we need to establish a connection (https://community.intersystems.com/post/connecting-cach%C3%A9-appeon-po…)

Hi Guys,

How can I download or populate a query resultset or a content or DataGrid or zen report to a CSV file ?

basically, I know how to create a csv file than save it in a local path eg. C:\Temp\filename.csv but this is not convenient for the user to go then a try to find the file, I would like the CSV file to be downloaded or opened for the user to view the same way for example when you go a website where you have an option to download or open a csv file from query resultset or a zen report .

Thanks

Hi Developers!

Here're the technology bonuses for the Security Contest 2021 that will give you extra points in the voting:

• Basic Authentication usage - 2
• Bearer/JWT Authentication usage - 3
• OAuth 2.0 usage - 5
• Authorization components usage - 2
• Auditing usage - 2
• Data Encryption usage - 2
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• Code Quality pass - 1
• Article on Developer Community - 2
• Video on YouTube - 3

See the details below.

[SQLCODE: <-400>:<Fatal error occurred>][Cache Error: <<MAXSTRING>zExecute+3^%sqlcq.LIM.cls1043369.1>][Location: <ServerLoop>][SQLCODE: <-400>:<Fatal error occurred>][Cache Error: <<MAXSTRING>zExecute+3^%sqlcq.LIM.cls1043369.1>][Location: <ServerLoop>]   at InterSystems.Data.CacheClient.CacheADOConnection.GetServerError(Int32 rc)   at InterSystems.Data.CacheClient.CacheADOConnection.processError(Int32 error, Int32 allowError)   at InterSystems.Data.CacheClient.InStream.readHeader(Int32 stmt_id, Int32 type, Int32 allowError)   at

Working in support, I usually get asked how many days I should keep journals. Should it be two days or after two backups? More? Less? Why two?

The correct answer (for most of the environments) is that you should keep the journals since the last validated Backup. I.e., until you don't check if a Backup is valid (restoring the file and checking with the Integrity utility), you can't be sure there is a good copy of your data and can't purge the journals safely.

Hi Community, 

Learn about strategic approaches being taken to leverage the potential of HL7 FHIR in InterSystems HealthShare:

⏯ The Promise of FHIR

Hi Community,

We are pleased to invite all the developers to the upcoming InterSystems Security Contest Kick-off Webinar! The topic of this webinar is dedicated to the Security contest.

We’ll discuss the aspects of Security Model implementation in InterSystems IRIS, the requirements, and what do we expect from participants of the Security contest. Also, we’ll answer all the questions related to the contest!

Date & Time: Monday, November 15 — 12:00 AM EDT

Speakers:  
🗣 @Andreas Dieckow, Principal Product Manager at InterSystems Corporation
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

CCR Beta Users will now be directed to the Angular Transition CCR page for markENVComplete and passPeerReview transitions.  Other CCR transitions will go into beta soon.

Please raise any issues or feedback here or in your regular support channels.

Many thanks to our CCR UI beta testers!  If you would like to join the beta tester program, you can enable the checkbox on your CCR user page here.
Update:  As of 2/1/2022, we've most transitions are included in the beta.  The few stragglers will be added soon.

During the last weeks, I was working on various issues and problems related to SW development.
I found that quite often problem analysis was mostly chasing issues just on the surface
but not really attacking the deeper reasons of the problem and follow the consequences.
It's like the doc that stops your leg bleeding but doesn't see that it is broken.

InterSystems technologies are renowned for their high performing databases, which support the systems and operations of many organisations. However a key ingredient to this success is the quality and maintainability of their code. 

The quality of code can impact everything from speed and ease of fixing bugs and making enhancements, to the overall performance of your organization and your ability to get ahead in the marketplace. 

By ensuring your code is maintainable, you can reduce approximately 75% of the systems life cycle costs*. This is why, at George James Software, the solutions we build are always straightforward and written in high quality code - because we know that this solid foundation can positively impact the rest of your organization. 

With a maintainable system you're able to reduce your overall maintenance as any issues that occur are significantly faster to identify and fix. This means you're free to allocate that time and budget to enhancements, enabling you to get the most value out of your applications and ultimately better support your organization. 

Keep an eye out for our next few posts about what a maintainable system looks like and the tools that can help you keep your code maintainable, in order to help you to reduce those maintenance costs.  

I Mean By Default without overriding the service class and manually logging.

Hi Guys

I'm rather new to HealthConnect, and I've been doing a lot of work with the browser based SQL portal and don't particularly like it. Is there an alternative application that I can use, something like SQL Express or VScode with a plugin?

Andy

I'm trying to send a POST request to my REST API and I'm getting this error and most likely due the lack of experience, I have no idea how to fix this issue:  

"error": "ERROR #9406: Unexpected format for value of field, AlertText, using class base mapping",

            "id": "JSONImportError",

            "params": [

                "AlertText",

                "class base"

            ]

Am I missing something from my string definition?

Defined below as:

Class User.RESTComponents Extends (%Persistent, %JSON.Adaptor, %Populate)

{

Property AlertText As %String;

Here is my POST -method: