Question Dmitry Maslennikov · Jun 8, 2020 SQL Cached queries Since IRIS 2020.1, changed the way how embedded SQL compiled. Now it compiles upon the first execution of such queries. Is there any way, I could switch that feature back to the previous behavior, or get some more control over it? #Deployment #SQL #System Administration #InterSystems IRIS 0 16 0 717
Question Dmitry Maslennikov · Apr 30, 2020 %JSON.Adaptor for streams Okay, we've got a quite useful way to very easily Import and export our objects as JSON, similar to what we already had before for XML. So, It's a %JSON.Adaptor. But the issue here I faced with, working with Stream properties. I have an example, when I generate an object, with stream binary stream properties. Export and Import the same, but getting the different resulting objects, depends on the original size of streams. #JSON #InterSystems IRIS 0 6 1 1.4K
Question Dmitry Maslennikov · Jan 16, 2020 Custom Login Page for IRIS When I tried to migrate one of ZEN applications to IRIS from 2018.1 I'm faced with the issue with Login Page, in this case used some ZEN page, completely customized. But when a user tries to get access, he gets the error like below. The requested URL /csp/user/User.Login.cls was not found on this server. I tried to test it with a fresh just created login page class Class User.Login Extends %CSP.Page { ClassMethod OnPage() As %Status { &html<<h1>Hello</1>> Quit $$$OK } } Set it to /csp/user application as Login page, and #Access control #CSP #InterSystems IRIS 0 4 1 861
Question Dmitry Maslennikov · Jan 12, 2020 Timeout for $zf In one of the projects, when we have ECP with 10 ECP application servers, from time to time we faced the issue when our journals fail to purge, due to open transactions. While we have about 100-150 GB journal files per day, it quite quickly became a big issue, and with mirroring a very big issue. Mostly we just rebooted our ECP Data server, so it searches rollbacks any transactions, but such process is too long, may steal a few hours. I did not find any way, how to get the list of the open transactions from one place from ECP Data Server. We just migrated our Data server to 2018.1. #Database Transaction Processing #ECP #System Administration #Caché #Ensemble #InterSystems IRIS 3 4 0 901
Question Dmitry Maslennikov · May 6, 2019 Cross Caché/IRIS development Well, we now have two different platforms Caché and IRIS. With so many changes, that it makes so many difficulties to have the same sources for both platforms. I'm not arguing about the reasons for it. Some of the changes are really reasonable.It's good when I can import code from Caché to IRIS and get it worked after all background job was done. In Caché we have %CacheStorage type used for Storages. In IRIS it automatically converts to %Storage.Persistent. So, If I develop on IRIS, I will have incompatible sources for Caché. #Development Environment #ObjectScript #InterSystems IRIS 0 6 0 521
Question Dmitry Maslennikov · Mar 6, 2019 Increment value in property with SQL Let's imagine you have only SQL. You need some table where you should increment value in some property when you update this line. We have the table CREATE TABLE "test" ( "identifier" VARCHAR(200) NOT NULL, "value" INTEGER, PRIMARY KEY ("identifier") ) #SQL #Caché 1 6 0 714
Question Dmitry Maslennikov · Nov 12, 2018 Managing with heavy databases Let's say you have about 100TB of data in multiple CACHE.DAT. The biggest one is about 30TB but mostly more than 1TB. You have limited time for maintenance during a day, and it is only a few hours at night. You have to check Integrity as much often as possible. And of course backup it.How would you do it? #Backup #Databases #System Administration #Caché 0 2 0 446
Question Dmitry Maslennikov · Aug 31, 2018 WebSocket frame size limitation I faced with the issue when WebSocket connection just fails without any errors if I send data with size 384 bytes and more (In binary mode the same). As I know by standard WebSockets frame does not have such limitation. Is there any way how to decrease it? This limitation too small, it is too difficult to fit this size and needs to send data much more often than I expected. Tested with Caché 2016.2, 2017.2 and IRIS 2018.1. #Frontend #SOAP #Caché 1 2 0 757
Question Dmitry Maslennikov · Jul 20, 2018 Docker with overlay support Just got the new beta version of Docker, with depreciation warning of AUFS. It's so bad news when InterSystems does not support used by default storage driver overlay2. Recently I thought to play with Google Kubernetes Engine, and realized that I can't work with InterSystems products there due to incompatibility with Storage Driver. Maybe it's already time to think about support? #Compatibility #Deployment #Docker #Kubernetes #Caché 4 5 0 744
Question Dmitry Maslennikov · Dec 13, 2016 Duplicate tags There are two tags with the same name "Web Services"The same problem for tags: REST Services, Delegated and Monitoring. #DC Feedback 1 2 0 200
Question Dmitry Maslennikov · Dec 1, 2016 Some feedback about latest version of Atelier Thanks a lot, that we finally got the new version of Atelier, where most of the errors were fixed. But I've found some have not fixed yet. set destination = $listget(waypoints,*) set $list(waypoints,*,*)="" In this code, Atelier does know about asterisk as a second argument to $listget function. And in this case, even shows next lines as an error. 1 6 0 591
Question Dmitry Maslennikov · Nov 24, 2016 InterSystems and containers Just curious how many companies use in their work Docker containers, I mean not only with InterSystems products. And if such companies exist, which of them uses docker and doesn't use it for InterSystems products by some reasons. What are the reasons? For companies which already uses InterSystems in containers, how do you use it? Development environment, testing or even in production ? And if you don't use but thought about it, what are the reasons which stop you. As for me, I've been using InterSystems Caché inside a Docker container in some different cases: #Containerization #Continuous Integration #Docker #System Administration #Caché 3 2 0 816
Question Dmitry Maslennikov · Nov 5, 2016 Copy text in editor There are some troubles while I try to copy text in the WYSIWYG editor, some time it does not work, even in source mode. #DC Feedback 1 1 0 250
Question Dmitry Maslennikov · Oct 3, 2016 Date for post published from draft [Fixed] Is it possible to change date for post, when in time when it was published? I've created a draft some days ago, and when I published it today, it shows that post already 3 days old. #DC Feedback 0 1 0 170
Question Dmitry Maslennikov · Sep 17, 2016 Support for Java Hibernate 5 Working on implementation FHIR to my project, I found interesting project HAPI-FHIR, which could help me to quickly launch my FHIR api server with InterSystems Caché as a storage, because this projects uses Hibernate to connect to database, as an example they use DerbyDB. I tried to change settings to use InterSystems Caché, but unfortunately it does not work and throw some errors inside HIbernate. As I found in Caché documentation, I have not some many options, I just have to set Cache dialect, and set database url. #Compatibility #FHIR #Java #Caché 2 13 0 1.7K
Question Dmitry Maslennikov · Sep 9, 2016 FHIR outside of HealthShare Some time ago, I was started to work at a new company even in other country, and more important in a different sphere when I have not been worked before, in HealthCare. It's a very new project even for company. Since I have not experience in HealthCare, I looked at what I can use in my project, and found that I should not reinvent the bicycle, and think about how to store all my data which I need and how to get access to this data. And I can use FHIR, which is looks like everything what I need, what else I need it's just a client. #Ensemble #HealthShare #REST API 1 2 0 430
Question Dmitry Maslennikov · Mar 4, 2016 Contributing to an Atelier As I know Atelier sources already on github, but I think in private repository. May you say when this project will be opened, and how about if I want to contibute to this project? #Development Environment 1 7 0 383
Question Dmitry Maslennikov · Feb 18, 2016 XData MimeType anything other then just xml XData blocks in Caché classes has a MimeType property, and dcoumentation saysMimeType — The MIME type (more formally, the internet media type) of the contents of the XData block. The default is text/xml #Languages #ObjectScript #Caché 4 3 0 454
Question Dmitry Maslennikov · Feb 8, 2016 Atelier and complicated projects Most of projects on Caché, obviously, written not only in Cache ObjectScript, and should contain sources in other languages. Such as js or css for web-projects or any others. And it would be pretty good, if I could see all of files in one project, and possible to edit all of them. How to be in this case ?And I think it is not a good idea, to place all project's sources in one root folder. Our project contains over 3 thousands classes and routines, and it is too difficult to find anything in such folder. Is not a good for it to use Java-way, and place every package in subfolder ? #Development Environment 5 2 0 359