Hello programmers !!
I'm learning COS and Ensemble and also I started to work with this technology and I did set up vscode to program,
but I don't know how to set up the vscode terminal for COS.
Could anyone help me?
I'm a beginner with this technology

November 19, 2021 - Advisory: Apache Web Server provided with InterSystems kits – Vulnerability reports

InterSystems kits include an Apache web server, which provides a convenient way for customers to interact with the Caché/IRIS Management Portal without needing to install an external web server; however, this web server should never be used for production instances, and customers must install a web server that fits their specific needs and security/risk requirements.

Recent tests have noted some security issues with the currently included Apache web server.

Hi,

I am getting Failed to fetch error while calling FHIR accelerator service - API Development service

Thanks

I often get this message when trying to attach to the routine second time. The only way I was able to fix this is by restarting the Cache server.

Then I can do debugging once, but second time, the error pops up again. Very annoying. Is there a way to fix that without restarting the server ?

Thank you 

Dean Kavicki

I'm attempting to use the .NET Entity Framework provider that is provided by InterSystems (see: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GBMP_eframe).  In our environment, the "Support Delimited Identifiers" option is turned off and we are not allowed to turn it on without significant testing effort.  When this setting is off, the SQL that is generated by the Entity Framework provider is not considered valid and therefore the provider doesn't work (it DOES work, however, when this setting is turned ON).

Do you know of any way to work around this issue?

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.

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>")

    // Delete loop
    Set tCount = 0
    Set tSC = $$$OK
    Set tRS = ##class(%SQL.Statement).

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.

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!

For all docker versions we have direct download links.

Like on our repository or on docker hub :

• https://containers.intersystems.com

• https://hub.docker.com/search?q=intersystems&type=image

However, there is no direct link to download the installable (non docker) versions.

I propose you these two scripts to solve this need, the first one is with the wget command, the other one in curl.

Wget :

wget --delete-after --keep-session-cookies --save-cookies cookies.txt \
--post-data='UserName=<Your Login>&Password=<Your password>'  \
'https://login.intersystems.com/login/SSO.UI.Login.cls?

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.

However, if I click on the dropdown, showing all the valid Names, select one, it works fine, showing Name (with the ID retrievable by getValue() as normal).

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.

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 InterSystems.Data.CacheClient.CacheCommand.

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.

For example, imagine you need to restore your system after a hardware failure that corrupted some databases.

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