go to post Dmitry Maslennikov · Mar 20, 2023 You may slow a bit your process, to leave some process time to other processes. to do so, you would need to use hang command, somewhere in the loop, with some small value such as 0.1 seconds, and depends how fast is your process may do it once per 100 iterations or more
go to post Dmitry Maslennikov · Mar 17, 2023 I’m not a fun of using LOAD DATA, it’s not complete, there are some things required to be kept in mind. now I would recommend to look at dbt tool, which has support for IRIS, and may probably support older versions too, and it works with CSV quite easy, and can create table for you as well. Have a look, and let me know if you have any issues with it. I can fix bugs in IRIS support, if you find any. For IRIS you would need use dbt-iris package
go to post Dmitry Maslennikov · Mar 17, 2023 It’s actually in process now, to be implemented, should be available soon
go to post Dmitry Maslennikov · Mar 17, 2023 I have tool for it, but it requires full authorization https://github.com/caretdev/iscctl
go to post Dmitry Maslennikov · Mar 16, 2023 Not sure why you think, that the IP is wrong. And probably it's the Windows thing and WSL But, I use this way a lot of time, when I need to access from some docker container, some another service running locally, or another docker container not connected to the same network, and it works fine. This address is supposed to be used only from the container, it should not show the real IP address of the host. If you wish to show some URL, which will be available outside of the container, obviously it will not help.
go to post Dmitry Maslennikov · Mar 16, 2023 Great, thanks for the post. I still did not manage to do it by myself.
go to post Dmitry Maslennikov · Mar 15, 2023 Your issue with screen formatting is very interesting, it deserves a separate topic. I have not seen any issues yet with it. While I’d like to find a way to improve a standard IRIS terminal, like irissqlcli, I’d like to see the most challenging parts like this. webTerminal obviously not a right tool for it. As a replacement for it, you can try to use ttyd, I use it for irissqlcli-web
go to post Dmitry Maslennikov · Mar 14, 2023 It may happen when upgrade from quite old version of zpm. Could you confirm that, if you have old version already installed. In that case, try to manually delete %ZPM package and install again
go to post Dmitry Maslennikov · Mar 1, 2023 well, then I would check the %session.SessionId, is it the same or not? I did not work much with sessions last time. And most of my experience with using %session.Data was in a project where we used %session.Preserve=1. But I can't recommend using this way, it may cause many other issues from my experience.
go to post Dmitry Maslennikov · Mar 1, 2023 First of all you have to check if it's a different Web Applications, then the Cookie path has to be the same for both. If not, it will mean two separate applications with a separate session.
go to post Dmitry Maslennikov · Feb 27, 2023 I wanted to add this ability to irissqlcli, I think it will be useful there.
go to post Dmitry Maslennikov · Feb 26, 2023 At least you can use VSCode for this task, routines and classes and even some other types
go to post Dmitry Maslennikov · Feb 23, 2023 Go to Security, Web Applications, select /csp/user, which is default app for the USER namespace, or if you need it for another namespace, find default web application for that namespace. And check Analytics there, and save
go to post Dmitry Maslennikov · Feb 22, 2023 You can use whatever you want, just remember about some caveats, like issue with bitslice/bitmap indexes, which requires numerical ID I would recommend using just a Unique Index for the UUID field and use it, it should cover most of the needs.
go to post Dmitry Maslennikov · Feb 22, 2023 Interesting, I'm sure, that tried it, and it did not work. But working now
go to post Dmitry Maslennikov · Feb 21, 2023 To do it, remember to backup the data before the process. Be careful, you can harm your data this way. Documentation about it. One of the ways, at least. Depends on what you really want to achieve. Before, I would recommend learning more about journals, how the data is actually stored, and how the restore works.
go to post Dmitry Maslennikov · Feb 19, 2023 InterSystems does not want support for environment variables for password, as it’s expected by the world, and everyone doing it as a side effect, there is no way to use services feature in GitHub actions, and I suppose such things may exist in other CI’s. But I found that it could be very useful, and at the moment I have to start IRIS in docker manually and reset password
