Question Jerry Petrole · Jan 14, 2022 Sending files with %Net.FtpSession Hello, Does anyone have experience sending files using %Net.FtpSession? I am not seeing any methods in the class for sending files and setting up an Ensemble production is not an option. Any advice would be appreciated. Thank you. #InterSystems IRIS 0 6 0 326
Question Jerry Petrole · Mar 22, 2021 Unknown error thrown with large file conversion to dynamic object. Hello I am creating an import tool to convert a client's JSON data into IRIS classes. The sample file is over half a gig. I am copying the data into an instance of %Stream.FileCharacter;. My first few attempts worked fine. However I started getting an error thrown when I try to create a DynamicAbstractObject using the %FromJSON method. See the code below. The error code given is not in the documentation, at least not the doc that I was searching. #JSON #InterSystems IRIS 0 3 0 375
Question Jerry Petrole · Feb 5, 2021 ODBC Connection - Receiving SQL Errors Hello, I have established an ODBC connection with our client based on credentials they provided. The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties. However when we try to execute a query in IRIS we are getting error code -226. I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client. We have tried with PostgreSQL as well as with TSQL. Same result for each. #ODBC #SQL #InterSystems IRIS 0 3 0 413
Question Jerry Petrole · Sep 5, 2019 SQL result set stepped on when calling to another method Hi all,We just encountered an instance of a result set RS and while looping through the results, RS is getting overwritten when method 1 calls out to method 2 (in the same class). Method 2 creates it own result set also named RS. This code is several years old and never had this problem. When I changed the name of the result set variable in method 1 the problem cleared up. I though that variables were automatically 'newed' in classmethods. ??? #Caché 0 4 0 226
Question Jerry Petrole · Jul 17, 2019 Allowing piecemeal access to System Operation functions Hello,Does anyone know if it's possible to allow a user type access to only certain parts of the System Operations page? Specifically, the System Logs - Application Error Logs.Thanks much!Jerry #System Administration #Caché 0 2 0 248