go to post Robert Cemper · Apr 18, 2021 Dear @Dmitry Maslennikov !Thanks for the compliment "bad idea" !All my life was driven by cross thinking, away from old tracks, doing the undoable, unchain my mind.And it was 99% success. My ISC colleagues in and outside US can confirm this.@Evgeny Shvarov knows much more details about me that would break the frame here. BUT I'm a little bit disappointed. You didn't read the disclaiming note on top:It is for developers, supporters, system managers. And in addition my examples are never meant for production use,but for training and learning. I don't make money with my software.Just 1 minor detail:Though multiple requests I never got a root password for any IRIS container.You might have access to this information as you have also access to other no-public info.So I had to set one for myself. x-thinking!All about the reasoning and other details are in my reply to @Evgeny ShvarovSince he placed the more important question: WHY?
go to post Robert Cemper · Apr 16, 2021 OK. that means to me:- bring your own iris.cpf (and your own license )as I have done already in past in several cases.And it means to have one repository for demo and another for distribution.
go to post Robert Cemper · Apr 16, 2021 That's fine in principle.But how does this work with the demo server? Which triggered the idea.https://MyProject.contest.community.intersystems.com/......
go to post Robert Cemper · Apr 15, 2021 Hi @Chip Gore !extrapolating Vic's very valid comment:- if you have to take the sour apple of migration, let it be the last time.- why not install WSL2 and migrate into a Linux environment. Or even into a docker scenario
go to post Robert Cemper · Apr 15, 2021 a few comments.A mirrored DB get's an embedded timestamp that links it with its master.the timestamp indicates when de-journaling must start.there is a quite detailed description of how to add a Db to a MIRROR If HSSYS is a SYSdb: it can't be mirrored
go to post Robert Cemper · Apr 14, 2021 in DockerFile USER root## add gitRUN apt update && apt-get -y install git
go to post Robert Cemper · Apr 14, 2021 A little bit of cosmetics in your printf could make it JSON formatted. print(f'{{"subscript":{subscript},"value":"{value}"}}') which should result in a nice conveniant JSON object { "subscript":1, "value":"2.16.840.1.113883.3.86ISCInterSystems Corporation" }
go to post Robert Cemper · Apr 14, 2021 try: Property alternateId As %String(%JSONNULL = 1); { "alternateId": null , "benefitPlanId": "FLSN4444",
go to post Robert Cemper · Apr 14, 2021 If you get back large results sets that you use for further processing PyODBC will be better suited.But for a small number of values, the overhead at both ends to service ODBC structures may not pay offsince both ends have to get their internal structure in to ODBC and out of it.I don't have measured the difference so this is just a guess:- for the typical embedded SQL returning < 1..10 rows a MethodCall might be more efficient.This doesn't prevent you from using and tuning an SQL SELECT isolated in IRIS environment. In any case, the transfer between PY and IRIS is the slowest piece.The less data you transport the faster the action is completed.And transport in blocks wins over isolated pieces in loops.
go to post Robert Cemper · Apr 14, 2021 there is Native API for Python - InterSystems IRIS Data Platform 2020.3 and embedded Python is available for testing but not released officiallyhttps://openexchange.intersystems.com/package/Trying-Embedded-Pythonhttps://openexchange.intersystems.com/package/Wsock-Embedded-Py
go to post Robert Cemper · Apr 13, 2021 There is InterSystems IRIS Adoption Guide available from WRC.It states: You should check with WRC which kit to use. But I'd personally suggest to move to IRIS NativeAPI for .NETsee also Using the Native API for .NET
go to post Robert Cemper · Apr 13, 2021 try to use a username with privileged %ALL in Health Share to distinguish between network problems and access right problems
go to post Robert Cemper · Apr 13, 2021 That's happening due to problems in the network or system stop/restart.normally it recovers without manual interventions and without data loss.levels 0 and 1 signal it's an info / warning.
go to post Robert Cemper · Apr 12, 2021 Hi, @Timothy Leavitt .# What's about a prodlog ? "JSONid public" would be nice pairing with "rowid privat" ?
go to post Robert Cemper · Apr 12, 2021 create a calculated property and it looks like any other one Property MyId As %Integer [ Calculated, SqlComputeCode = { set {*}={%%ID}}, SqlComputed ];
go to post Robert Cemper · Apr 12, 2021 this looks strange to me LITERAL ('PERSON') expected, IDENTIFIER (Person) found with not much hope:does CAST(TableA.ID AS INTEGER) instead of TableA.ID make a difference?
