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

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.

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

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:

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

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^^^YRMC~09abefb8-872b-4147-8e4b-77463bb235cb^^^^TEMPUS||

Virtual Summit 21 is only a week away, and our Experience Labs are filling up fast.

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

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

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

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

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.

Hello All,

I am receiving this error when attempting to place a file in a local SFTP server.

ERROR <Ens>ErrFTPPutFailed: FTP: Failed to Put file '101320210700.RAW' (msg='Error in SFTP Put('/healthshare/mgr/Temp/VPacx9a1eq0b5g.iostream','/SFTP/unmhsmcsa/OUT/101320210700.RAW') ERROR #7504: Timeout',code=0)

Any help is appreciated.

Below are my settings