Hey Developers,

This week is a voting week for the InterSystems Interoperability contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote? Details below.

Hi Developers!

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

• Business Process BPL or Business Rule DTL Usage
• Custom Interoperability Adapter Usage
• Production EXtension(PEX) Java or .NET usage
• Workflow Engine usage
• Docker container usage
• ZPM Package deployment
• Online Demo
• Code Quality pass
• Article on Developer Community
• Video on YouTube

See the details below.

Hi contestants!

We've introduced a set of bonuses for the projects for the Interoperability Contest 2021!

Hi Community,

Just a reminder to REGISTER for Virtual Summit. So many takeaways ... for example

Hello, I wonder if we can run SQL queries to find data in Lookup tables?

GitLab is using the rouge ruby gem, that apparently does not support ObjectScript at the moment. Is there an easy way to add syntax highlighting to GitLab ?

Once a week we are attempting to load an XML file from Workday into a MS SQL table using JDBC and Store Procedures. There is approx 102999 records in this XML file. We are struggling with processing the entire file within a reason amount of time. We feed the XML through a BPL to then populate values in a stored procedure then call the stored procedure through a Business Operation. I have tried splitting out the Business Operations to make two calls, but we still continue to see an issue loading the XML into MS SQL.

Fall into some good news from Learning Services, including:

• 2021 Virtual Summit Experience Labs and related online content
• Free Certification exam for Summit attendees
• Classroom training: CCR course free for qualified customers and partners
• Deal on migrating to InterSystems IRIS® data platform

Subscribe today!

UPDATE:
It turns out it was just me being a dummy, and the snmpd was correctly telling me there is no value associated with that exact key. I should have used snmpwalk instead of snmpget to display the whole tree.
Original Post follows:
Hello!
I'm trying to set up SNMP monitoring on Caché, using documentation and this article
I'm running net-snmp on Red Hat Enterprise Linux Server release 7.3 (with CentOS repositories), and Caché version 2017.1
It looks like snmpd is running as AgentX master, and Caché subagent is running too
/opt/cache/mgr/SNMP.

When I put a trace on a datastream that is a JSON object, I use the .%ToJSON(). Is there an equivalent to working with XML objects to view in the trace?

Why is it not common to handle inclusion, alteration and exclusion rules directly in the Caché database, using their controls on web pages, as is usually done in other databases such as Oracle, SQL Server? 

Hi developers,

We're hosting a User Group session for our Deltanji source control and Serenji debugger users on Wednesday, November 3rd at 11-12pm EDT / 3-4pm GMT.

We'll be showcasing some advanced features of Deltanji and Serenji in VS Code with time for a discussion - so feel free to bring along any problems you need help solving or share your feedback on our tools. We'd love to hear your thoughts. 

You can find out more on Eventbrite. 

Everyone is welcome. If you're interested in our tools this is a great chance to hear what others have to say, as well as asking your own questions.

We hope to see you on November 3rd! 

Hi,

I have very recently started to work with Ensemble and have both the 2014 and the 2017 version. 

To learn, I have created a small test flow that takes an xml file using EnsLib.EDI.XML.Service.FileService, sends it to a Process that transforms it with xslt into another format, and then passes it onwards to a EnsLib.EDI.XML.Operation.FileOperation Business Operation. 

This is the code that I have before and when sending it onwards:

set tStatus=##class(%XML.XSLT.Transformer).TransformStreamWithCompiledXSL(xmlStreamObj, tCompiledStyleSheet, .

Interoperability Read Only access

In companies, most of the time, we have test, stage and production environments.

It is very common that we, the developers, do not have the right to modify or touch the production directly because all the modifications must be traced in a versioning tool and tested before a production release.

However, a read access to the production (especially to the traces) can allow us to better understand a possible bug.

That's why I propose this ZPM module that creates a new role in IRIS that allows access to the productions and this only in read-only with access to the visual traces.

Do we hv any command to prevent the execution of update/delete SQL w/o “Where” Clause？ 

In the last years the data architecture and platforms focused into Big Data repositories and how toprocess it to deliver business value. From this effort many technologies were created to process tera and petabytes of data, see:

The fundamental piece to the Big Data technologies is HDFS (Hadoop Distributed File System). It is a distributed file system to store tera or petabytes of data into arrays of storages, memory and CPU working together.

I need to remove content below, from PID-3/HL7 message, in IRIS. However, I need to keep the content in PID-3.1. For example, I’d need to keep only, “5050532”. Can this be done in Data Transformations? If yes, how?
Thank you!

MSH|^&|TEMPUS|TEMPUS LABS|EPICEMR|YRMC|20210930100824||ORU^R01|4823623379495310173|T|2.3| PID|1||5050532^^^YRMC09abefb8-872b-4147-8e4b-77463bb235cb^^^^TEMPUS||

Hi Community,

The InterSystems IRIS has a good connector to do Hadoop using Spark. But the market offers other excellent alternative to Big Data Hadoop access, the Apache Hive. See the differences:

Source: https://dzone.com/articles/comparing-apache-hive-vs-spark

I created a PEX interoperability service to allows you use Apache Hive inside your InterSystems IRIS apps. To try it follow these steps:

1. Do a git clone to the iris-hive-adapter project:

$ git clone https://github.com/yurimarx/iris-hive-adapter.git

2. Open the terminal in this directory and run:

$ docker-compose build

 Virtual Summit 21 is only a week away, and our Experience Labs are filling up fast. Register today (for the summit, then for the labs).

hello!

i have object bellow

Set object = ##class(%ZEN.proxyObject).%New()
set object.city = "New York"
set object.Target = "TEST" 
set object.Details = "TEST"
set object.RefCode = "123"
set object.Reason = "123TTTT"

I want to get string from json object. 

Could you help please ?

We need to use SOAP API for some webservice. I created the request/response & operation classes via the SOAP wizard. Prior to making the invokeMethod, 

..Adapter.InvokeMethod

i need to set a custom HTTP header as part of the SOAP call. Can you please let me know how i can set that. That Adapter (EnsLib.SOAP.OutboundAdapter) class does not have methods for setting HTTP headers.

Thank you,

Ravi

Ensemble Log lost connection to arbiter, but no log in Windows, how to confirm connection did lost?

The InterSystems Certification Team is building an InterSystems IRIS Integration Specialist certification exam and is looking for Subject Matter Experts (SMEs) from our community to help write questions. You, as a valued InterSystems community member, know the challenges of working with our technology and what it takes to be successful at your job. In exchange for your assistance you will be compensated up to $500 per work assignment.

Hello Everyone ,

From Serial Device , i am getting only <CR> as line terminator , but ensemble expects <cr><lf> as line terminator . I couldnt change Line Terminator values in parser . Need help please

Thanks

Shilpi 

Hi,

Production is not auto starting even by adding  <Production Name="myProd.Production" AutoStart="1"/> in installer.cls file:

Thanks

If I open a terminal and type the following commands, sc is an error:

set validator = "sc = ##class(%Library.Numeric).IsValid(""BLAH"")"
set @validator
write sc

At the end, when I write sc I get:

0 L'BLAH9
             DOCXT010,#e^zIsValid+1^%Library.Numeric.1^1e^^^1

However, if I call the following class method using the arguments "%Library.Numeric" and "BLAH", sc is undefined

ClassMethod testvalidator(class As %String, value As %String) As %Status{set validator = "sc = ##class("_class_").IsValid("""_value_""")"write validator,!set @validatorwrite sc,!

I work as an Integration Engineer for United States Department of Veterans Affairs (VA). I work on a Health Connect production which processes many RecordMap files. I do not fully understand RecordMaps and I wanted to develop an application for the Interoperability contest where I could learn more about working with RecordMaps. I browsed InterSystems documentation for inspiration on how to start. I was happy to find CSV Record Wizard. I had created a CSV file for my Analytics contest entry. I wanted to use it to test the CSV Record Wizard. It was not obvious how to use it.

Hi,

I am getting below message while generating package from ZPM

ERROR! ObjectScript error: <CLASS DOES NOT EXIST>zGenerateModuleXML+21^%ZPM.PackageManager.1 *%ZPM.PackageManager.Developer.ModuleTemplate

Thanks

Hey Developers,

Welcome to the next InterSystems online programming competition: 

🏆 InterSystems Interoperability Contest 🏆

Duration: October 04-24, 2021

Our prize pool increased to $9,450!

Hello everybody,

I am trying to export a class to xml and remove the tag "xmlns" from mother class. These are my classes to create the XML.

Class Class.Test Extends (%RegisteredObject, %XML.Adaptor)
{ 

Parameter NAMESPACE = "http://mynamespace.com/test"; 
Property Person As Class.Person; Property Address As Class.Address; 

}

Class Class.Person Extends (%RegisteredObject, %XML.Adaptor)
{ 

Parameter NAMESPACE = "http://mynamespace.com/test"; 
Property name As %String; Property age As %String; 

}

Class Class.Address Extends (%RegisteredObject, %XML.