Question David Hockenbroch · Jan 8 Can't edit %Net.SMTP despite having %DB_IRISSYS and database mounted as RW? I need to see the full SMTP trace when a %Net.SMTP attempts to send an email to troubleshoot an issue. As far as I know, the only way to get that is to uncomment line 192 in the %Net.SMTP class. //:#define SMTPTRACE I've done this in the past by giving myself the %DB_IRISSYS role, so I tried that. That database is also not mounted as read-only. #Databases #Debugging #InterSystems IRIS 0 7 0 89
Question David Hockenbroch · Nov 8, 2024 Debugging %Net.SMTP Requests I'm having an issue with sending SMTP requests from a specific Microsoft 365 account to Gmail accounts. We can use other Microsoft 365 accounts, but something about this one specific account sending to Gmail fails. The error we get is just telling us that sending to the user xxxxx@gmail.com failed. In order to troubleshoot that, I'm looking for more detail than that. #InterSystems IRIS 1 4 0 112
Question David Hockenbroch · Oct 12, 2024 Embedded Python - Errors with Numpy When I install the numpy package on Python on my PC using: pip install numpy I can use it in python on my machine. If I do: pip install --target C:\InterSystems\IRIS\mgr\python numpy I get errors any time I try to import it in embedded python. #Embedded Python #InterSystems IRIS 0 3 0 308
Question David Hockenbroch · Aug 20, 2024 Override a Method in VS Code? Is there a wizard to override pieces of class (parameters, properties, methods, etc.) like there is in Studio? I can't find this functionality anywhere. If it's not there, it's certainly a piece I'll sorely miss as we transition to VS Code. #ObjectScript #VSCode #InterSystems IRIS 0 2 1 175
Question David Hockenbroch · Nov 2, 2022 Programmatically Adding Table Permission To A Role Is there a way to add specific table permissions to a security role programmatically? I'm working on scripting some of the initial setup work when we sell certain add-ons to our software, and I see how I can assign resources to a role and give it a description, but I don't see how I tell it that this role gives the user, for example, SELECT privileges only on the invoices table, or SELECT, INSERT, UPDATE, and DELETE. #ObjectScript #Access control #Security #Caché 0 1 1 263
Question David Hockenbroch · Sep 22, 2022 Can objectgenerators see compile flags? If I'm using an objectgenerator, is there a way to check the compile flags and have it behave differently based on which flags are set? And as a tangent, is there a list somewhere of what compile flags there are? #Compiler #InterSystems IRIS 0 5 0 269
Question David Hockenbroch · Jun 8, 2022 Restrict ODBC Access Based On Application Is there a way for us to restrict user's ODBC permissions based on what program they're running on a client? For example, we have some older Windows apps (.exe) that are a regular part of our software package which require the user to be able to select, insert, update, and delete. Some of our users are also using other third-party apps to connect (mostly reporting tools) but we only want them to be able to select unless we've approved the exe. Is there a way to do that? These are not applications that were developed using CacheDirect. #Access control #ODBC #Security #Caché 0 6 0 354
Question David Hockenbroch · Feb 28, 2022 Change User of CSP Session Is there a way, for testing purposes at least, to change a CSP session over to a different user? We have a lot of things in our system that are allowed or restricted based on the user login, so it would be useful for me to be able to occasionally run as a different user to see how things look and work for them. I've tried using the %CSP.Session.Login function, but that still shows the CSP session as being from the original user, not the one I've switched to. #CSP #Caché 0 3 0 376
Question David Hockenbroch · Oct 14, 2021 Indirection Different In Terminal Than In Method If I open a terminal and type the following commands, sc is an error: set validator = "sc = ##class(%Library.Numeric).IsValid(""BLAH"")" set @validator write sc At the end, when I write sc I get: 0 L'BLAH9 DOCXT010,#e^zIsValid+1^%Library.Numeric.1^1e^^^1 However, if I call the following class method using the arguments "%Library.Numeric" and "BLAH", sc is undefined #Debugging #ObjectScript #Terminal #Caché 0 12 0 478
Question David Hockenbroch · Jul 28, 2021 Can I programatically import a class from an XML file? If I export a class definition to an XML file, is there a way to programmatically import it so that I could schedule a task to look in a given location for XML files once a day and import class definitions? #Data Import and Export #XML #Caché 0 3 0 719
Question David Hockenbroch · Jul 20, 2021 Changes to Pivot Tables at Drill Down Levels I work on an ERP system and am trying to set up a dashboard according to a customer request. It's a pivot table with a few controls and filters, nothing too difficult, but I'm having some issues with drill down. #Analytics #Dashboards #Caché 0 3 0 247
Question David Hockenbroch · May 18, 2021 Unexpected Token Error in VS Code I'm trying to set up VS Code for ObjectScript using the instructions found here. I've got both Cache 2018.1.2.309.0 and IRIS 2020.1.0.215.0. When I try to connect to either one of them the connection fails, and I get a notification in the bottom right corner that says "Unexpected token < in JSON at position 0". I've checked the JSON settings file that VS Code uses, and they're fine and formatted properly. All of the settings I've entered are correct. #Compatibility #Development Environment #JSON #VSCode #InterSystems IRIS 0 20 0 5.8K
Question David Hockenbroch · Mar 10, 2021 Reserve a License Can a license be reserved for a specific user or group of users? So if I have 20 available licenses, only allow other users to use 19 of them while keeping one open for this specific user? #Security #Access control #InterSystems IRIS 0 3 0 391
Question David Hockenbroch · Feb 18, 2021 Analytics - Hyperlinks In Pivot Tables Is it possible to create a pivot table with a column containing a clickable hyperlink using a field from the cube definition as a part of the link? #InterSystems IRIS BI (DeepSee) 0 3 0 239