go to post Enrico Parisi · May 16, 2024 I noticed that some of the functions in your system are not IRIS built-in function but, evidently, are custom functions implemented in your system, as documented here. To search and find the class and code that implement this functions you may search classes that extends the Ens.Rule.FunctionSet class using the class reference in your system/server, not in the documentation website.
go to post Enrico Parisi · May 13, 2024 In order to use LOAD DATA you need to check that the Java external language gateway is properly configured and working.
go to post Enrico Parisi · May 11, 2024 I'd implement a custom datatype, something like: Class Community.dt.IntJSON Extends %Integer { Parameter JSONTYPE = "string"; ClassMethod JSONToLogical(%val As %String) As %Integer [ CodeMode = expression, ServerOnly = 1 ] { ..DisplayToLogical(%val) } ClassMethod LogicalToJSON(%val As %Integer) As %String [ CodeMode = expression, ServerOnly = 1 ] { ..LogicalToDisplay(%val) } } Then in your class: Class Community.json.TestDT Extends (%RegisteredObject, %JSON.Adaptor) { Property something As Community.dt.IntJSON(DISPLAYLIST = ",OK,Error,Warning", VALUELIST = ",0,1,2") [ InitialExpression = 0 ]; ClassMethod RunMe() { set obj = ..%New() set obj.something = 2 do obj.%JSONExportToString(.string) write "JSON : " _ string,! write "Content : " _ ..somethingLogicalToDisplay(obj.something),!! set obj2=..%New() do obj2.%JSONImport(string) write "Imported something value: ",obj2.something,! } } Result: EPTEST>d ##class(Community.json.TestDT).RunMe() JSON : {"something":"Warning"} Content : Warning Imported something value: 2
go to post Enrico Parisi · May 8, 2024 I manage systems that use IIS since more than 15 years and never experienced performance issues. For a code that takes 15ms having service/call that takes 40ms total round trip to me is way too much (that's 25ms overhead !!).We have SOAP services that respond in 10ms (local subnet, round trip measured from the caller/client). I don't recall any special configuration in IIS. What's the configuration of the Web/CSP Gateway?
go to post Enrico Parisi · May 7, 2024 @Shane Nowack , in the first table in your post, in the left column/list this two items: SQL Best Practices DocBest Practices for Defining SQL Optimized Tables Through Persistent Classes both link the same documentation page, is this correct or maybe one link is not correct?
go to post Enrico Parisi · May 4, 2024 I think it means that that particular segment has been modified
go to post Enrico Parisi · May 3, 2024 Did you checked this post: Upcoming InterSystems Container Changes
go to post Enrico Parisi · May 3, 2024 In all set actions remove k1 from the Key (last column in the screenshot) and put "" (not empty) instead (that's the default when you insert a set action). Then try again.
go to post Enrico Parisi · May 2, 2024 What's the version of the "source" system? Try using the button "Import Legacy" instead of "Import".
go to post Enrico Parisi · May 2, 2024 Compact & Truncate are there EXACTLY to perform what you want/need, no other option. If want to speed it up, start compacting with "little" space tio free up at the end, then truncate to free disk space and gain some time, then repeat...etc.
go to post Enrico Parisi · Apr 29, 2024 Just guessing, please check this documentation: About Creating a Custom CSP Login Page And in particular the first step: Ensure that the Web Gateway user (CSPSystem) has permissions to read the database for where the custom login page is located. Assign the desired database resource to an appropriate role, and then assign that role to the CSPSystem user.
go to post Enrico Parisi · Apr 29, 2024 I suspect that's too small, but there are MANY missing details to consider and I might be wrong. gmheap documentation is here. Note that for new installation the value is 0 (zero), in that case: the system will configure the size of gmheap to be 3% of the total memory configured for global buffers. The minimum gmheap will be configured to is 307,200 KB (300 MB) and the maximum is 2,097,000 KB (2 GB) So, your gmheap is about 1/3 of current default.
go to post Enrico Parisi · Apr 29, 2024 Beware that $System.SQL.Schema.SetDefault() sets the default schema (optionally) for a namespace systemwide, that is, for all processes, not only current process.
go to post Enrico Parisi · Apr 28, 2024 It seems that in your system the routine ST.int is missing, can you check if it's in the %SYS namespace? ST.int is part of Ensemble, it should be there but apparently is not (has been deleted?).
go to post Enrico Parisi · Apr 27, 2024 Just curious, what's the value of gmheap?You can find it in iris.cpf or in Management Portal, System Administration > Configuration > Additional Settings > Advanced Memory
go to post Enrico Parisi · Apr 27, 2024 If you select the option you have highlighted, then CSP Gateway will not be installed, if you don't change it, then it will be installed.What option do you use when you install? (first dialog) However, is this a new fresh install or an upgrade of an existing Ensemble instance?
go to post Enrico Parisi · Apr 26, 2024 It's long time I don't install Ensemble 2018, why are you still using Ensemble and not IRIS? I just tested installing Ensemble 2018 and CSP Gateway is properly installed and configured. When the setup kit is run the first dialog is: Do you get the same dialog? What option you choose?As you can see it is also possible to install only the CSP Gateway component. If you choose Custom then this dialog is displayed: As you can see the option to install CSP Gateway for IIS is there. If I proceed to the install, at the end I have the CSP Gateway properly configured in C:\inetpub\CSPGateway In order to help you, apart from saying that is not being installed, can you provide some information on what you are actually doing and what do you actually see/get during install?