go to post Enrico Parisi · Dec 21 Have you tried using the proper, official, documented and supported way to do that using Foreign Tables? Does the memory leak happen using Foreign Tables ?Maybe the way you are using the "FOR INTERNAL USE" classes is not proper/correct. Why using something you are not supposed to use when there is a proper/supported way to do this?
go to post Enrico Parisi · Dec 21 I'm afraid I don't have an answer, I use JDBC regularly (admittedly , not Postgres and NOT using %XDBC classes) and I've never seen this behavior.If anyone wants to dive deeper in this issue, more information are required to analyze and maybe try to reproduce it, like: "....rapid increase in memory consumption by the IRIS server" What process is consuming memory? What OS, Windows or Linux? If Linux, what flavor?What Java version are you using?What version of Postgres JDBC driver are you using?Last but to least, note that class %XDBC.Gateway says:"FOR INTERNAL USE - do not invoke directly"
go to post Enrico Parisi · Dec 19 LoadPageDir() compiles the subdirectories as well if/when in the Web Application definition the setting "Web Settings: Recurse" is flagged (enabled). (It's flagged/enabled by default when creating a Web App) How is Recurse setting set in your "/CSP/ourapp/" Web Application definition/configuration? Note that the directory you pass to LoadPageDir is in fact the path of a Web Application, not the physical path on disk.
go to post Enrico Parisi · Dec 15 To reconcile which user/process are associated with the license counts you can use the UserList Query in %SYSTEM.License (aka $system.License) class. Quick test: Set rs=$system.License.UserListFunc() Do rs.%Display()
go to post Enrico Parisi · Dec 11 select * from INFORMATION_SCHEMA.SCHEMATA; There are many tables in INFORMATION_SCHEMA schema you can query to get info, check: select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA ='INFORMATION_SCHEMA';
go to post Enrico Parisi · Dec 10 Have you tried explicitly adding to the production a BP using Ens.ScheduleHandler class?
go to post Enrico Parisi · Dec 4 Make sure the CSPSystem user has read access to the database where your custom login page is located. https://docs.intersystems.com/iris20253/csp/docbook/DocBook.UI.Page.cls?...
go to post Enrico Parisi · Dec 4 Are you using the IRIS login page or a custom login page defined in the Web Application?
go to post Enrico Parisi · Nov 26 The AI BOT answers are moderated, that means that must be approved by a moderator before being published. I do not understand "That is troublesome, particularly if Vitaliy is a Global Masters user.", can you please elaborate your concern?
go to post Enrico Parisi · Nov 21 OK, thank you, now that you edited adding the link it makes more sense.
go to post Enrico Parisi · Nov 21 I'm afraid it's not correct, for example the first item: For ResearcherId the parretn 1N means "One Number", EXACTLY one number I think the correct pattern should be .N, this means any number of Number (digits). Supposing ResearcherId is mandatory and my contains only numbers (at least one), the the pattern would be 1.N Last name would be 1.A, that is at least one low/upper case character
go to post Enrico Parisi · Nov 21 Hi @Fan Ji, is the item "The complete FHIR SQL Builder configuration" missing a screenshot?
go to post Enrico Parisi · Nov 14 Is the message queued in Ens.Alert? What kind of host and class in used by Ens.Alert?
go to post Enrico Parisi · Nov 14 I don't think there is a limit on the number of Business Services a production may contain, 30 is definitely not a big number of BS, I've seen production with more than 100 BS and it works just fine. Concerning the conversion of system Tasks into (scheduled, I guess) BS, well, it depends 😊 Depending on your use case there can be advantages or disadvantages, the main differences that come to my mind are: Scheduled BS starts only if/when a production is started When using mirror, scheduled BS runs only in Primary member Scheduled BS run (start) only in the production namespace
go to post Enrico Parisi · Nov 12 I would just decode the B64 then if it catch any error or returns nothing ("") is not valid.
go to post Enrico Parisi · Nov 12 Hi @Ariel Glikman, my bad, in the latest 2024-2025 "Healthcare Mirroring" documentation page I didn't see this: To automatically configure and schedule this task, as well as mirror the HSSYS database, use the HSSYS Mirroring Utility. Alternatively, manually schedule the task on each mirror member: In fact until 2023.1 the (just released?! 😉) HSSYS Mirroring Utility was only mentioned in the Upgrade documentation.
go to post Enrico Parisi · Nov 12 Are you sure that the tool (browser? does not look like Postman) you use in the first picture is using a POST andf not a GET method? The "405 Method Not Allowed" error means that POST (as used in your code) is not allowed.
