Episode 17 of Data Points features a roundtable conversation with Carmen Logue, Benjamin De Boe, and Thomas Dyar about the Analytics & AI area of the InterSystems technology stack. Learn from these product experts about the various technologies and partnerships that exist within the Analytics & AI space at InterSystems, how some customers use these tools, and what might be coming in the future.

Hello,

fine tuning access permissions is a difficult issue in Caché, at least for me as it seems. More generally, I would be interested in how to find out which permission a user is missing when a permission violation is logged. In this specific case a user, created in (from my point of view) an identical way as on other instances, is not allowed to execute an operation within a CSP service on the messagebank (which however works on the other machines). Unfortunately, the message in the errorlog does not tell where exactly the access violation occurs, or what permission is missing.

greetings Community!

InterSystems Learning Services is working to identify and create libraries of high-quality learning resources for third-party technologies, platforms, and systems that are part of, integrated with, or commonly used with InterSystems products and technologies. we don't create content for these ourselves, but want to support our clients, external and internal, in learning about them and how to use them.

Hello Everyone

I use VB.NET to dev. some program for query data 

Code in VB like this

Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click     

 AxVisM1.MServer = "CN_IPTCP:myserver[1972]"
            AxVisM1.NameSpace = "LABDATA"
            AxVisM1.Code = "s err="""",err=$$select^LVBEPVIS(""" & ln & """)"
            AxVisM1.Execute(AxVisM1.Code)
        

        tmptxt = AxVisM1.PLIST.ToString

messagebox.show(tmptxt)

but it show only 

and then i try to run same command in Cterm. it show 

Could you suggest  What wrong ? and Why VISM.

Hi,

We need to implement Oauth2 Code Flow + PKCE. Any experience with InterSystems OAuth2 Server on this would be welcome.
What parameters did you setup on OAuth 2 server configuration page  to make it work?

Thanks!

I was interested in accessing IRIS (Healthshare) using Python.  I found instructions how to this here: https://github.com/intersystems/quickstarts-python/tree/master/Solution…

The installation went well using pip and when python executes "import irisnative" it works fine.  It just fails with a connection timeout when I try "irisnative.createConnection(...)."  Below is my code:

import irisnative

# Modify connection info based on your environment
ip = "10.10.

I am working with InterSystems API Manager product and I'm trying to solve an authentication problem.  In our implementation, API Manager accepts basic authentication.  One of the endpoints accepts OAuth2.  The request coming into API Manager is FHIR and needs to have basic auth in the header.  The OAuth token is passed to API Manager as a parameter.  I want to send FHIR to the endpoint with a Bearer Token in the header instead of the basic auth that came into API Manager.  Has anyone used a transformation plug-in to solve a similar issue?

Hi developers!

We are glad to share what we have new in April Open Exchange release:

• Promo section for companies admins 
• Pagination for applications catalogue
• New application submission flow

Hi Developers,

See how a FHIR implementation can be built in InterSystems IRIS for Health, leveraging both PEX and InterSystems Reports:

⏯ FHIR Implementation Patterns in InterSystems IRIS for Health

Anyone hs encountered this?

04/13/21-07:21:28:522 (191540) 0 ECP: Lost net connection: Error 104=(Connection reset by peer)
04/13/21-07:21:28:522 (191540) 1 ECP: connection from 'ECP1:HIS-AAA4:CACHE' dropped (1.1.1.1:14400)
04/13/21-07:21:28:672 (198470) 0 ECP: Mirror Connection request from 'ECP1:HIS-AAA:CACHE' (1.1.1.1:14419)

We are looking at moving from Cache to IRIS, if we do this we will want to use Intersystems Reports.  We have a lot of Crystal Reports to convert.  is there a conversion tool or best practice for doing the conversion 

Hi, in the end I want a report like this:

In my case I have about 1,230 tables/views in the database.  The initial approached I've used is to use this SQL to generate SQL to make the actual measures:

SELECT 
string('select ''', table_schema ,''' as "Schema", ''', table_name,''' as TableName, COUNT(*) as RowCount from ' , table_schema,'.

Hi Community,

I see the announcement https://www.intersystems.com/news-events/news/news-item/intersystems-ir…. But I didn't find in the AWS marketplace. Do you know where find this option?

GA releases are now available for the 2020.4 version of InterSystems IRIS, InterSystems IRIS for Health and InterSystems IRIS Studio.

InterSystems IRIS Data Platform 2020.4 makes it even easier to develop, deploy and manage augmented applications and business processes that bridge data and application silos.

Upgraded healthshare to health connect. The search box is not selecting the correct url 

i.e. selecting message loads 

http://penn-tietest:57772/csp/sys/EnsPortal.MessageViewer.zen?$NAMESPAC…

instead of this which when go through the menu it loads 

http://penn-tietest:57772/csp/healthshare/tie/EnsPortal.MessageViewer.z…

it actually loads from interopability view messages as 

http://penn-tietest:57772/csp/healthshare/tie/EnsPortal.MessageViewer.z…;

Please can someone advise 

Similar to Caché so also in IRIS,  you have ClassQueries available in 2 variants

• Basic class queries, which use the class %SQLQuery and an SQL SELECT statement.
• Custom class queries, which use the class %Query and custom logic to execute, fetch, and close the query.

Testing ECP-based applications often take quite some effort for setup and preparation.
I have created a Docker-based workbench that allows you to have it quick at hands.
And if you crash it? You just give your containers a fresh start.
The whole setup runs code-based during the start-up of your instance.
In that sense, it is also a portable coding example using ZPM and the objectscript-docker-template

 see Video

I'm almost running out of disk space so I want to move 1 DB to a different hard drive.  
It's a rather simple but lengthy action during a shutdown of IRIS.  
But is this somehow possible under runtime in a stand-alone installation?  
I'm looking for kind of a "local drive failover"  
note: Mirror or Shadow is not an option.  

Hey everyone.

I have been revisiting our backup strategy, and spotted that IRIS supports VSS (Volume Shadow Copy Service) in Windows. This is quite attractive as an approach, as it automatically calls the external freeze and thaw commands.

However when calling these manually, there's quite a few parameters that can be set, and the documentation around VSS only states that the freeze/thaw commands are called.

Is there a way of controlling the parameters used, or at the very least know what the defaults are?

In this case I am trying to just send a simple error to the log in the event the try is not successful.  Have tried a few ideas I have found on the forum but none have worked as of yet.  

   try {
          // Write facility Details to cloned message
      set newPV139 = (FacilityNPI1 _"^" _FacilityName _"^" _ServFacility _"^" _FacilityTIN _"^" _FacilityAddressLine1 _"^" _FacilityCity _"^" _FacilityState _"^" _FacilityZip _"^" _CountyName _"^" _FacilityPhone)
      set newPV139insert = newrequest.SetValueAt(newPV139, "PV1:39(1)")
            } 
                 catch exception {

            }

Ever noticed that the Type column of the Web Applications page in the Security section of Management Portal is showing you redundant information?

Hi Developers, 

It's time to announce the Winners for March 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in March 2021:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈@Dmitriy Maslennikov, Co-founder, CTO and Developer Advocate, CaretDev Corp, Russia

🥉@Henrique Dias Dias, System Management Specialist / Database Administrator, Sao Paulo Federal Court, Brazil

Learn more about the competition and our awesome winners below.

Hi All!

Examining the page here I see we have one-to-many and parent-child relationships supported in the InterSystems Objects model.

Do we support one-to-one too?

anyone know of a simple way to search a blob of text from a list of keywords in one fell swoop, without having to iterate through each keyword and perform an individual search? Ex. 

s keywords="This,blob,text"

s text = "This is a sample blob of text"

i text[keywords w "hit"

Hello,

I am trying to figure out if we can extend a business process in IRIS. My Use Case is that I am developing RESTful Interfaces and my each REST Interface needs to go through certain processes before getting to the actual action.  

e.g. I have 2 REST Interfaces, GetPatient and GetEncounter. Both of these need to invoke "GetToken" Business Operation to go to the Authentication server to get an authentication token before they go ahead and hit the Business Operation to Get the data i.e. Patient or Encounter.

I'm looking for a way to have an IRIS db distributed over several (hw) drives.  
Without touching the internal data structures (e.g. mapping) !  
Are there any options in file systems to achieve this "splitting" or "appending" ? 

Historic background:

• Once upon a time CPUs worked on 32 bit
• Files could mostly not be larger than 2 GB
• And Caché had a (forgotten) option to EXTEND a db to a next file of another 2 GB max. and a next ...

This EXTENT was excellently suited to move fresh and active data
to a faster spindle for more performance.
 

[ oh

After running an extensive block of daily statistics my IRISTEMP has expanded dramatically.   
But FreeSpace shows 97% unused and FREE space.   
How can I shrink IRISTEMP in runtime without shutdown and manual intervention
(which was the traditional approach)

Hey Developers,

Please welcome the new video on InterSystems Developers YouTube:

⏯ System Alerting & Monitoring

We have a Unicode installation of Cache'. A client wants to send us documents that will be machine-read and loaded, automatically. They want to create the documents in ISO-8859-1 ("Latin-1"). We'd need to convert the text to UTF8 for our system. I saw the documentation on the $ZCONVERT function, but I didn't see this option. How should it be done?

Thanks!

Hi guys,

I've created an iris command line utility to interface the Linux command line with Interface IRIS

https://github.com/RamSailopal/iriscmd

It maybe of use to some of the community

Ram