New post

#Ensemble

28

InterSystems Ensemble is a complete and easy-to-use integration platform that enables users to connect people, processes, and applications in record

time.

Learn more

Documentation

InterSystems has corrected two defects that, in rare circumstances, can result in data integrity corruption after running global compaction, database compaction, or database defragmentation. InterSystems recommends avoiding these utilities until after applying the corrections listed below.

0 0
0 283

I've got a class that extends FTP.PassthroughService and utilizes the FTP.InboundAdapter. In Business Service, I have the FilePath set as /tmp and the subdirectory level = 1. How can I access the current file path (/tmp/subdir1) when there are files in /tmp/subdir1/test.txt for example? The ..Adapter.FilePath only returns the FilePath setting in the Business Service/Adapter but not the subdirectory level. Of note, it is a SFTP connection. I can access the %Net.SSH.SFTP from

0 1
0 369

While I am not new to HL7, I am very new to Ensemble.

We have a request to change the order in which the Addenda segments are sent to the client. Right now, the global setting of the Lab system is to send the newest addenda at the top of the report, then the next oldest, and so on until we get to the final report:

OBX|1|||*****Addendum 3****
OBX|2|||text 3
OBX|3|||*****Addendum 2****
OBX|4|||text 2
OBX|5|||*****Addendum 1****
OBX|6|||text 1
OBX|7|||*****Final****
OBX|8|||final text

0 1
0 398
Question
· Aug 3, 2020
INSERT OR UPDATE SQL

Hi, I want to INSERT a customerID and customerName to a table if the customerID does not exist. Or UPDATE if they've changed their name.
I've reviewed the documentation (https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=RS...) and have confused myself with the INSERT OR UPDATE statement. Rather than using two individual statements , is there a way to get it in one?

What I have at the moment doesn't do anything. In fact it errors.

0 3
0 562

I am able to get a service class property DISPLAYLIST into the SETTINGS PARAMETER using the below example from the documention but I am not able to get an adapter property in the same manner. Is there a way to obtain the DISPLAYLIST values from an adapter property into the SETTINGS Parameter?

for reference I am extending the adapter: EnsLib.HL7.Adapter.TCPInboundAdapter

Example from documentation:

selector?context={Ens.ContextSearch/getDisplayList?host=@currHostId&prop=Framing}
0 2
1 400

We use ExecureProcedure() to execute a stored procedure which returns a result set. But we see lot of "Invalid cursor state" errors when the result set is empty. The connection to SQL server database is made through ODBC.

ERROR #6022: Gateway failed: Fetch. + ERROR <Ens>ErrGeneral: SQLState: (24000) NativeError: [0] Message: [Microsoft][ODBC Driver 11 for SQL Server]Invalid cursor state

Here is the code snippet from the business operation class which uses EnsLib.SQL.OutboundAdapter

0 2
0 9.7K

Hi,

I'm processing POP3 emails using the standard EnsLib.EMail.InboundAdapter adapter and %Net.MailMessage. I'm basically processing documents that are attached to received emails. This works fine if the document is simply attached to the email itself. But some systems are sending documents that are attached to an attached email which has content-type = message/rfc822.

How do I get the attached file from the attached email?

0 3
0 790

A permanent job opportunity has arisen for a Caché/Ensemble /Iris developer with at least 3 years experience. My client is a specialist resource provisioner of developers for high profile clients in the finance, healthcare, retail, distribution and credit business that are mainly based in central London. My client is looking for a highly-motivated individual who thrives in an environment where problems are open-ended.

0 0
0 475
Question
· Jan 20, 2021
Multiple Threads In Operations

I have a BPL that calls a business service (actually does lots of other things unrelated to my question). We receive an acknowledgement back containing data that is processed in the BPL and sent to the source system. The process of sending to our downstream system "A" and receiving the response takes about 20 seconds per transaction (very slow on system A's side). Due to this slowness, we end up with a backlog close to 1000 messages by the end of the workday.

0 4
0 570

Hi Guys,

I currently have a service that uses an InboundAdapter to get a JSON file and process it given that the client is pushing data to us, but now we have another client where we need to request the JSON file by sending a HTTP request then get the file and process it, kind of a Get rather than push, how can I create a service that handle that?

0 1
0 301
Question
· Oct 13, 2022
JDBC Gateway Server Crash

I am trying to troubleshoot an issue I am having with the JDBC Gateway Server crashing at the %SYS level. I have numerous Linked Tables that are using JDBC to connect to a MS SQL database/tables to query values. I have written queries in other class files and within the class definition of the linked table to do the queries.

1. Should I be running the query in the class definition of the linked table as a class method? or is it best practice to run the query as a class method outside of the class definition of the linked table?

0 3
0 244

This error I am getting when I am updating cache.dat file:

02/13/23-22:38:11:880 (3444) 3 Error: ERROR #5002: Cache error: <FUNCTION>LoadDLLs+27^STU - Shutting down the system.

This error I am getting whenever I am compiling any of my production or compiling Enslib.HL7.Adapter.TCPOutboundAdapter

#5002: Cache error: <SUBSCRIPT>ConstructCompileTree+72^%occInherit ^oddCOM("")

Can anyone help me with this ?

0 2
0 181
Question
· Apr 17, 2023
Find a specific column in a dataCombo

Hello,

I've the below datacombo definition and when selecting an item from it and make this call:

var component=zen("Component").getProperty("value");

I would get the ID (first column) which is what I'm looking for

0 0
0 169

Has anyone had success with passing in a collections property within a SOAP request to a Soap Service in Ensemble? Please reply with how you set up that collections property. I am able to successfully send a SOAP request correctly containing the elements of the collection property to Cache, as seen in a custom soap log file which I am using to troubleshoot. But the collection property in the Ensemble request is not getting serialized, meaning MyContainers has nothing.

My.Request consists of a property, MyContainers, which can have 0 or more Containers (My.Container)

0 1
0 191