go to post Oliver Wilms · Jun 3, 2020 Good morning Eduard, What are DM or AM instances? Do you know if %Installer can setup ECP connection to a data server and also define a remote database to the same data server in code? By the way, the remote database is a mirror database. Thanks, Oliver
go to post Oliver Wilms · Jun 3, 2020 I like to export my project at certain times and later use winmerge to compare and see what has changed. I think to create a utility to automate the fiddle the xml files to compare like neutralizing creation time and compile time. Maybe remove storage from xml when possibly moving code from iris to cache. I just need to find the correct open to be able to read from the beginning of a file. I get error an end of stream error when I try to read from file.
go to post Oliver Wilms · May 30, 2020 Alex, I loaded the VMX programs in a different namespace. I see the picture when I run mx.xlsb. I read your instructions: After opening first sheet, click button [] ##class(SYS.Stats.Dashboard).Sample() Then press button [design-mode] (top of screen ). I cannot tell what button to press first and the design button is not clickable.
go to post Oliver Wilms · May 28, 2020 So I also tried Activate Wizard. Found it in my HealthShare but not in IRIS CE. Once in Activate Wizard, I do not see Excel.
go to post Oliver Wilms · May 28, 2020 Alex, I installed MX on my personal desktop. I configured one connection to IRIS. I run mx.xlsb. I can click on "my connection" and I see four options. I cannot click Design button. Other buttons can be clicked and then I get errors. I am confused. Thanks, Oliver
go to post Oliver Wilms · May 28, 2020 Robert, I added a DSN for an Excel Workbook ODBC 32-bit was my only option on my laptop. When I go to SQL Gateway Connection, I see other DSN but not my Excel DSN. Maybe I will try %Activate next
go to post Oliver Wilms · May 28, 2020 Alex, I looked at MX. I added one connection in the Configuration. I am not exactly sure what to do with this tool. However it sure looks interesting, I am working on a dashboard page where I want to frequently read the status of monitored components from an Excel spreadsheet. I think I should be able to collect the data from another file format. Thanks
go to post Oliver Wilms · May 28, 2020 Thanks for the suggestion. However I am afraid this is also not an approved tool in my work environment.
go to post Oliver Wilms · May 28, 2020 Thanks for the suggestion. However I am afraid this is also not an approved tool in my work environment.
go to post Oliver Wilms · May 22, 2020 Hello Paul, I like to work on this problem. In preparation, I found a zen page in Samples namespace and added a file upload control. I define a CSP page to go to on submit. How do I attach a file to a CSP page? Then you want to manipulate the file when received by CSP page. Does the user see the attached file on the CSP page? Our team has a CSP page that receives an incoming file and then it is passed along to a business service in HealthConnect production. Where do you want the modified file to go?
go to post Oliver Wilms · May 19, 2020 Only a local database on the current primary failover member can be added to a mirror; it is added on the primary first,then on the backup, and then on any desired async members. All mirrored databases must be journaled.You must add the same set of mirrored databases to both the primary and backup failover members, as well as to any DRasync members.
go to post Oliver Wilms · May 6, 2020 Ken, I copied your Docker command and I observed user IRIS.DAT database file was under durable storage. I believe it is because of "--env ISC_DATA_DIRECTORY=/dur/iconfig". Best regards, Oliver
go to post Oliver Wilms · May 5, 2020 I am learning Iris and Docker in my free account with Amazon Web Services. I started a new EC2 instance and with Docker. I copied your Docker run command. Then I got into Iris Terminal with this command: docker exec -it iris21 iris session IRIS I was in USER namespace and I populated the global: USER>for i=1:1:10 set ^tmp(i)="" I viewed the global in Management Portal: 34.228.219.65:52773/csp/sys/exp/UtilExpGlobalView.csp?$ID2=tmp&$NAMESPACE=USER&$NAMESPACE=USER I halt out of Iris terminal and review storage. I find two IRIS.DAT for %SYS and user. ubuntu@ip-172-31-45-10:/data/dur/iconfig/mgr$ ls -lttotal 194660-rw-rw---- 1 51773 52773 104857600 May 6 02:53 IRIS.WIJ-rw-r----- 1 51773 52773 94371840 May 6 02:50 IRIS.DAT-rw-rw-r-- 1 51773 52773 38723 May 6 02:48 messages.log-rwxrw-r-- 1 52773 52773 66 May 6 02:38 SystemMonitor.logdrwxrwxr-x 3 root 52773 4096 May 6 02:38 userdrwxrwxr-x 3 root 52773 4096 May 6 02:38 irisauditdrwxrwxr-x 2 52773 52773 4096 May 6 02:38 Temp-rw-rw---- 1 51773 52773 219 May 6 02:38 journal.logdrwxrwxr-x 2 51773 52773 4096 May 6 02:38 journaldrwxrwxr-x 3 52773 52773 4096 May 6 02:38 iristempdrwxrwxr-x 3 root 52773 4096 May 6 02:38 irislocaldata-rw-rw---- 1 51773 52773 35 May 6 02:38 iris.lck-rw-rw---- 1 51773 52773 12 May 6 02:38 iris.ids-rw-rw-rw- 1 51773 52773 58 May 6 02:38 startup.last-rw-rw-rw- 1 51773 52773 2 May 6 02:38 iris.shid-rw-rw-r-- 1 51773 52773 5 May 6 02:38 iris.usedrwxrwxr-x 2 root 52773 4096 May 6 02:38 stream-rw-rw---- 1 51773 52773 938 Feb 7 16:00 irisodbc.ini-rwxrwxrwx 1 51773 52773 0 Feb 7 16:00 ilockubuntu@ip-172-31-45-10:/data/dur/iconfig/mgr$ cd userubuntu@ip-172-31-45-10:/data/dur/iconfig/mgr/user$ ls -lttotal 11272-rw-rw---- 1 51773 52773 11534336 May 6 02:50 IRIS.DAT-rw-rw---- 1 51773 52773 35 May 6 02:38 iris.lckdrwxrwxr-x 2 51773 52773 4096 Feb 7 16:01 stream I remove iris21 container from Docker by this command: docker rm --force iris The IRIS.DAT remained in user directory on my EC2 instance. Management Portal would not work at this time. I reboot EC2 instance from AWS console. I login to EC2 using SSH and check IRIS.DAT files are still there. I rerun the Docker run command to run iris21 again. I can return to Management Portal. It remembered the changed password when I log in. I can see the 10 enties in ^tmp global. I believe you need to use port 51773 to connect Studio to Iris running in Docker container.
go to post Oliver Wilms · Apr 29, 2020 Patrick, Thanks for your reply. Can Intersystems get us a list of the standards they presently support for their existing customers (FHIR, HL7v2.3, 2.4 0r 2.5, Edi or X12, etc.)? From this list we can xmap to our requested protocol and determine if any gaps exist for other protocols. Thanks, Oliver and Terry
go to post Oliver Wilms · Apr 17, 2020 Good morning, I encountered this error when I had to save a lot of data. It happened to me, because either the lock table was full (check console log) or I exceeded the lock threshold so a process would try to lock the entire table which failed because there were other processes also inserting data into the same tables. Hope to help. Oliver
go to post Oliver Wilms · Mar 28, 2020 Thanks to all who put on this contest. It motivated me to get my hands on Docker. Unfortunately I chose a bad topic for my application. I have no mail server to send my email. I tried to work with TCP because that is an alternate solution to a problem I am working on at my regular job. With default steps, I have no ports open to work with local tcp connections. I developed unit testing production for my contest application. I got an error in container that I did not get outside. I learned a lot this week while working on this. It is great if someone can work on what they enjoy doing and enjoy their work. That's me, happy!
go to post Oliver Wilms · Mar 27, 2020 I tried this again today and it worked. No more errors. I did not change anything. I observed that the Login gets a response with a server name and today it is different compared to yesterday's server. Maybe the server I got logged in yesterday did not like me.
go to post Oliver Wilms · Mar 26, 2020 I could not send an email from my Iris container. I created a TestProduction for testing my production. I added a lot of debug statements logging what happens in FileMaker into ^TESTdmlss. Try running the FileMailer application (follow instructions in Read me) and review ^TESTdmlss by typing ZW ^TESTdmlss.
