Thanks for the suggestions, so I would need to add this to a copy of EnsLib.HL7.Service.FileService to call as it reads in the message? Or would I call a service then send it another service to parse and remove the misc characters before it starts reading it in as HL7?
I meant how do I inner join across namespaces in SQL? I was trying to write a query or use some of the Cache code above to connect the two together for my boss. Thanks
How do I connect the %SYS to our Production namespace in SQL to tie the date/times to the Class file?
Unfortunately we do not log that Auditing item, as I tried creating a new Operation, but did not see an entry in the Audit log.
Is there anywhere else a Creation Date/Insert date maybe logged for an object?
Is there a way to tell when a Config Item was created within Ens_Config?
Currently there is a select few of us in the group that use Git and Local Repos for VS code, but I want to make this more wide spread for our team as most use the Editors off of the Management Portal to do their coding.
Does anyone have steps they have used in the past to move towards Server Side Source Control from creating the Repos on your Server, getting the IRIS Code into the new Repo you created on your server, and pushing it to github?
It only needs to run if we inserted data into the tables once a week so how would we do that besides EnableConfigItem script? I was looking to trigger the event based on if the service A and process A had been completed.
Within the Business Process B.
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.
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.
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.
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.
I will give that a try also, part of my problem was leaving Data Validation on when I did the import.
Has anyone done this within a Unix environment? Have you used Python to resize the images?
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.
.png)
I have seen this on both... HealthShare Health Connect
IRIS for Windows (x86-64) 2022.1 (Build 209U) Tue May 31 2022 12:16:40 EDT
IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2022.1 (Build 209U) Tue May 31 2022 12:13:24 EDT
using the link from https://pm.community.intersystems.com/packages/zpm/latest/installer
zpm:USER>version
%SYS> zpm 0.5.0
https://pm.community.intersystems.com - 1.0.6
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.
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?
Will there be a recording available of the User Group Session if we can't make the November 3rd session?
Thanks for giving us a way to express ideas and changes that we have pondered for years.
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 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?
Where would I go to make adjustments to the JVM heap? Here are the Advance Memory settings...
.png)
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"
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??
Found that this issue was attributed because I was using sudo to execute the docker/podman compose call.
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.
Remove /v2/ from the end.
I have opened a ticket with WRC to troubleshoot the issue
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?
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