In that case, I would say go ahead and download IRIS. You're unlikely to run into a compatibility issue and you'll have access to the new IRIS features.

Hello Guilherme,

Why do you ask? I can't say literally everything to your 2 questions but the vast majority of things are available across products and OSes. A few technologies have been deprecated/removed from IRIS so those won't be available, you can read about those in the IRIS migration guide available from the WRC distributions. Separately, I'm aware that there are at least a few OS-specifics that are documented as exceptions.

Do you have specific functionality that you are concerned about?

Your link is personalized to your login so I wasn't able to load it, but I found ISC1064 Building Custom Business Operations. I didn't see any references to enslib explicitly when I scanned; can you point to which module or what the instruction is asking you to do?

The exercises I see refer to the INTEROP namespace, which I see is preinstalled in the lab.

If you find something that doesn't look correct in a course, you can reach out to onlinetraining@intersystems.com for guidance/correction.

edit: once I registered for the course your link then worked and brought me to 2.2 the section on adapters, but I still didn't see a specific reference to Enslib.

Hello Michael,

I'll post this on Li's original post as well, but if this is on Windows I suspect this is an issue with using the default SYSTEM account. See the following doc:

Installing InterSystems IRIS on Microsoft Windows > Windows User Accounts

"When installing InterSystems IRIS, you must choose the Windows user account to run the InterSystems service. There are two options:

The default SYSTEM account (Windows Local System account). This is used in Minimal security installations.

A defined Windows user account.

Running the Windows InterSystems service under the default SYSTEM account is appropriate for many installations, but in some cases can cause issues relating to file permissions and network security access. If you anticipate potential problems in these areas for an InterSystems IRIS instance, for example due to your network configuration or security arrangements, specify an account for the Windows InterSystems service that has the needed privileges and/or access, such as a domain administrator account.

For instructions on how to change the service account after installation, see the Managing Windows User Access to the InterSystems IRIS Instance section."

Changing the InterSystems Service Account

<install-dir>\bin\IRISinstall.exe setserviceusername <instance-name> <username> <password>

Crys,

I reached out to online training and they let me know this issue should be resolved. I confirmed this at https://gettingstarted.intersystems.com/full-stack/full-stack-part-one/#getsandbox.

If you're still having an issue, I'd advise reaching out to them directly.

I took a quick look through learning.intersystems.com and wonder if the following resources would be helpful as well:

"Building Your First HL7 Production"

https://learning.intersystems.com/course/view.php?id=1350

"HL7 Business Services and Business Operations"

https://openedx.learning.intersystems.com/courses/course-v1:InterSystems+ISC1149+2020_02/info

Hello Rahul,

I'd check your messages.log to see messages regarding the private webserver. Then I'd check the OS to see if anything is holding your configured web server port.

This could be worth a new post, or contacting the WRC.

Hello Mike,

I don't have a sample for scripting it, but if you haven't seen it already, the IRIS server migration guide contains a list of items and methods for exporting them. I think it's a good reference for keeping in mind the things you might want to bring over.

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=AMIG

Also, I might agree with Armin that doing a multi-stage upgrade could be easier - perhaps you've already identified a reason why it won't work for you though.

Hello Dustin,

There are a few things you can try to find out more about this.

1. Making an SFTP connection in terminal so you add additional debugging - https://community.intersystems.com/post/using-and-debugging-netsshsession-ssh-connections

2. Trying a different SFTP client - this will help identify if there's a problem connecting between the servers (network / firewall change, for example). If no SFTP client works, then you likely want to involve your network team / the downstream's network team (or potentially security team, different orgs might label the relevant party differently).

3. If the SFTP connection was working earlier, but nothing was changed in Ensemble, then it seems pretty apparent that something changed outside of Ensemble. You could see when the problem started and ask around internally / externally to see what might have changed.

Hello Nikhil,

What problem are you trying to solve or what exactly are you trying to do? See the below docs:

"The maximum length of a subscript is 511 encoded bytes (the corresponding number of characters depends on the characters in the subscript and the current locale)"

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCOS_variables#GCOS_variables_subscripts

Maximum Length of a Global Reference

You can use $length to get the length of a string, but depending on what you want to do, that may determine how you can get the value of the subscript.

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_d_length

Hello Wenjie,

^oddPROC is an internal global with metadata for your BAIYAOJIREQUEST class (I think in your custom Ensemble.Ens package, not sure exactly how the characters translate). I think for this issue you may want to reach out to InterSystems support so they can look into what may have happened to "corrupt" that global and look into solutions. Do you have any ideas of whether something unusual might have happened to that class?

Is this what you mean by Rose? It's not a technology I'm familiar with, but from this page and your description it sounds like an HA cluster with shared storage:

https://www.rosedata.com/index_en.php/Prodetail/index/proid/1

Do you have any specific questions about this setup?

Can you provide more detail on what kind of disaster events you are looking to handle? What is your desired behavior? Basically, I would suggest thinking about different disaster scenarios and how this environment would react.

Failover Strategies for High Availability

Here are the docs regarding different HA strategies including HA clustering and mirroring. The main point they highlight for a HA cluster with shared storage is that the disk then becomes a single point of failure. Adding a mirror instance on separate hardware provides an option if your RoseHA disk fails.

Ah, that is certainly a separate issue. Hopefully, you figure out what's causing that or somebody has ideas, but I've not seen random recompiles personally.

I agree that Danny's suggestion to review where your licenses are being used is a good starting point.

Since you mention using this license across multiple servers, I would consider the different ways your developers are connecting to Caché. If a developer has Studio, the management portal, and a terminal session open, they are probably using more than 1 license. Even with a limit of 2 developers per server, if 6 developers are on the 3 servers connecting multiple ways, you could surpass a 10 user limit.

You may need a more robust license to support your team's usage patterns.

Hello again Fábio,

These errors are one part of the picture. It would probably be beneficial to open a ticket with the WRC so they can look into these errors and your performance issues to see if they are related/separate.

Do you know what queries are triggering these errors? w3wp.exe is an IIS process but I'm not familiar with EXTRService.exe or KIORAS. Perhaps the IP addresses can also help you narrow down the source.

The <READ> errors indicate something like a problem reading from the socket, but that doesn't explain the cause. There may be other logs you can review in your environment to help explain this.

Hello Fábio,

I'm just quoting the class reference I linked:

"This method is called to remove data from the %SYS.PTools.SQLStats table. It does not remove data from %SYS_PTools.SQLQuery, those rows are cleaned up when a query is compiled"

You can take a look at what's actually filling up your CACHE database to determine if this will work for you. For a complete purging, I'd go with purging cached queries, as that's the "full" solution.

Hello Fábio,

In IRIS there is a convenient SQL Runtime Statistics page where you can purge those stats.

Using the SQL Runtime Statistics Tool

On your version, the equivalent tool only offers the option to purge cached queries, so I think that's what you'll need to do. %SYS.PTools.SQLStats.Purge will purge some of the SQL stats data, though not all.

"Purging a cached query purges any related SQL Stats data. Dropping a table or view purges any related SQL Stats data."

edit: corrected, CE 2018.1.5 does not have the purge stats option that IRIS does.

Hello Alex,

Have you confirmed that the original transaction process goes away when the VPN disconnects? How are you opening the terminal in the first place?

If disconnecting the VPN leaves the original process around, it won't have a chance to rollback the transaction.

edit: perhaps this is related to your Journal Freeze on error setting?

Hello Eudoro,

It sounds like you may be able to leverage mirroring, which is built-in and is an IRIS functionality where separate instances of IRIS can automatically transfer journal files to synchronize their copies of a database. Docs here:

Mirroring Architecture and Planning

Hello Michael,

I tested this in terminal calling ##class(Ens.Util.FunctionSet).CurrentDateTime(), and I can't see a reason why you couldn't use a variable in this function. You'd need to concatenate your variable into the time format string, ex:

..CurrentDateTime("%K("_tDstOffSet_")%q")

Let me know if that works for you.