#Ensemble

Hi Developers,

I have created SOAP webservice , did not mentioned any security. Configured business service.

When I try to invoke from soaup UI, getting below error.

Hi Guys,

I was testing the Zen report from Samples namespace ( ZENReports.PageLayouts) by changing the DEFAULTMODE  from PDF to xlsx and html and noticed that each time I get different output and fields! I thought that the output should be the same and the only difference would be the report format, or am I missing something? try yourself and you will see.

Thanks

I'm seeing trace messages being logged in a Router Business Process Routing Rule when the Business Process Log Trace Events setting is off.

In what circumstances is that setting ignored or not seen when logging trace messages?

Problem to Solve: When an HL7 message hits a particular Process, I need to use the placer order number therein to query the messages that came in over the last 24 hours on a particular Service and grab discrete pieces of data that came in the latest message that has that placer order number.

The code I'm (currently) using looks like this:

<assign property='FullMessage'     action='set' value='"PID||TEST"' />
<sql>
    <![CDATA[SELECT Full_Message INTO :FullMessage, head.ID As ID, {fn RIGHT(%EXTERNAL(head.TimeCreated),999 )} As TimeCreated,
head.SessionId As Session,
head.Status As Status,
CASE head.IsError WHEN 1 THEN 'Error' ELSE 'OK' END As Error,
head.SourceConfigName As Source,
head.TargetConfigName As Target,
head.TargetConfigName,
head.MessageBodyClassName As BodyClassname,
(SELECT LIST(PropValue) FROM EnsLib_HL7.SearchTable WHERE head.MessageBodyId = DocId And PropId=7) As SchTbl_ORC2,
EnsLib_HL7.SearchTable.PropId As SchTbl_PropId,
head.MessageBodyId As BodyId,
EnsLib_HL7.Message.%ID As Body_ID,
EnsLib_HL7.Message.RawContent AS Full_Message
FROM Ens.MessageHeader head, EnsLib_HL7.SearchTable, EnsLib_HL7.Message
WHERE Head.TimeCreated >= DATEADD(day, -1, GETDATE())
AND Head.TimeCreated <= GETDATE()
AND ((head.SourceConfigName = 'SITE ORM-ORU Inbound')
AND (head.TargetConfigName = 'SITE ORM 1 PreProcessor')
AND head.MessageBodyClassName=(('EnsLib.HL7.Message'))
AND head.MessageBodyId = EnsLib_HL7.SearchTable.DocId
AND EnsLib_HL7.SearchTable.PropId = 6
AND EnsLib_HL7.SearchTable.PropValue = '1234567890'
AND head.MessageBodyClassName='EnsLib.HL7.Message'
AND head.MessageBodyId=EnsLib_HL7.Message.%ID)
ORDER BY head.ID Desc
    ]]></sql>

<assign property='target.{PID:2}'   action='set' value='..Piece(..Piece(FullMessage,"PID",2),"|",3)' />

Hi Developers,

I have created SOAP webservice cls and configured as business service in ensemble. Now I have started the production.

Where can I find the wsdl for this new soap_service?

Thanks,

Prashanth

You might of seen or might of not seen my earlier post about Exporting a Production from 2018.1 to import it into 2021.1. I was able to get the export working, however I noticed in reviewing the data within the export, our previous Workday XML Schemas that we imported via XSD files were not in the export. When walking through the export process under Message Schema or vDoc Schema I could not find the missing XML Schema structures. Why aren't XML's part of the export process if they are used within the Production?

Hey Developers,

We have a requirement to develop SOAP webservice from existing wsdl. Consumers are currently consuming existing soap webservice exposed by other provider.

We need to implement same SOAP service in ensemble as consumers should not see any difference except endpoint url.

Here we need to develop SOAP service form existing WSDL, which is possible in java. Is it possible in ensemble?

Could you please give me some hints to way forward.

Thanks,

Prashanth

Hello developers, I'm a newbie to Intersystems technologies and I started to work with Caché and Ensemble, and to be more specific I'm working with systems integration. In a scenario where I need to develop new software from scratch, would it be better to develop this new software using REST APIs? Does anyone have any recommendations about courses?

I need to pull .zip file and unzip it to access the zip files contained in the archive using the web service call. Can any one suggest is there any option for to get the zip files.

Hi all,

I am busy trying out the %UnitTest.TestProduction class to implement some automated production testing.

I have a scenario which I am not sure how to get the final results of for assertion. Below is the scenario I am trying to test, with comments on what I have done.

• Receive a  request on a service (Service A).
• Send the request to the BPL
  • I use SendMessage of the TestProduction class.
• The BPL sends a request to a Business Operation (SendToProvider)
• The SendToProvider operation sends a message out to the Service Provider.
  DeferResponse is done.

So I've been reviewing a lot of questions posted in the InterSystems community regarding NULL properties in JSON. I've also been reviewing the JSON documentation. None of these things have been able to help me so far.

1. We don't seem to have the %JSON.Adaptor class available for us to use in our system.

2. I'm not really confident enough to create JSON Type classes or backporting code, etc.

I created a dummy class and I need my JSON to look like this:
{
    "notanumber":"28001",
    "aboolean":true,
    "anumber":12345,
    "adecimal":1.

Hi

I am a very experienced Ensemble and IRIS developer who has spent his entire career either working for InterSystems or with their products. I was a Senior Sales Engineer with InterSystems for 14 years with a further four years working for InterSystems TrakHealth. I started working for the InterSystems UK office and from there I spent several years travelling to InterSystems offices in Europe, Scandinavia, the Middle East, Israel and eventually ending up in the South African office. I moved back to South Africa in 2001.

We have a couple of systems that send us a URL link to a PDF instead of base 64 encoding it in the HL7 message. Has anyone ever tired to take that URL, and retrieve the file off of the server to save it off somewhere?

We have an interface that need to be disabled then re-enabled when it starts to queue up. I wrote the following code to do this functionality in a process. This works in our development domain, but in production it says it fails to disable the job - it only shuts down the interface without updating the production/starting the interface back up. Error message: "Failed to stop job '36831290' within 60 seconds. Status '<unknown>" 

Is there something wrong with how I'm trying to do this? 

set tSC = ##class(Ens.Director).EnableConfigItem(itemname,0,0) 

set tSC = ##class(Ens.Director).

I need to send the data from a view that returned NULL, but is going as empty. The fields are of type String.

I'm using: 

 SET tSC  ##Class

{
    "altura": "",
    "atendimento_id": "3060382",
    "data_atualizacao": "2021-12-16 10:39:12.0",
    "data_coleta": "2021-12-16 10:37:00.0",
    "data_liberacao": "2021-12-16 10:39:12.0",
    "dor": "1",
    "dor_nr_seq_result": "",
    "escala_dor": "",
    "escala_temp": "C",
    "freq_cardiaca": "80",
    "freq_respiratoria": "22",
    "glicemia_capilar": "",
    "ds_ritmo_ecg": "",
    "ds_decubito": "",
    "ie_derivacao_seg_st": "N",
    "ds_derivacao_seg_st": "",
    "nivel_consciencia": "",
    "pa_aparelho": "",
    "pa_diastolica": 80,
    "pa_manguito": "",
    "pa_sistolica": "120",
    "paciente_id": "903283",
    "peso": "",
    "profissional_id": "260",
    "prontuario_id": "903283-7",
    "sat_o2": "",
    "sat_o2_membro": "",
    "setor": {
        "id": "38",
        "nome": "7 A CLIN/CIR PEDIATRIA"
    },
    "temperatura": "36",
    "unidade_altura": "CM",
    "unidade_peso": "KG",
    "ie_o2_suplementar": "N"
}

Hello Community,

I am trying to insert multiple values in a table. Below is the simple sql statement.

Insert Into TableX

values ('Name', 'Address', 'Phone')

How can i do multiple inserts(rows) in one single statement?

Values are not in another table, so i cannot use Select into.

Thanks,

Jimmy Christian.

I need some help with unescaping a value in TXA 2 of an MDM message that I am writing to a variable, to be used in a filename for a PF. Would I use the method Unescape(pData) if so how can I use it in a transform to set the variable? The reason I need to do this is I need to use the name as file name when writing the PDF to a directory. The escape characters and invalid for file names .

Dear Community Members,

Has someone built some kind of Adapter (or other related components) to interact with Couchbase?

Something sharable?

What connection method did you choose - for example REST API / .Net or Java SDK?

Thanks!

I am working in Intersystems Healthshare product.

I want to clear the message logs from a particular interface (Service,process,operation). 

In intersystems we have the option to purge the data for all interfaces for the corresponding time but I want to clear the data logs for particular interface only.

Please let me know how to approach this scenario.

December 13, 2021 - Advisory: Vulnerability in Apache Log4j2 Library Affecting InterSystems Products

InterSystems is currently investigating the impact of a security vulnerability related to Apache Log4j2.

The vulnerability — impacting at least Apache Log4j2 (versions 2.0 to 2.14.1) — was recently announced by Apache and is reported in the United States National Vulnerability Database (NVD) as CVE-2021-44228 with the highest severity rating, 10.0.

Please see this page for more details about the vulnerability and updates on whether InterSystems Products are affected.

DTL Transformations and GetValueAt/SetValueAt calls on HL7 messages will truncate any fields longer than 32K.  To avoid this, the methods GetFieldStreamRaw and StoreFieldStreamRaw must be used when dealing with fields that might be larger than 32K.  OBX:5 is a frequent example.  These methods have some subtleties and must be used carefully.

This can't be done by simply dragging from left to right in a DTL.  It must be done with a code action.  Also, the StoreFieldStreamRaw call must be the last edit made to the segment because the segment becomes immutable after that.

We are seeing ERROR #5002: Cache error: <MAXSTRING>zSaveData+14 ^EnsLib.HL7.Segment.1 come up on a Routing rule when we are trying to Encoded PDF's through a DTL. In the DTL we are copying source to target. Is there a limitation on trying to copy source to target? 

At the bottom of the DTL you are see that we commented out converting the Encoded PDF to a Stream, is it recommended that we always use %Stream anytime we are dealing with PDF's?

Thanks

Scott

I am totally struck and last 3 days I am not able to progress much. Here I need to call POST method in REST endpoint in Business Operation.

Please find the code below, which is working fine in IRIS 2020.1 but not in cache 2017.

$$$LOGINFO("InvokeTokenAPI...")
try
{
Set httpRequest= ##class(%Net.HttpRequest).%New()
Set httpRequest.Server = ..Adapter.HTTPServer
Set httpRequest.Location = ..Adapter.URL
Set httpRequest.SSLConfiguration = ..Adapter.SSLConfig Set httpRequest.Https = $$$YES
Set httpRequest.ContentType = "application/x-www-form-urlencoded" do httpRequest.InsertFormData("grant_type",

Hi all, 
I'm trying to output a XML file, mapped from a ORU_R01 2.3 HL7 message, with a file name based of fields in the source HL7 message in the following format, 
source.{PIDgrpgrp(1).PIDgrp.PID:PatientIDInternalID(1).ID}_"-"_
source.{PIDgrpgrp(1).PIDgrp.PV1grp.PV1:VisitNumber.ID}_"-"_
source.{PIDgrpgrp(1).ORCgrp(1).OBR:ObservationDateTime.timeofanevent}
To give something like RXR0000000-000000123-20211125105415.xml as the output filename,
I initially tried to extend the EnsLib.XML.Object.Operation.

Hi All,

I have configured Business Operation with EnsLib.HTTP.OutboundAdapter and set properties.

In the BusinessOperation method  I am trying to create %Net.HttpRequest 

Set httpRequest= ##class(%Net.HttpRequest).%New()

to post REST Service.

I am able to access HTTPServer ,URL details form Adapter using below code

Set httpRequest.Server = ..Adapter.HTTPServer
Set httpRequest.Location = ..Adapter.URL

How to read SSLConfiguration from Adapter properties?

As of now , I am hardcoding same string which I have configured for BusinessOperation Settings tab

Set httpRequest.

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.

Created by Daniel Kutac, Sales Engineer, InterSystems

Warning: if you get confused by URLs used: the original series used screens from machine called dk-gs2016. The new screenshots are taken from a different machine. You can safely treat url WIN-U9J96QBJSAG as if it was dk-gs2016.

Part 2. Authorization server, OpenID Connect server

In the previous part of this short series, we have learned about simple use case – acting as an OAUTH[1] client. Now, it’s time to bring our experience to a whole new level.

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 = ##class(%FileBinaryStream).%New()
          set Oref.Filename = Path_FileName

          Do base64.Rewind()

          While 'base64.AtEnd 
          {
                set ln=base64.ReadLine()
                set lnDecoded=$system.Encryption.Base64Decode(ln)
                do Oref.Write(lnDecoded)
          }

          Do Oref.%Save()
          return Oref.Filename
     }

}

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

Hi Guys,

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

Thanks