All
Accepted answers
Scott Roth · Dec 22, 2022 go to post

Some of our Objects are run as jobs to insert/update, or process data in an external database. Since MS SQL Integration Server (ssis) is limited in logging and notifications, I thought it was best to move it over to IRIS/Ensemble so the rest of my team could Support. 

Scott Roth · Dec 22, 2022 go to post

You could route it within the Business Rule to only send at certain times of the day but then you would need a custom business file operation for the second piece you are looking for. 

Scott Roth · Dec 22, 2022 go to post

Using Ens.Director EnableConfig Item someone in our team wrote a shell script that runs on cron to start and stop objects. Or run it off the scheduler or task schedule. 

Scott Roth · Dec 16, 2022 go to post

How do I get OnResponse() to take the response of Process B? I tried specifying a value for the response but I am seeing a NULL sent back to Service B.

Scott Roth · Dec 16, 2022 go to post

I will give that a try also, part of my problem was leaving Data Validation on when I did the import.

Scott Roth · Nov 3, 2022 go to post

Has anyone done this within a Unix environment? Have you used Python to resize the images? 

Scott Roth · Oct 27, 2022 go to post

Here is a diagram that I put together of our process. But I have code to use Data Lookup tables to pull the information needed to format the emails to send out.

Scott Roth · Oct 27, 2022 go to post

When I try to install webterminal, I am getting the following...

IRIS for Windows (x86-64) 2022.1 (Build 209U) Tue May 31 2022 12:16:40 EDT

zpm:USER>install webterminal
 
[USER|webterminal]      Reload START (C:\InterSystems\HealthConnect_2022_1\mgr\.modules\USER\webterminal\4.9.2\)
[USER|webterminal]      Reload SUCCESS
[webterminal]   Module object refreshed.
[USER|webterminal]      Validate START
[USER|webterminal]      Validate SUCCESS
[USER|webterminal]      Compile START
Installing WebTerminal application to USER
Creating WEB application "/terminal"...
WEB application "/terminal" is created.
Assigning role %DB_CACHESYS to a web application; resulting roles: :%DB_CACHESYS:%DB_USER
Creating WEB application "/terminalsocket"...
WEB application "/terminalsocket" is created.
ERROR #879: Target role %DB_CACHESYS does not exist.
[webterminal]   Compile FAILURE
ERROR! Target role %DB_CACHESYS does not exist.
  > ERROR #5090: An error has occurred while creating projection WebTerminal.Installer:Reference.

Scott Roth · Oct 21, 2022 go to post

Since I increased the Heap size it appears that another problem has shown up that I didn't realize we had. The JVM is spawning multiple instances but never closing them out. Is there a way to force close the number of java sessions open? I thought if we used JDBC the connections would be closed instead of spawning additional sessions. Does anyone have a JVM (JDBC Gateway) guide to the settings that should be set?

Scott Roth · Oct 20, 2022 go to post

Will there be a recording available of the User Group Session if we can't make the November 3rd session?

Scott Roth · Oct 19, 2022 go to post

Thanks for giving us a way to express ideas and changes that we have pondered for years. 

Scott Roth · Oct 19, 2022 go to post

We have put our upgrade on pause right now due to constraints, but will be starting it back up and hopefully upgrading by March.

What InterSystems products + versions are you running? ($zv is ideal.) We are currently running HealthShare Health Connect 2018.1.3

Cache for UNIX (IBM AIX for System Power System-64) 2018.1.3 (Build 414U) Mon Oct 28 2019 11:24:02 EDT
What makes you decide to upgrade? Push to move away from AIX and more towards Red Hat for costs, support, additional enhancements and options available to us in IRIS vs 2018.1.3

What are your blockers to upgrading? New network/security policies, new hardware, new OS

What is your process for evaluating and planning a possible upgrade? 

  • What is the benefit to upgrade
  • What does the new version offer and benefits to the Medical Center
  • Where is the Medical Center going
  • What new requirements/policies do we need to address
  • What is the EOL/EOS for the version we are on

What documentation resources do you use? Release notes, installation requirements and guide

What gaps/issues do you see in our existing documentation around upgrades? While the release notes is nice, but more explanation of what is changing, screen shots, etc...

What would make your InterSystems software upgrade process better?

  • Lessons Learned Guide to Upgrades
  • What we should be on the lookout for
  • Notes on the individual changes to be worked
  • Dedicated InterSystems contact that could help with any questions or guide us on the upgrade.
Scott Roth · Oct 13, 2022 go to post

Where would I go to make adjustments to the JVM heap? Here are the Advance Memory settings...

 

Scott Roth · Oct 11, 2022 go to post

I have modified docker-compose.yml to include command: --check-caps false without any luck

[root@int-lxiris-vd02 docker-webgateway-sample]# more docker-compose.yml
version: '3.6'
services:

  webgateway:
    image: tls-ssl-webgateway
    command: --check-caps false
    container_name: tls-ssl-webgateway
    build:
      context: .
      dockerfile: Dockerfile
    networks:
      app_net:
        ipv4_address: 172.16.238.50
    ports:
      # change the local port already used on your system.
      - "80:80"
      - "443:443"
    environment:
      - IRIS_HOST=172.16.238.20
      - IRIS_PORT=1972
      # Replace by the list of ip address allowed to open the CSP system manager
      # https://localhost/csp/bin/Systems/Module.cxw
      - "SYSTEM_MANAGER=${LOCAL_IP}"
      # the list of web apps
      # /csp allow to the webgateway to redirect all request starting by /csp to the iris instance
      # You can specify a list separate by a space : "IRIS_WEBAPPS=/csp/sys /api /isc /swagger-ui"
      - "IRIS_WEBAPPS=/csp/sys"
    volumes:
      # Mount certificates files.
      - ./certificates/webgateway_client.cer:/opt/webgateway/bin/webgateway_client.cer
      - ./certificates/webgateway_client.key:/opt/webgateway/bin/webgateway_client.key
      - ./certificates/CA_Server.cer:/opt/webgateway/bin/CA_Server.cer
      - ~/webgateway-apache-certificates/apache_webgateway.cer:/etc/apache2/certificate/apache_webgateway.cer
      - ~/webgateway-apache-certificates/apache_webgateway.key:/etc/apache2/certificate/apache_webgateway.key
    hostname: webgateway
    command: ["--ssl"]

  iris:
    image: intersystemsdc/iris-community:latest
    command: --check-caps false
    container_name: tls-ssl-iris
    networks:
      app_net:
        ipv4_address: 172.16.238.20
    volumes:
      - ./iris-config-files:/opt/config-files
      # Mount certificates files.
      - ./certificates/CA_Server.cer:/usr/irissys/mgr/CA_Server.cer
      - ./certificates/iris_server.cer:/usr/irissys/mgr/iris_server.cer
      - ./certificates/iris_server.key:/usr/irissys/mgr/iris_server.key
    hostname: iris
    # Load the IRIS configuration file ./iris-config-files/iris-config.json
    command: ["-a","sh /opt/config-files/configureIris.sh"]

networks:
  app_net:
    ipam:
      driver: default
      config:
        - subnet: "172.16.238.0/24"

Scott Roth · Oct 11, 2022 go to post

When IRIS goes to start as part of the script I am seeing the following errors... 

[iris]       | [ERROR] Required Linux capability cap_setuid is missing.
[iris]       | [ERROR] Required Linux capability cap_dac_override is missing.
[iris]       | [ERROR] Required Linux capability cap_fowner is missing.
[iris]       | [ERROR] Required Linux capability cap_setgid is missing.
[iris]       | [ERROR] Required Linux capability cap_kill is missing.
[iris]       | [FATAL] Your IRIS container is missing one or more required Linux capabilities.

I didn't have this issue with the SAM docker file, what could be missing??
 

Scott Roth · Oct 11, 2022 go to post

Found that this issue was attributed because I was using sudo to execute the docker/podman compose call.

Scott Roth · Oct 10, 2022 go to post

What are the network sections within the docker-compose.yml used for? Do we have to change the ipv4_address for our needs? What should the ipv4_adress be set to? Should it be the local address of the server we are running it on? I keep running into issues when I attempt to run it and receive "RuntimeError: missing networks: app_net". I have been struggling with this for weeks now, and would like some insight on getting this to work as it is preconfigured instead of having to install and setup the webgateway on my own.

Scott Roth · Oct 4, 2022 go to post

Linked Tables, Views, and Stored Procedures all use the JDBC Gateway (JDBC_Default) at the server level. While this article is nice to explain how to setup individual connections, how do you troubleshoot the Default connection at the server level to ensure your Linked Tables, Views, and Stored Procedures stay connected. I have opened a WRC ticket because I am finding the Management Portal -> JDBC Gateway page unresponsive to get into, update, or restart the service. Do you have any helpful hints?

Scott Roth · Sep 30, 2022 go to post

I was unable to get the container/image to run with podman compose as I was getting OCI Image Format warnings. So while investigating I saw a suggestion to use buildah to first build and format the image to use with podman. However I keep running into issues still with "SHELL is not supported for OCI image format, [/bin/bash -c] will be ignored. Must use 'docker' format. HEALTHCHECK is not supported for OCI image format..."

Has anyone gotten this to work using podman or buildah instead of docker? I don't have docker available to my RHEL8 environment.

Thanks

Scott

Scott Roth · Sep 21, 2022 go to post

Can someone help me out with the gen-certificates.sh? I have the CA_server.cer from our CA, and I need to just generate the key and csr files so I can submit them to get the cer signed by CA. I tried removing some of the script, but could someone help me change the gen-certificates.sh so this can be done?

Scott Roth · Sep 21, 2022 go to post

What if we just want to run this daily? Should we just specify Start Time of 00:00 and End Time of 23:59? Would the class file run for the entire day then?

Scott Roth · Sep 16, 2022 go to post

In "ExecuteCode" do you have to specify the "do ##class....." or can you just enter "##class...."

Scott Roth · Aug 29, 2022 go to post

I had originally tried to setup a web server outside of docker, but forgot to write down my steps. Instead of building a stand alone web server, I figured this might be a better option. Can someone help me understand the process if I don't want to use a self signed CA certificate? I have downloaded the organization CA certificate but I can't remember what I need to do next to generate and register the key with the organization so I can implement it on our docker session for the web server.

Please and thanks.

Scott Roth · Aug 29, 2022 go to post

Yeah I figured that out. I am just not sure how to incorporate the data just yet.

Scott Roth · Aug 25, 2022 go to post

Can you explain "Keep in mind that if there are self-signed certificates, web browsers will show security alerts. Obviously, if you have a certificate delivered by a certified authority, you can use it instead of a self-signed one (especially for the Apache server certificate)." a little bit further? Would I send the .key to my organization to get a CA signed cer file back? Which file should I replace once I receive my CA signed certificate from my organization?