#Ensemble

I need to split a large XMLfile  into multiple smaller ones, grouping by an element multiple iterations deep.

In XSLT 2 I use for-each-group  group-by,  which perfectly does the trick.

I wonder if it is possible to do the grouping  in DTL?

When a X12 message comes into Ensemble as a Whole Batch how do you search on a segment within the body of the message? For example, a REF segment. It appears the only way is to set the Service to a single session batch, but this doesn't allow you to send the message as a Whole Batch to the Operation.

We're moving an Ensemble production from Ensemble 2010 to Ensemble 2017 and in it we have a ebXML SOAP Service.  It extends EnsLib.ebXML.Service.SOAPService and just contains one method with a method keyword of SoapAction = ebXML.

We're receiving a SOAP message with a SOAP action = urn:nhs:names:services:pdsquery/QUPA_IN000011UK02 and this is getting rejected with the error message ERROR #6207: Unexpected SOAPACTION value: urn:nhs:names:services:pdsquery/QUPA_IN000011UK02

Hi, guys,

I've written a DT for a partner which transfers a csv file into SDA3. 

I', using record map to gather data from a folder storing csv files and using the DT to tranfer the records into sda3 entities.

The followings are the codes of that DT:

Class POC.DT.CSV2SDA3 Extends Ens.DataTransformDTL [ DependsOn = (User.PhysicalExam.Record, POC.SDA.Container) ]

{

Parameter IGNOREMISSINGSOURCE = 1;

Parameter REPORTERRORS = 1;

Parameter TREATEMPTYREPEATINGFIELDASNULL = 0;

XData DTL [ XMLNamespace = "http://www.intersystems.com/dtl" ]

{

Hi

we are trying to call a Webservice that is hosted on a Ensemble production from a .net program.

The web application in ensabmle is defined with password authntication 

we can't get to set the security header in the .net program  (<soapenv:Header> ... <wsse:Security ... <wsse:UsernameToken  ... ) in SoapUI we added the Wss usertoken and it worked like a charm.

Doe's anyone have a idea to guide us? (links,  ,samples, etc. )

Thanks

Gadi

Hi, 

how can I check repeating XML fields in a rule?
I want to search a repeating sub Element fields for one or more numbers.
Subelement(*) returns the counter of the elements, but I expected by a () to search all fields.

Kind regards 

Armin

Receiving this error ERROR #5002: Cache error: <MAXSTRING>zgetAtFromArray+28^EnsLib.HL7.Segment.1

what is the max size for an encoded PDF using the GetFieldStreamRaw code

Hi Guys,

I've the below query that selects the existing processes with dates & times and it working fine, but in case of records with the same processedDate I would like to only get the latest based on processedTime field?

basically, bellow is and example of my query currently produce, where records 2 & 3 are the similar with different times   :

1,  record1 ,10/02/2022 ,13:40:00

2,record2,11/02/2022, 14:11:00

3,record2,11,02,2022,16:00:00

4,record3,12,02,22 , 11:00:00

and in this case I would like my query to get the latest record in time to achieve the following:

1,  record1 ,10/02/2022 ,13:40:00

Hi Community,

We need to export last 5 days Ens.MessageHeader data for a specific messages into file. I have written custom code to execute SQL query in object script.

Could somebody help me to iterate resultSet and write the data to text file.

Hello,

We have recently received the two following errors as part of a PDF extraction process and I am trying to figure what the difference is between the two errors?

1. ERROR <Ens>ErrException: <MAXSTRING>zGetReferralDocFromStream+30^UCLH.SIP.Operation.PBT.HTTP.V1.RefDocRequest.1 -- logged as '-' number - @' set file=object.%Get(i).file'
 

2. ERROR <Ens>ErrException: <STRINGSTACK>zGetReferralDocFromStream+30^UCLH.SIP.Operation.PBT.HTTP.V1.RefDocRequest.1 -- logged as '-' number - @' set file=object.%Get(i).file'
 

Can someone please explain what the difference is?

Thanks!

I was wondering if there was a certain procedure or documentation on securing (Https://) the Web Portal into IRIS/Ensemble?

Currently we are using LDAP Delegated Authentication to access the Web Portal using LDAP. However as more and more emphasis is put on securing applications within networks, I can see Management/Security asking us to make sure that the web portal is more secure.

Maybe I am not looking at the right place for documentation, but is there a Best Practice guide, set of instructions, or Online learning that can help guide me in trying to make our environment more secure?

Hi guys, just a quick question on how get the sql statement that has been executed in a %ResultSet?

so basically after the execute command I would like to save the SQL statement generated in a eg, a global and check sql statement?

Set rset1 = ##class(%ResultSet).%New()
Set sc = rset1.Prepare("Select statment ")
Set:+sc sc = rset1.Execute(parm1,parm2)

Maybe something like s ^sql=rset1.Getstatment !?

Thanks

Hi guys,

I've two Ensemble instances running in a 2016 server but only one of them showing in startup programs.

the ensemble cubes doesn't showup in the programs list from the Start button as well so how can I add the cube so I can access it's facilities (Studio, MP,...etc)

Thanks

Hi Community, 

New video is already on InterSystems Developers YouTube! Learn about the easy process of migrating to InterSystems IRIS:

⏯ Join Us on a Journey from Caché/Ensemble to InterSystems IRIS

Currently running Ensemble on Red Hat Enterprise Linux Server release 7.7

One of our clients is requesting files sent to their SFTP site be encrypted with their PGP public key and digitally signed with our PGP private key

We have created a custom class that includes the following command to encrypt the files

ERROR #6279: XML output string length is greater than the maximum string length.

This is Error I am getting while trying to get data from an obj and write into the test file.

Any Suggestions Please..

Requirement: Transform source XML message to target JSON.

step1: First create json equivalent xml from any online tool.

step2: use add in  studio utility create persistent classes from json equivalent xml and compile it , now target persistent classes are ready

step3: Do the above step for source xml or xsd and generate persistent classes for source and compile it

step4: complete the DTL by selecting root node from source, target persistent classes and complete the mappings and compile it

step5: use the below code to apply Transformation on source XML string and create Target JSON

Hi Community,

I have created persistent classes for source, target XSDs and completed DTL. When I tested in DTL window by passing source xml it is generating below target xml as result.

DTL result:

<root>
  <CaptureSource>2</CaptureSource>
  <Document>
    <Description>1235@TEST.COM.Message.ReportType</Description>
    <EventDate>1489@TEST.COM.Message.EventDateZ</EventDate>
    <ExternalSystemId>1213@TEST.COM.Message.ReportID</ExternalSystemId>
    <FileContent>1142@TEST.COM.Message.TextBlock</FileContent>
  </Document>
</root>
 

Hi Guys,

I've set DEFAULTMODE ="xlsx" in my report to be exported to Excel but it's exporting as .zip, is there something I need to add or set or maybe MS Excel to be installed in the server?

Thanks 

I have a user value set for an HL7 component that was removed from the source message.  How can I pull that value for use in a Routing Rule suppression logic?  Or do I have to create a custom class in order to do so?

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:

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? Where are the XML Schema's kept within the Ensemble structure so I can see if

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.