go to post Scott Roth · Oct 30, 2023 We have turned off Telnet, and use ssh to connect to our servers, then open a terminal prompt by running... :>iris session <name space> There are many different clients out there from Windows Terminal, Cygwin, MobaXTerm, XWin32, even Windows Powershell would work with ssh. It all a matter of preference...
go to post Scott Roth · Oct 6, 2023 I tracked down the issue to %Service_Login being disabled, as I thought this service was just used for API calls and not internally.
go to post Scott Roth · Oct 6, 2023 While thinking about this, I am wondering if using an encryption key might be a possible solution as well that way there is limited access to the password, and the key would just have to be regulated to be updated every so often. With using a AD service account, the password still needs to be updated or kept up to date, and still needs to be passed into the shell script for Terminal to open. I have submitted the following IDEA... https://ideas.intersystems.com/ideas/DPI-I-466
go to post Scott Roth · Sep 6, 2023 I posted this as an Idea on the Idea Portal... https://ideas.intersystems.com/ideas/DPI-I-368
go to post Scott Roth · Aug 28, 2023 At the Java Gateway Service, I have specified the following JVM Args -d64 -XX:+DisableExplicitGC -XX:+AggressiveOpts At the %JDBCServer level, I have specififed -d64 -Xmx1024m -XX:+DisableExplicitGC -Xss512k I have often asked for Best Practices but have not had much response. You have to play with the settings as you go...
go to post Scott Roth · Aug 3, 2023 The issue was with the code that I was using in my Business Operation that was not calling the SSL Configuration. I have since reverted my Business Operation code back to the more standard code that is described in the Documentation, however I am still running into issues making sure the correct format of the Header is being sent in the REST API call, and how to interpret the JSON that is being returned by the REST API.
go to post Scott Roth · Aug 3, 2023 According to WRC there is a memory leak with the way the Class Path of the driver is being handled. The reason for this issue was that I had the Class Path defined within the SQL Gateway. I thought this was only due to the jTDS driver we were using, but it is an overall issue with any Java Gateway Service. So I updated the Java Gateway service I was using for the Microsoft JDBC Connection for that Database to now have the Class Path of the driver, and I have not seen issues since.
go to post Scott Roth · Jul 20, 2023 For others I figured out the issue. Had to use the Base64 formatted Certificate Chain (p7b) from Windows ADCS (Active Directory Certificate Service). Download Base64 p7b to /etc/pki/ca-trust/source/anchors/ in RedHat Change ownership group to include irisusr Change permissions to Read (666) Convert p7b to pem sudo openssl pkcs7 -in xxxxx.p7b -print_certs -out xxxxx.pem When I went through testing the request I got the following... DEVCLIN>set request=##class(%Net.HttpRequest).%New() DEVCLIN>set request.Server = "xxxxxxxxxxxx" DEVCLIN>set request.Port=443 DEVCLIN>set request.SSLConfiguration="OSUWMC" DEVCLIN>set request.Https=1 DEVCLIN>set tSC=request.Get("/",2)HTTP/1.1 200 OKACCEPT-RANGES: bytesCACHE-CONTROL: privateCONTENT-ENCODING: gzipCONTENT-LENGTH: 467CONTENT-TYPE: text/htmlDATE: Thu, 20 Jul 2023 20:08:54 GMTETAG: "b072b0f23afdd01:0"LAST-MODIFIED: Fri, 02 Oct 2015 17:51:21 GMTNTCOENT-LENGTH: 701SERVER: Microsoft-IIS/8.5X-POWERED-BY: ASP.NET <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>IIS Windows Server</title><style type="text/css"><!--body { color:#000000; background-color:#0072C6; margin:0;} #container { margin-left:auto; margin-right:auto; text-align:center; } a img { border:none;} --></style></head><body><div id="container"><a href="http://go.microsoft.com/fwlink/?linkid=66138&clcid=0x409"><img src="iis-85.png" alt="IIS" width="960" height="600" /></a></div></body></html>
go to post Scott Roth · Apr 20, 2023 I didn't realize I had posted this same error years ago. The answer was in my other post. In the DTL I was setting the Path = tSC which was being used in other ways.
go to post Scott Roth · Apr 10, 2023 The problem was from having the Port Authority previously setup using the Namespace before it was recreated. Working with WRC, I had to delete the existing Doc DB IRIS Interoperability from Doc DB Applications, remove the existing job from the task manager, and recreate the Task Scheduler job to have it recreated.
go to post Scott Roth · Dec 22, 2022 Using Ens.Director EnableConfig Item someone in our team wrote a shell script that runs on cron to start and stop objects. Or run it off the scheduler or task schedule.
go to post Scott Roth · Aug 11, 2022 Why not use a view instead of a Temporary table? Since Temporary Tables are just Temporary and created at the time of execution how are you setting privs on the Temporary Table.
go to post Scott Roth · Jul 6, 2022 WRC is the support desk for InterSystems. https://login.intersystems.com/login/SSO.UI.Login.cls?referrer=https%253...
go to post Scott Roth · Jul 6, 2022 I am not sure then, maybe a call to WRC would help further as I have not experienced this issue.
go to post Scott Roth · Jul 6, 2022 An issue I see with the code is with the value you are specifying with ConvertDateTime. If you are sending YYYY-mm-dd your code needs to account for that "%Y-%m-%d" set parms(1) = ##class(Ens.Rule.FunctionSet).ConvertDateTime("2022-01-01","%Y-%m-%d","%q(1)")set parms(2) = ##class(Ens.Rule.FunctionSet).ConvertDateTime("2022-01-05","%Y-%m-%d","%q(1)")
go to post Scott Roth · Jul 6, 2022 How is the date columns defined in your Stored Procedure class file? For example I have a InsertProviderSp class file that represents all of the Parameters of the stored procedure, and within it I have a Property DOB As %TimeStamp. My method within my Outbound adapter looks like this.... If you are "hardcoding" the dates within the EnsLib.SQL.OutboundAdapter, you could be able to call the above ConvertDateTime by adding lines to for ##class(Ens.Rule.FunctionSet).ConvertDateTime.... I have many cases where I am inserting, update, or querying data from external MS SQL sources to pull into Ensemble, so let me know if you still need help.
go to post Scott Roth · Jun 27, 2022 I am not sure which context you are using to populate the Stored Procedure, but if you are using a DTL, I used ..ConvertDateTime((field),"%Y%m%d","%q(1)")
go to post Scott Roth · Jun 6, 2022 Not all the MSH:9 fields are filled out as most of our downstream systems only use MSH:9.1 and MSH:9.2, so MSH:9.3 is not filled out. Do we need to fill out MSH:9.3?
go to post Scott Roth · Apr 13, 2022 Yes, I was able to create separate roles, and copy the existing Data Lookup pages, locking the users down to only being able to access that particular page for their lookup tables. There are two class files that would need to be created. 1. Filter Dialog if you want to limit the users down to their particular tables. 2. A copy of EnsPortal.LookupSettings - which will limit users ability to get to other places within Ensemble. I haven't tested this in IRIS just yet as we are in the process of moving to IRIS.