Hello Jack,

I have done this previously in this class:

Class User.OperationSQL Extends Ens.BusinessOperation


Parameter ADAPTER = "EnsLib.SQL.OutboundAdapter";

Property Adapter As EnsLib.SQL.OutboundAdapter;


I have this code to begin transaction:

set tSC = ..Adapter.SetAutoCommit(0)

I have this code to commit transaction:

set tSC = ..Adapter.Commit()

In case of rollback I use this code:

Set rollbackSt = ..Adapter.Rollback()


Thank you for documenting this in great detail. I carefully created a namespace, compiled classes, configured global and package mappings.

I created and compiled cube class User.OperationalAnalytics.

My problem is when I try to use Analyzer in Portal, I get an error when I drag the second property AvgTime to Columns:

ERROR #5001: Build [Measures].[AvgTime] in cube OPERATIONAL ANALYTICS. (2)


The Feeder app uses %UnitTest.TestProduction class to run a test (TestControl)  that has intention to test another production via test messages being sent from File Passthrough Service to CSP Operation. I feel it should qualify for Unit Test bonus. Please reconsider. Reading your comments here, I see you do not encourage using legacy CSP approach. What is suggested to replace CSP? Is it Angular front end? Do you have tutorial for using Angular? Does it offer native API use in Angular?

Good morning Vic,

I had not filled in the Message Bank Link, but it was prefilled already. However, when I try to click on Go button, it links to:


The correct link on the Message Bank server is:


The URL on the server is /csp/healthshare/dmlss_db instead of /csp/dmlss_db

Is this the reason why the Message Bank does not receive any messages?

I created a new web application /csp/dmlss_db on the Message Bank server. The Go button now works from Configure Message Bank Link. However, still nothing going into the Message Bank.

I was able to define ECP connection in Installer class that I run when I build docker image for my Docker IRIS application. Now I start to use Amazon ECS and Autoscaling. When a new instance is created and it runs the IRIS container, I want it to "register" as an Application server on the remote database server. What code can I execute to add an ip address as an Application Server?


I hesitate to use any libraries as I work for Department of Veterans Affairs and they are very picky what is allowed. I see that Ens Portal Production Configuration has dot indicators for status green is okay or red is error and it also draws lines between connected components.

It is SVG. I was able to draw rectangles, circles, and lines. The code creates rect elements for boxes and text elements for text. My question is how can I force text to wrap and stay inside a rectangle?

Good morning Vic,

Yes, we want to be able to have multiple productions in containers pulling files from one location. I do not want to use different FileSpecs, because if one container goes away because of scaling down or error, I want the remaining container to continue processing.

I agree that work path helps, because when one container processes the file, it is moved to work path, and not visible to others monitoring the file path.

When we tested the file lock option with two containers processing 56 files, it appeared to avoid collisions. The other option appears to be more complex especially with variable number of containers. 

I have uploaded part of the block diagram our boss likes a lot because he can see messages flow (arrows), message types (lines), and points of contact (on the right) on one page. The green check marks indicate everything is okay. If something goes wrong, the numbers refer to the points of contact on the right so support knows who to contact. I envision there will be drill down to more details. I do not want to represent the diagram pixel by pixel, but I look for ways to draw lines and arrows.

Class Ens.Config.DefaultSettings Extends (%Persistent, %XML.Adaptor). So it is fairly easy to write a class method to update the Default Settings based on Environment var ISC_DATA_DIRECTORY. Next question is, when to call this class method. On Container start? How does this work? On Production start might work but it really only needs to run once. I guess I could check if it already ran, and do not go through all settings each time production starts. If you read this, thanks for your attention and have a good weekend

I just tested  write $System.Util.GetEnviron("ISC_DATA_DIRECTORY") and it returned the ISC_DATA_DIRECTORY of the persistent instance.

Currently our application gets file path for file services and operations from System Default Settings. What is a good way to update the System Default Settings based on $System.Util.GetEnviron("ISC_DATA_DIRECTORY")?