go to post Robert Cemper · Mar 6, 2023 $system.Util.InstallDirectory()classmethod InstallDirectory() as %String Returns the location of the installation directory, i.e. that which is displayed by ccontrol on Unix and VMS, where the .cpf configuration file is kept.
go to post Robert Cemper · Mar 3, 2023 If you are not afraid of using basic COS functionality:your reload method raises a LOCK ^myRELOAD and drops it with completion LOCK -^myRELOAD Your check utility does the same but with a timeout LOCK ^myRELOAD:0if it fails - signaled by $TEST=0 you loop and hang around and retryfor success $TEST=1 you go on but release your successful LOCK immediatelynot to block anyone else.
go to post Robert Cemper · Feb 20, 2023 if you have access to the CSP or ZEN page you may just check the user name in method OnPreHTTP or similar, and redirect him to the moon. if can't touch the page then rename it and create a filter page that does a server-side redirect for everyone except the banned user. .
go to post Robert Cemper · Feb 19, 2023 in iris.script for NSP %SYS add set par("AutheEnabled")=64 set tSC=##class(Security.Applications).Modify("/csp/sys",.par) the disadvantage:You are UnknowUser and might need to add the required Roles as well. set role="%All" set tSC=##class(Security.Users).AddRoles("UnknownUser",.role,1) ----------------------my personal approach is to have a fixed port for SMPand save my _SYSTEM / SYS in browser with autofill.
go to post Robert Cemper · Jan 23, 2023 In IRIS you have in SMP the option to run your Query in background and bypass the timeout.
go to post Robert Cemper · Jan 22, 2023 FOUND SOMETHING ! in SMP IRIS you see this header as in Caché / Ensemble but click to more has a surprise in IRIS Select foreground and you get all %session, .... that you look for.Recorded with SPOOL , device 2 %CSPsc=1%ROWCOUNT=0%ROWID=""%SNGetQueryStats=1%SYSLOG=1%application=<OBJECT REFERENCE>[356@%CSP.UI.Portal.Application]%caller=""%class="%CSP.UI.Portal.SQL.Home"%method="InvokeInstanceMethod"%msg=""%obj=<OBJECT REFERENCE>[362@%ZEN.Component.html]%objlasterror=""%page=<OBJECT REFERENCE>[20@%CSP.UI.Portal.SQL.Home]%request=<OBJECT REFERENCE>[1@%CSP.Request]%response=<OBJECT REFERENCE>[2@%CSP.Response]%sc=1%session=<OBJECT REFERENCE>[3@%CSP.Session]%sqlcontext=<OBJECT REFERENCE>[433@%Library.ProcedureContext]%tStatement=<OBJECT REFERENCE>[369@%SQL.Statement]%zenContext="method"%zenThreadId=39SQLCODE=0rs=""<Private variables>$zp=14828$io="|TCP|58771"Reverse engineering of the SMP page uncovered this new checkbox to me.Could be it is documented somewhereHTH
go to post Robert Cemper · Jan 22, 2023 You are CORRECT , In Caché/Ensemble SMP uses straightforward CSP and you have %session object and %request ...I verified IRIS 2022.2 and 2022.3:- SMP runs Queries differently and neither %session nor %request is visibleby variable » %inBackground = 1 it indicates working in backgroundand once completed the Job is gone, but SMP is still around
go to post Robert Cemper · Jan 21, 2023 MS Acess typically uses ODBC data sources.By default, the ODBC35 driver for Cache/IRIS is installed at Cache/IRIS installation time.You have to configure it (directly or from MS Access) with Namespace + SuperServer PortTake care not to mix 32bit mode with 64bit mode depending on your Cache installation
go to post Robert Cemper · Jan 19, 2023 You are on the right path, I use deuw and see some differences grown by history sort ÄÖÜ + ß (sharp S) after Z as by ASCII sort Ä after A, Ö after O, Ü after U but before Z ignore trema. sort Ä=A, Ö=O, Ü=U no idea about ß 4 and 5 may contribute to the lastest nonsense of German Language Authorotiesthat introduced sharp_S also in uppercase.<we lived since ever without it and didn't miss anything> Your case:You can't change the collation of an existing GlobalBut you can apply a different collation before first use in SMPto overwrite default collation of the DBSystem > Configuration > Local Databases > Globals > New Global So you set up a global ^TEMP3 with collation German3and run MERGE ^TEMP3=^TEMP and have a new collation.Some time back I set that to have different index collations forGerman, Hungarian, Italian, French, Slovenian, ...see my post Multi Language Sort
go to post Robert Cemper · Jan 18, 2023 expression into :var stores the content of the expression into a local host variable var in your case you seem to get from STRING(...) 2 expression stored in to variables CODE and VALUEthis construct is typical for embedded SQL
go to post Robert Cemper · Jan 2, 2023 Looks like an encoding issue.Encoding in Studio is most likely different from your terminal settings.And phyton has no idea about your surface settings.Run this line in Studio and in Terminal and you see what's happening.Matching ends after the end of 7bit ASCII encoding. f j=0:1:64 w ! f i=0:1:63 w $c(j*64+i)
go to post Robert Cemper · Dec 26, 2022 The content of Column COMMENT is expected to be $LB() format.The most likely reason is : this property contains some ages-old junk This works: SELECT ID, CPFName, %INTERNAL(Comments), Name, Product, SectionHeader, Version FROM Config.ConfigFile Cache for Windows (x86-64) 2018.1.7 (Build 721U)
go to post Robert Cemper · Dec 5, 2022 It is less effort to install swager-ui manually from the repo than a backport of ZPM
go to post Robert Cemper · Dec 5, 2022 There is NO official support for ZPM on Caché(too fast typing)
go to post Robert Cemper · Nov 9, 2022 To achieve the expected result of individual storage you may take this approach: Class Test.NewClass Extends %Persistent [ NoExtent ] { Property Name As %String [ Required ]; Index NameIndex On Name [ Unique ]; } and Class Test.NewClass1 Extends Test.NewClass { Storage Default { <Data name="NewClass1DefaultData"> <Value name="1"> <Value>%%CLASSNAME</Value> </Value> <Value name="2"> <Value>Name</Value> </Value> </Data> <DataLocation>^Test.NewClass1D</DataLocation> <DefaultData>NewClass1DefaultData</DefaultData> <IdLocation>^Test.NewClass1D</IdLocation> <IndexLocation>^Test.NewClass1I</IndexLocation> <StreamLocation>^Test.NewClass1S</StreamLocation> <Type>%Library.CacheStorage</Type> } } and you see:ERROR #5808: Key not unique: Test.NewClass1:NameIndex:^Test.NewClass1I("NameIndex"," A1")
go to post Robert Cemper · Nov 7, 2022 if you know the process id then $SYSTEM.Process.Terminate( . . .) should terminate it
go to post Robert Cemper · Nov 7, 2022 there is a quite wide selection of licenses.the best for details is to contact your local sales rep from InterSystems to find your optimal solution
go to post Robert Cemper · Nov 6, 2022 All said: the processor has too many cores which is not allowed by Community edition license So get an official distribution and an official/evaluation license: https://wrc.intersystems.com/wrc/coDistEvaluation.csp