go to post Dmitrii Baranov · Jan 10 I faced similar issues with Postgres linked tables because of different SQL syntax and also poorly implemented translation from IRIS dialect to your linked server dialect. The workaround is to add an instance of EnsLib.SQL.Operation.GenericOperation to your production and to execute SQL queries via ODBC/JDBC bypassing IRIS, something like: Set operation = ##class(EnsLib.SQL.Operation.GenericOperation).%New("NameOfYourProductionComponent") #Dim rs as EnsLib.SQL.GatewayResultSet Set status = operation.Adapter.ExecuteQuery(.rs, "select 1", .args) While (rs.Next()) { ... } Do rs.Close()
go to post Dmitrii Baranov · Dec 30, 2024 I believe Spotify exposes a standard OAuth2 endpoint so you can use built-in IRIS classes to deal with tokens (but to be honest the standard library looks overcomplicated so I personally often use the same approach)
go to post Dmitrii Baranov · Dec 28, 2024 Found the answer. It is simply not allowed: "+ Rule: For collections of type document, message, searchset or collection, all entries must contain resources, and not have request or response elements"
go to post Dmitrii Baranov · Dec 17, 2024 `..FindPoolIndex` doesn't exist, it's pseudocode (by the way, ChatGPT has very little and poor knowledge about IRIS)
go to post Dmitrii Baranov · Dec 17, 2024 No, it is a Postgres linked table, but it is not really important, I just want to parallelize the process
go to post Dmitrii Baranov · Dec 14, 2024 The error has gone after IRIS restart. Another indicator of the problem was that the SQL Gateway connection test was not working
go to post Dmitrii Baranov · Dec 10, 2024 To be honest... no :) Actually I think I badly need a standalone terminal (but Studio is discontinued) or a Python/Java/C#/whatever library which is able to invoke arbitrary commands on a remote server and I'm just wondering if such libraries exist. PS leveraging WebTerminal API looks attractive but it seems to me it doesn't expose Swagger/OpenAPI definitions
go to post Dmitrii Baranov · Dec 1, 2024 That's probably the point. You are right, it is a containerized instance. Thanks again
go to post Dmitrii Baranov · Dec 1, 2024 Great, thanks a lot, it works. The real error messages are "ERROR #6162: Unable to create HTTP Authorization header for NTLM scheme." and "ERROR #6162: Unable to create HTTP Authorization header for Negotiate scheme." for both NTLM and Negotiate schemes respectively. Does it mean that IRIS is unable to deal with these authentication schemes? The documentation says that NTLM is supported.
go to post Dmitrii Baranov · Nov 18, 2024 Hi Timo,and thanks a lot, I've disabled the FastDistinct so now everything works as expected. Your link took me to a page that describes the Group By operator and it happened so this "feature" is documented and that another option is to use the %Exact function, e.g. select distinct %Exact(value) ...
go to post Dmitrii Baranov · Nov 17, 2024 Hi Tani, in most cases the stream contains JSON. The container definition looks like: Class MyRequest Extends (Ens.StreamContainer, %JSON.Adaptor) { } I just want the stream content to be rendered always
go to post Dmitrii Baranov · Nov 2, 2024 I'm sorry for the false alarm. I've increased the FHIR server "Max Search Results" option value so now everything works fine.
go to post Dmitrii Baranov · Oct 21, 2024 The option with $LIST(...) works, thanks again (not so elegant though but OK as a workaround). I'm thinking about registering a feature request.
go to post Dmitrii Baranov · Oct 20, 2024 Thanks Robert, I've read this article, but the syntax isn't entirely clear to me: Select ID,Company from rcc_IC.ItemList Where FOR SOME %ELEMENT(rcc_IC.ItemList.Items) ($list(%Value,3) in ('blue','yellow')) Here the integer is used, but I need to search using a named property
go to post Dmitrii Baranov · Feb 26, 2024 Thanks a lot! In short, I failed. 1. This requires installing pip3 on Unix and you'll need to be su 2. If you want to reference npm libraries, you'll need to be su (although technically it's possible to place JS library/libraries code in the XData section(s)) 3. The most annoying thing is that most JS libraries are asynchronous and that's a dead end
go to post Dmitrii Baranov · Nov 23, 2023 You have to cast your %CharacterStream to a specific implementation, say, to %GlobalCharacterStream. The latter one implements %GlobalStreamAdaptor, which inherits from %AbstractStream and %Stream.Object. Finally, the %Stream.Object class exposes the CopyFrom method which allows you to copy data from your %Stream.GlobalBinary instance (and vice versa)
go to post Dmitrii Baranov · Nov 21, 2023 Thanks, got it. Then perhaps this setting can somehow be changed programmatically, in the installer code?
go to post Dmitrii Baranov · Oct 21, 2023 Thanks a lot Robert. I completely forgot about multiple inheritance 😶
go to post Dmitrii Baranov · Oct 3, 2023 Thanks so much! It was not obvious for me that the DebugMode property value is of type integer (looks like boolean)
go to post Dmitrii Baranov · Sep 25, 2023 Interesting... I'm actively using the Write method, but for emitting console messages using constant strings. Anyway, thanks
