Hello,
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)
I observed <UNDEFINED> error when trying to populate the table because there was no activity in the namespace. Initialized tNumInbound and tNumOutbound variables and ran the Task again. I verified I got one row in the underlying table. Then the Analyzer did not get errors any longer.
Hello Mark, I think you want to setup Interoperability Production. Where are you located? Are you available for phone call or online meeting?
Mark,
I cloned the csv repository, added an interoperability production with a file service and a process that imports the file using csvgen code. Please take a look at this repo and let me know if you have any comments or questions:
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()
I believe we were working on HealthShare 2017. Not sure why you ask?
I created a new class (User.OperationSQL) which extends Ens.BusinessOperation and uses
{
Parameter ADAPTER = "EnsLib.SQL.OutboundAdapter";
Property Adapter As EnsLib.SQL.OutboundAdapter;
...
Do you see Ens.BusinessOperation and EnsLib.SQL.OutboundAdapter?
Can you create your own class that extends the class you want to update? Which class? What kind of operation you want to do?
Congrats to the winners. Thank you for the Git for IRIS app. I plan to use that
Hello, I have setup IRIS mirror in AWS using Elastic Container Service / Fargate. I did not utilize a load balancer for mirror setup.
I was planning to write an article about this topic in current tech article contest. I will get started on it today.
Craig, our Health Connect production handles supply chain messages for Department of Veterans Affairs. Many of the messages are recordmap files. Messages volume is low. I hope to learn how to architect a solution that is reliable and scalable, just in case traffic increases or I can transfer this experience to the next project.
Not sure why my poll is closed :-(
Hi Muhammad,
You need to have a Message Bank Operation to send messages to the Message Bank and you need a Message Bank Production with a TCP Service to receive the messages.
I have written an article about my experience with Message Bank and I have a GitHub repo with Message Bank code:
IRIS Interoperability Message Bank | InterSystems Developer Community | AWS
Not sure if it could be a simple workaround, but I created a FileControl mechanism where I create my own queue of files for the business service to process. I add files to the queue through an Outbound File Adapter so they can get processed by modified Inbound Adapters
Can you add more memory?
Message bank is a central location for messages and logs from multiple productions. Please see my article here:
IRIS Interoperability Message Bank | InterSystems Developer Community | AWS
Hi Michael,
I implemented Message Bank because I did not want to check multiple instances trying to see what messages were processed in each production. Does that make sense?
Hello,
Started working on Message Bank mirror. Realized there is a MessageBank production running in the namespace with the mirrored database. I probably need to control the AutoStart global to start the production only on the Primary...
git clone a project. many examples in Open Exchange
I encountered another challenge this week. I utilized AWS Elastic Container Service (ECS) to deploy two Fargate tasks running IRIS MessageBank Mirror. The first task started on ip-10-xxx-xxx-146. It used failover1 volume which had previously been used by ip-10-xxx-xxx-168. The second task started on ip-10-xxx-xxx-168. The second task ran on failover2 volume. It started MessageBank production and it became Primary. Mirror Service did not start on the first task. In messages.log I saw:
Mirroring not started, this instance appears to have been copied. See ^MIRROR
I suspect this happened because the randomly assigned IP address for the second task matched the prior IP address of the first task. I opened a support ticket with InterSystems WRC on Tuesday morning and I still wait for their response.
I need to correct my last response. I did receive WRC response on Friday with this:
After discussing this issue with co-workers:
The message is due to the reassignment of the IP address:
Yes – the basically the IP address changing underneath the mirror node “changed it’s identity”. This is expected behavior for mirroring.
Possible to setup virtual IP address/or DNS name for each member then in script assign new IP to the member's DNS name
Also not to use ECS but something long these lines found in this link, look it over and see if it applies:
https://medium.com/galvanize/static-ip-applications-on-aws-ecs-c7d411421d4f
docker exec -it sam_iris_1 bash
root@IRIS:/tmp# cd /usr/irissys/csp/bin/
root@IRIS:/usr/irissys/csp/bin# ls
CSP.ini CSP.log CSPRT.ini CSPa24.so CSPa24Sys.so CSPx.so libz.so temp
root@IRIS:/usr/irissys/csp/bin# ls -lt
total 3244
-rw-rw-r-- 1 www-data www-data 6063 Aug 22 15:56 CSP.log
-rw-rw---- 1 irisuser irisuser 253 Aug 21 23:57 CSPRT.ini
-rw-rw---- 1 irisuser irisuser 606 Jun 26 2020 CSP.ini
-rwxrwxr-x 1 irisowner irisowner 1169384 Jun 26 2020 CSPa24.so
-rwxrwxr-x 1 irisowner irisowner 869720 Jun 26 2020 CSPa24Sys.so
-rwxrwxr-x 1 irisowner irisowner 1135208 Jun 26 2020 CSPx.so
-rwxr-xr-x 1 irisowner irisowner 117168 Jun 26 2020 libz.so
dr-xr-x--- 1 irisuser irisuser 4096 Jun 26 2020 temp
in the durable place I see:
root@IRIS:/dur/iconfig/csp/bin# ls -lt
total 16
-rw-rw-r-- 1 irisuser irisuser 5943 Aug 21 23:57 CSP.log
-rw-rw---- 1 irisuser irisuser 257 Aug 21 23:57 CSPRT.ini
-rw-rw---- 1 irisuser irisuser 745 Aug 21 23:57 CSP.ini
did not work. still get the same error
Add one point I edited CSP.ini file (on another similar project). Cannot remember why I had tried to add
| [SYSTEM] | |
| System_Manager=*.*.*.* |
By default, only clients local to the Web Gateway’s hosting computer are allowed access to the Web Gateway Management pages. The browser through which the management forms are accessed must be running on the same machine as the web server and Web Gateway. For example:
http://localhost:<port_no>/csp/bin/Systems/Module.cxw
You can add additional clients to the list of authorized administrators by adding the client IP addresses to the System_Manager parameter in the SYSTEM section in CSP.ini (in install-dir\CSP\bin). The System_Manager parameter represents a comma- or plus-separated list of clients (by IP address) who may access the Web Gateway Management pages. The directive shown below grants access to three remote clients in addition to the default local access.
[SYSTEM] System_Manager=190.8.7.6, 190.8.7.5, 190.8.7.4
Which version of docker are you using? I had such a problem when I started using docker 1.13 on Red Hat Linux. Things worked for me after I got on Docker 19 or 20
In my experience, this version of docker did not work properly with IRIS. Can you try to get on current Docker version?
It took a while, but I made some progress. I changed my cube name from iris-for-money to iris4money (no dashes) and then the project compiled with the latest community edition image. zpm behaved a little bit better in later image, but I still had to struggle a lot to get FileCopy to work so I had data to import when installing from zpm.
I appreciate the help I got from Dmitry Maslennikov when I called ZPM 911 on Discord channel. He pointed out that FileCopy converted filename from export.csv to export.CSV. Eventually I got my zpm testing to complete without errors after I had changed the filename in my repo to export.CSV. Hopefully I will earn ZPM bonus which I have worked so hard for.