Question Oliver Wilms · Jul 28, 2020

Hello,

I work with IRIS for Health 2020.1 and I attempted to set up Enterprise Systems to populate Message Bank. I see entries in Message Bank Event Log from the defined Enterprise Systems.  I can browse Messages going back before I set up Enterprise Systems using Enterprise Message Viewer. However, I find no messages in Message Bank Viewer. Do I need anything extra to archive messages?

5
0 479
Question Oliver Wilms · Jun 25, 2020

Hello,

I am using a class based on %UnitTest.TestProduction to test Health Connect production.

I read in Class Reference IRIS for UNIX 2020.1:

Note: This class is not intended to be used in InterSystems IRIS instances.

Why should this not be used in IRIS? I have not seen any difference using this with HealthConnect 2017 or IRIS 2020.1

1
0 317
Question Oliver Wilms · Jun 11, 2020

Hello,

I want to deploy Iris Interoperability Production in multiple containers . The production has File Services that process files from EFS location. All the files being processed by multiple containers are in the same directory. The standard Adapter class does not have Check Complete option to lock a file so that other containers File Services looking in the same file path cannot process the same file.

I updated the Inbound File Adapter class to offer another Check Complete option LOCK that will lock the file until it is processed and archived.

2
0 336
Question Oliver Wilms · Jun 5, 2020

Hello,

How can I use ISC_DATA_DIRECTORY once IRIS runs inside a container? Some background...

We plan to deploy multiple containers running the same Health Connect IRIS Interoperability production in containers. So far we use docker run to start a container with ISC_DATA_DIRECTORY individual per container inside a efs that gets mapped using -v.

5
0 532
Question Oliver Wilms · Jun 3, 2020

Hello,

I work on a dashboard. I understand basic html. I like to draw two boxes in different colors on the background. There will be multiple small boxes inside or over the boxes in the background. I defined the large boxes as <div> and the smaller boxes also as <div> inside the larger <div>. So far so good.

How can I draw lines with arrows between the smaller boxes?

Each small box represents a process that gets a number in a circle and a status indicator: green = okay, red = not okay.

9
0 506
Question Oliver Wilms · Jun 3, 2020

Hello,

I work on deploying IRIS inside Docker container. I really like %Installer class can automate many steps. I want to establish an ECP connection to a mirror database and then define a remote database on the application server. I have already seen we can create local database and namespace in %Installer. What code is needed to establish ECP connection?

6
0 746
Question Oliver Wilms · May 27, 2020

Hello,

I work as a contractor for the Department of Veterans Affairs. I want to read data from an Excel workbook. I searched posts here and saw Apache POI suggested. I believe Apache POI is not approved for use within VA. I also believe we should be able to run SQL query against Excel. Has anybody done such a thing or are there other ways to read data from Excel workbooks?

Thanks

11
0 1559
Article Oliver Wilms · Apr 24, 2020 2m read

I enjoy the challenge of being in a contest. Currently I participate in InterSystems IRIS with REST API Programming Contest. My idea for this contest was to create an app to help me keep track of tasks for my Status Reports. I started with the template provided by Evgeny Shvarov. I created a persistent class for Tasks and a REST Dispatch class. I defined my URL map and I even figured out how to test my REST app using Postman. I felt proud of myself for a little while.

1
0 296
Question Oliver Wilms · Apr 9, 2020

Hello,

I was wondering if InterSystems has support for the following standards built into IRIS or Health Connect / Ensemble:

1.        Healthcare FHIR(Fast Healthcare Interoperability Resource) Protocol

2.        Enterprise Resource Planning OAGIS (Open Applications Group Integration Specification) Protocol / Supply Chain Management GS1-EPCIS (Electronic Product Code Information Services)

3.        Education, Certification, Credentials FERPA CEDS (Common Education Data Standards) Protocol

4.

3
0 476
Article Oliver Wilms · Mar 26, 2020 1m read

Hello,

I got the idea for this application, because for my work we have a process that currently uses legacy Vista code called MailMan to transfer files using email. I thought I could create a process in HealthConnect (IRIS Interoperability) to replace the need for having the legacy code. I have seen File Passthrough and TCP Passthrough Operations that can transfer a stream (file content) into a file or through TCP connection. I did not find Email Passthrough Operation, so I decided to create it. It receives request with a stream that has the content of the file.

3
0 236
Question Oliver Wilms · Mar 26, 2020

Hello,

While working on my Iris contest application FileMailer, I got an error today trying to send email with code that used to work. I added debugging entries and I can see it happens in %Net.SMTP class "Send" method. I am not using any credentials or SSL. I see it opens |TCP|25 device. It issues a series of commands to SMTP server (I was testing with smtp.va.gov and port 25). "init" command gets 220 response.  It runs "Login" method. Response is 250. The next command is "MAIL FROM" and I see 250 in the response with sender ok. The next command is "RCPT TO".

1
0 1273
Question Oliver Wilms · Feb 7, 2020

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? I believe in X12 schema it ignored leading control characters.

2
0 1134
Question Oliver Wilms · Nov 28, 2019

Hello,

 

I work with Ensemble Business Operation with SQL Outbound Adapter. I try to query a DSN defined database that happens to be Cache on the same machine in the same instance of Healthshare 2017.1.3. This worked fine on Linux server when I used JDBC driver. Now I want to run it on my Windows 10 laptop. I set up DSN and I can test connection successfully. I provided DSN in Operation DSN setting and I tried with and without Credential. I get ERROR <Ensd>ErrOutConnectFailed: ODBC Connect failed for 'myDSN'  / 'myDSN' with error ERROR #6022: Gateway failed: DSN/User Connect.

3
0 942
Question Oliver Wilms · Sep 18, 2019

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.

1
0 455
Question Oliver Wilms · Aug 26, 2019

Hello,

I started a post when I tried to display a line graph on a dashboard:

https://community.intersystems.com/post/dashboard-line-graph

This 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:

/// AETMON.Report
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, <var>$MODE</var>, is not present.

4
0 338
Question Oliver Wilms · Aug 13, 2019

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.
7
0 424
Question Oliver Wilms · Aug 12, 2019

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

1
0 311
Question Oliver Wilms · Jul 1, 2019

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

1
0 913
Question Oliver Wilms · Jun 18, 2019

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?

2
0 463
Question Oliver Wilms · Jun 13, 2019

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.

When it comes to Response Builder in the calling BPL, the array of objects property in callresponse is not a valid oref, it appears to be missing, other properties of types string or date are valued correctly.

2
0 611
Question Oliver Wilms · Apr 24, 2019

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.

1
0 277
Question Oliver Wilms · Jan 29, 2019

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?

3
0 836
Question Oliver Wilms · Jan 29, 2019

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'

Another BPL gets the same errors #5803 and #5002 with lock on instance of 'EDIGW.BPL.ST837.

3
0 633
Question Oliver Wilms · Jan 23, 2019

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.

1
0 373
Question Oliver Wilms · Oct 15, 2018

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.

3
0 947