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,"1(.E1"SITE A",.E1"SITE B")")

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.
2
1 61375
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 566
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 18734
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:

docker-compose exec iris iris session iris
.
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.
7
0 942
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 420
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 1694
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 711
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 812
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).
0
2 516
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!

12
0 1097
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 521
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 997
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 640
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.

5
0 1016
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 1946
Question Hoi Lai · Nov 23, 2021

Does InterSystems IRIS have any library or class that support IBM FASP protocal? like SFTP, IRIS has %Net.SSH.SFTP that for SFTP file transfer.

3
0 405