Article Oliver Wilms · Mar 26, 2020 1m read Iris Contest FileMailer Application Hello, #Contest #Interoperability #InterSystems IRIS Open Exchange app 1 3 0 175
Question Oliver Wilms · Mar 26, 2020 SMTP ERROR #6033: Error response to SMTP DATA: 500 #5.5.1 command not recognized. Hello, #Contest #Interoperability #Caché #Open Exchange 0 1 0 1.1K
Question Oliver Wilms · Mar 21, 2020 Send Email from Iris Contest Application Hello, The application I am working on for Iris Contest needs to send an email. Is anybody aware of a configuration for SMTP server, port, credentials that I can use for the contest or any demo application? Thanks, Oliver #Testing #Open Exchange 0 1 0 235
Question Oliver Wilms · Feb 7, 2020 Ignore Control Characters (Carriage Return and Line Feed) in Complex Record Map I understand RecordMaps can be used to send delimited files through a production without custom coding. The data segments are delimited by tilde character followed by $Char(10) in Linux/Unix. When I test the same IO data in Windows, I have $Char(13) and $Char(10) instead of just $Char(10). I like to use just tilde character for record delimiter and ignore $Char(13) and $Char(10) between the tilde and the leading data of the next segment / record. Is this good idea or not if someone wants to generate classes will it override code? #Coding Guidelines #Ensemble 0 2 0 977
Question Oliver Wilms · Nov 28, 2019 InterSystems Cache DSN Hello, #Business Operation #ODBC #SQL #Ensemble 0 3 0 782
Question Oliver Wilms · Sep 18, 2019 Export Report to Excel Hello, I created a Zen Report and I want to export to Excel. I read I can use $MODE=xlsx but my output in Excel is not correct. All 3 elements are condensed into one cell. Class AETMON.Report Extends %ZEN.Report.reportPage { /// Class name of application this report belongs to. Parameter APPLICATION; /// Specifies the default display mode used for this report if /// the URL parameter, $MODE, is not present. #ZEN #Caché 0 1 0 384
Question Oliver Wilms · Aug 26, 2019 Line Chart - My first Zen Report - I see no line Hello,I started a post when I tried to display a line graph on a dashboard:https://community.intersystems.com/post/dashboard-line-graphThis did not work very well. I switched gears and now I have a Zen Page that includes a Zen Report in iFrame. However my line chart does not display a line.This is my Report class: #Graph #ZEN #Other 0 4 0 248
Question Oliver Wilms · Aug 13, 2019 Dashboard - Line Graph Hello,I want to create a dashboard with a line graph that shows system availability over time. I used this code to create a Dashboard: Set tItem = ##class(%DeepSee.UserLibrary.Link).%New() Set tItem.fullName = "Availability" Set tPage = "Availability.UI.CSVImport.zen" Set tItem.href = $system.CSP.GetPortalApp($namespace,tPage)_tPage Set tItem.title = "Availability" Set tSC = tItem.%Save() #Dashboards #Monitoring #InterSystems IRIS BI (DeepSee) #Ensemble 0 7 0 325
Question Oliver Wilms · Aug 12, 2019 Expand EnsPortal Hello, How should I go about it to add a page to the EnsPortal? I want to display a dashboard like page and I would like to be able to have it accessible from Management Portal. I hope there is a better way than typing the URL in address bar. Is the menu for Management Portal editable? Thanks, Oliver #Management Portal #Ensemble 0 1 0 219
Question Oliver Wilms · Jul 1, 2019 Open a text file in Windows - Append to existing log file Hello,I try to open an existing log file and append to it. In Windows I use Open file:(NRW):1. I would expect it to append to the file, but each time I execute the code I get only the new entries, the prior file content is lost.What is the proper syntax top open a file in "Append" mode?I will deploy this code in Linux. Is there a different syntax to open a file in Linux versus Windows?Thanks,Oliver Wilms #Platforms #Caché 0 1 0 761
Question Oliver Wilms · Jun 18, 2019 Create new loops in DTL X12 Document Hello, I have a DTL to transform X12 Document 278 Request to 278 Response HIPAA 5010 schema. The DTL is called from BPL. I defined a class method that receives source, target, and context objects. How can I create 2000F loops in the response when there were none in the source object? #DTL #Ensemble 0 2 0 375
Question Oliver Wilms · Jun 13, 2019 Array of Objects inside Response Message Hello,We have a BPL that returns in Response several %Strings, Dates. When we try to add Array of Objects property to the Response we verified just before the BPL terminates the response object has correct values in all properties including the array. We checked the Count(). It appears that even array of String works correctly but we prefer to pass objects rather than strings. #Business Process (BPL) #Ensemble 0 2 0 519
Question Oliver Wilms · Jun 6, 2019 Parsing JSON objects - Can Dynamic Objects be saved in persistent classes? Hello,I want to parse large JSON object and store data into persistent tables. Is there any other way besides pre-defining persistent classes including typing each property name? Maybe parse it and store properties into a global so that I know what properties need to be defined for each class...Thanks in advance for your thoughts #JSON #Caché 0 6 0 973
Question Oliver Wilms · Apr 24, 2019 80 bytes wrapped X12 files Hello, our X12 File Service won't process files we encountered X12 files where they inserted CR LF after 80 bytes repeatedly in the middle of segments. X12 Parser does not seem to like it. I see there is a Whitespace property in Adapter. I am not sure if it ignores white space in the middle of a segment. I also heard about TolerateNewLine setting but I believe this also does not tolerate New Lines in the middle of a segment. We will probably have to read the file, strip out any CR and LF, write to a new file that the X12 file service can process. #Ensemble 0 1 0 215
Question Oliver Wilms · Jan 29, 2019 Production is not valid - Ens.Config.Production Hello,We are in process of moving our first Production from development to test. We exported our project from Studio. On test server, we cannot Open the Production because it is not a valid production because nothing exists in Ens. Config.Production class. What are we missing? How do we add our Production in Ens.Config.Production? #Deployment #Ensemble 0 3 0 673
Question Oliver Wilms · Jan 29, 2019 Errors using Ensemble BPL, FileService, persistent object %Save() fails, Error #5803, Error #5002 Hello, We have defined four BPL Business Processes. One gets occasionally errors when pool size is two. No errors happen with pool size one. The error happens on calling %Save() on a large objects with many references to other objects. Error #5803: Failed to acquire exclusive lock on instance of 'classname'. Error #5002: Cache error: <ROLLFAIL> %TRollBack+10^%occTransaction The error happens on a particular large object. Our FileService gets the same Errors #5803 and #5002 with class 'EnsLib.EDI.X12.Document' #Business Process (BPL) #Object Data Model #Ensemble 0 3 0 533
Question Oliver Wilms · Jan 23, 2019 BPL <call> element with async='False' Hello, we have a couple of BPL processes. This works with a limited amount of messages but we run into issues when we process thousands of messages in a session. One BPL calls a Validation BPL process with async='False' and there is a response defined. The timeout is two seconds and that seems to be plenty of time for the validation process. I expected the calling process to wait for a response but that is not happening. #Business Process (BPL) #Ensemble 0 1 0 296
Question Oliver Wilms · Oct 15, 2018 Trying DTL to Persistent Table - No data gets to table Hello, our Team is trying to develop Ensemble DTL to transform incoming X12 files into persistent data records. We created a persistent class and we can insert data using SQL. We tried to verify that %Save() gets called by adding %AddToSaveSet() method to persistent class and there writing to a global. We had to extend our persistent class with Ens.VDoc.Interface class or we could not see %Save() being called from Ensemble DTL. We suspect that %Save() gets some kind of error. We tried to debug by overwriting Transform() method in our DTL class. #DTL #Object Data Model #Ensemble 0 3 0 803