Announcement Bob Kuszewski · Oct 28, 2021

Welcome to day 3 of Virtual Summit 2021!  We have incredible content available to you this year and I'd just like to bring your attention to the 4(!) sessions that we have on Embedded Python.

14
3 1034
Question Peter (Sechaba) Tomodi · Nov 26, 2021

kindly assist with this error, mobile app keeps loading after converting it using Cordova compiler from workbench but the web app is running well.

error message shows this when I check api link on postman:

{

    "errors": [

        {

            "code": 5002,

            "domain": "%ObjectErrors",

            "error": "ERROR #5002: ObjectScript error: <INVALID OREF>zSetSessionLanguage+7^HSPortal.API.Public.1",

            "id": "ObjectScriptError",

            "params": [

                "<INVALID OREF>zSetSessionLanguage+7^HSPortal.API.Public.1"

            ]

        }

    ],

    "summary": "ERROR #5002:

2
0 304
Question Jimmy Christian · Nov 17, 2021

Hello,

I am trying to pass a pattern in the Ensemble function Matches(val,pat) in Business Rule as below.

Eg. 

Matches(tSite,&quot;1(.E1&quot;SITE A&quot;,.E1&quot;SITE B&quot;)&quot;)

tSite is a variable containing the site name

Want to check if the variable contains any of the site name.

But i receive a parsing error when compiling.

Is there another way to pass the pattern in the Matches function or any other similar function which i can use in the business rule or DTL without multiple sentences with Contains.

Thanks,

Jimmy Christian.

2
0 310
Article Murray Oldfield · Nov 30, 2021 3m read

When looking at system performance and capacity planning I need to know what processors a server is running.

In ^SystemPerformance Linux systems report Intel processors explicitly, for example:

processor	: 0
vendor_id	: GenuineIntel
cpu family	: 6
model		: 79
model name	: Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
stepping	: 1
microcode	: 0xffffffff
cpu MHz	: 2294.685

Its pretty obvious this is a Broadwell E5-2673 v4 processor, and I can get the specifications and enough details to look at the SPECint rating and other information, for example:

Intel reference

This also gives me clues to the age of

2
1 61294
Question Naveen Nagavelly · Nov 30, 2021

We are migrating servers

Trying to create IRIS ODBC connection in new window 10 machine, but getting an error "TCP connect() timed out." 

In old server windows server 2012 - IRIS ODBC connection was already existed, working fine. if I create new/test with IRIS connection is fine.

Only issue in new server (windows 10), I am not sure why I am getting error. Can any one help.

I added Firewall outbound port, still it is not working.

1
0 562
Question Sap Help · Apr 4, 2019

Hi All,

I would like to download odbc drivers for Cache database to be able to install it on our SQL server.

I am trying to create a linked server to Cache database.

I couldn't find a link for the drivers, there was one post with FTP reference to download but it doesn't seem to work.

I will be grateful for any help.

Thank you

Sap.

8
0 18722
Article Sergey Mikhailenko · Nov 30, 2021 1m read

Looking at my old articles recently. I saw an undeservedly forgotten program that can significantly increase the security of your system by not allowing the user to use old passwords when changing.

To meet the requirements of section 8.2.5 PCI DSS "Prohibit the use of old passwords", a small application has been implemented that will be launched by the system when a user tries to change a password and check if it was used before.

You can install the program from the terminal and from the management portal interface

Open IRIS terminal:

...
1
2 384
Question Ben Webb · Nov 29, 2021

Hi all, 
I'm using a snippet I found from Scott Roth to extract, decode, and save a PDF from a HL7 message and save it to a specified file path, but I'm running issues with the following error:

My approach was to a create a utility function accessible from a DTL like this:

Class ELHTPRODPKG.Functions.Utility.ExtractPDF Extends Ens.Rule.FunctionSet
{

     ClassMethod DecodeBase64HL7(base64 As %Stream.GlobalBinary, Path As %String, FileName As %String) As %String [ Final ]
     {
          //Debug
          WRITE $LENGTH(base64)
          // Decode
          set Oref =
7
0 938
Article Sergey Mikhailenko · Nov 29, 2021 2m read

I recently published the "appmsw-docbook" module for deploying the solution not by individual programs, but by the entire database. This solution allows you to deploy a project without source codes.

Having received feedback, I decided to improve it significantly. Replaced zip archive with tgz, which will allow not using external system-dependent archivers.

Implemented a method for preparing an archive of a database and its dependent web applications.And the deployment archive itself is assembled as a zpm module into which the utility for deploying the database is replicated.

0
1 419
Article Yuri Marx · Aug 12, 2020 1m read


Globals SQL Database DocDB - Document Database Multidimensional Cube Database NLP Database Object Database JDBC Driver ODBC Driver Native API for Java Native API for .NET Native API for Python C/C++ Callin/Callout Native API for Node.js Object Script Caché Multivalue Caché Object Script Caché Basic CSP/HTML Support T-SQL Infrastructure as Code (IaC) Docker InterSystems Kubernetes Operator IRIS in the Google Cloud Platform IRIS Community Edition ZPM - Package Manager IRIS in the Azure IRIS in the Tencent IRIS Sharding support InterSystems Cloud Manager InterSystems in the AWS InterSystems On-Premises Enterprise Cache Protocol - ECP Machine Learning R and AI robotization NLP - Natural Language Processing MDX - MultiDimensional Expressions AutoML - InterSystems IntegratedML Analytics/BI - Business Intelligence InterSystems Reports PowerBI Support PMML - Predictive Model Markup Language Apache UIMA Apache Spark Analytical Dashboards InterSystems Developer Community InterSystems Open Exchange - Open Source Apps, Samples and templates InterSystems Worldwide Response Center InterSystems Learning Services Interoperability Adapters DTL - Data Transformation MQ - Message Queue EAI - Enterprise Application Integration ESB - Enterprise Service Bus API Manager CDC - Change Data Capture BAM - Business Activity Monitoring BPL IoT - Internet of Things SOA - Service Oriented Architecture Application/Service Governance Data Encryption Authorization Management Authentication Management Audit Management Label Security SSL/TLS SOAP/API Security User Portal Security Data/Assets Security Disaster Recovery - Backup and Restore Data Intensive - ESG Review Big Data Artificial Intelligence API Driven Economy Digital Health Public Sector Digital Transformation Hyper automation Business Sector Data as Service Software as Service IRIS as Backend IRIS as Mobile backend IoT Backend

PDF version: https://github.com/yurimarx/iris-periodic-table/raw/master/periodic%20table%20iris.pdf

GIT sources: https://github.com/yurimarx/iris-periodic-table

InterSystems IRIS is a Data Platform with a lot of features. These features and relevant topics about IRIS is represented in the periodic table elements.

22
10 1692
Article John Murray · Nov 29, 2021 3m read

The InterSystems Server Manager extension for Visual Studio Code lets you define connections to your servers, list their namespaces and edit or view code there. You can also launch Portal for a server.

Server Manager 3.0 improves security by becoming a VS Code Authentication Provider. It is my entry for the November 2021 InterSystems Security Contest. Click here to visit the contest page where you may decide to vote for this entry. Please ignore the clickable "Contestant" label on this article header above, as it relates to a different contest for new DC articles. If you want to support me in that contest, simply "like" this post.

0
1 707
Question Martin Fukátko · Nov 27, 2021

Hi, I have VSCode on my Windows 10 notebook with intersystems-community.objectscript-pack installed. I'm successfully connected to remote IRIS (2021.1). I can export classes, change them, save and import back to IRIS. 

But every time VSCode starts, the message "Request initialize failed with message: Dynamic Linking Error: Win32 error 126" is displayed and InterSystems Language Server does not start.

Has anyone solved this problem yet?

5
0 808
Article Sergey Mikhailenko · Nov 29, 2021 2m read

Developing the project zpm "install isc-apptools-lockdown" implemented the ability to set the security level not only to lockdown, but also to minimum and normal.

Increasing security settings

You can replace the shared password if the password of the predefined system users has been compromised

USER>do ##class(appmsw.security.lockdown).ChangePassword("NewPass231",##class(appmsw.security.lockdown).GetPreparedUsers())

Apply Security settings to "LockDown"

USER>do ##class(appmsw.security.lockdown).SetSecurityLevel("lockdown","NewPassword123")

or equivalent

USER>zpm "install isc-apptools-lockdown
0
2 515
Question Stefan Katzensteiner · Dec 6, 2020

Good evening Intersystems Community,

I want to participate in the Advent of Code 2020 and followed the installation instructions in "The Advent of Code 2020 contest ObjectScript template" (https://openexchange.intersystems.com/package/aoc2020-objectscript-temp…).

Unforunately I get "Error: Invalid Community Edition license, may have exceeded core limit." at the step "docker-compose build".

I think I already found a way to tell docker to use less cores (docker run --cpus 2), but I can't figure out how to integrate that into "docker-compose build".

I would really appreciate any advice, thanks!

Bes

12
0 1093
Question Yakov Berger · Nov 28, 2021

I have a stored procedure (MSsql) which has one input and one output parameter.

and a Business Operation calling the SP

The following code executes the stored procedure successfully , but does not return the output.

what needs to be fixed?

set outparm = ""
set pResponse = ##class(Ens.StringResponse).%New()
SET SQLQuery2 = "{call s_sproc (?,?)}"
SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery2,"io*",pRequest.StringValue,outparm )
set pResponse.StringValue  = outparm 

Thanks
 

5
0 518
Question Ben Webb · Oct 28, 2021

Hi all, 
Just wondering if there's a quick way to get the DocType, without knowing it in advance, from a message body by building a string from the VersionID, MessageType, and TriggerEvent fields? (Similar to how it might be done dynamically in Rhapsody)
Can this then be used to set the DocType for a source message?
If this is not the best practice what is a suitable alternative approach?
Thanks for your help,
Ben

6
0 995
Article Dmitry Zasypkin · Oct 7, 2020 8m read

FHIR Terminology Service specification describes a set of operations on CodeSystem, ValueSet and ConceptMap resources. Among those operations, the following four operations appear to be the most widely adopted ones:

Developing a partial implementation of the specification has been an effective way to explore the new FHIR framework introduced in IRIS for Health 2020.1. The implementation includes four operations listed above, and supports read and search interactions for CodeSystem and ValueSet resources.

It's important to note that the implementation uses plain ObjectScript persistent classes as source terminology tables.

1
2 639
Question prashanth ponugoti · Nov 24, 2021

Hi All,

I am working in Heath Share Heath Connect Integration.

I have a requirement to change SOAP call to REST call in integration. For SOAP call already payload is ready in XML string. and Working fine.

Now I need to make REST API call instead of existing SOAP call.

I have created REST Business Operation and ready to Call it from Business Process.

Here I should not change any Transformation in Business Process , only change  in Operation invocation

Only change is existing SOAP Operation expecting XML String , new REST Operation is expecting JSON.

How can I convert existing XML String to JSON by

5
0 1014
Question Nezla · Nov 25, 2021

Hi Guys,

is there a Runtime EXE for Excel or ms office, I've a report that would like to open in excel?

Thanks

3
0 1944