Can you clarify what you are trying to do please?

Are you trying to calculate the difference between the 2 dates/times? If that is the case have a look at the DATEDIFF(..) SQL functions.
https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RS…

Have you tried F11?

You may have to change the settings in vscode to recognise F11 as a Debug Command, rather than the "Fullscreen" command.

Apologies, I don't have vscode installed, so can't check myself.

See here for more information:
https://stackoverflow.com/questions/29955146/unable-to-debug-with-f11-w…

You can customise the refresh at the Backup Stage, you can define the list of Databases that will be Backed up before running the Backup.

See here for more details:
https://docs.intersystems.com/iris20241/csp/docbook/DocBook.UI.Page.cls…

But please make sure you test this in a development environment before touching your live system.

One other thing to note is that you should not put any long running processes in %ZSTART as they will hold up the Start process.

If you have to, then consider JOBbing it off to a separate process, so it can run in the background and allow the rest of the startup steps to run in parallel.

Deferred only relates to the unlock command, see here for some more details.

Basically, the unlock does not happen immediately, it will be done at the end of the transaction. ideally, this is what you want, and as long as your transactions are quite quick, it won't be an issue.

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

For quick and dirty logging I use:

kill ^Log at the beginning of the ClassMethod/Routine

Then use the following in your code to track what is going on:
set ^Log($increment(^Log))="Your message goes here. For example VariableX="_VariableX

Run your REST API and then take a look at ^Log.

You can either put lots of "set ^Log..." statements in, or just a few to narrow down where the issue is and just keep adding them till you get to the code in question. This might take a few iterations, but it generally works for me.

When you JOB a process you can get the ID of the child Process with $ZCHILD.

You can then check to see if that process is still running.

Not sure whether you can HALT the process or not, and depending on what it is you are running, it might not be a good idea.

I have just had to do something similar, but needed it to be Case Sensitive.
The only solution that I could find that would be Case Sensitive was the SQL solution.

You could write your own std deviation ClassMethod() in ObjectScript. You then have the flexibility to use that however you want.

The logic doesn't look that complex, and for a few thousand rows would run fast enough in Object Script.
See link below for the calculations you need to do:

https://www.scribbr.com/statistics/standard-deviation/
You can validate your results with the STDDEV(SQL) method, which will also allow you to compare performance.

If restarting Studio fails to resolve the issue, try rebooting your machine.

Just had this happen to me, restarting Studio, which normally fixes the issue failed.

Rebooting my laptop fixed the issue.
Studio Version.
InterSystems Studio Client  2022.1.3 Build 670 Patch 1
Server IRIS for Windows (x86-64) 2022.1.3 (Build 668U)

Did you check the port that management portal is running on?
Given that you have just done an install, it may have changed from the default?

This should show you the port that is being used: (Thanks to Jeffrey Drumm for this code).
%SYS>d ##class(Config.Startup).Get(.Prop)

%SYS>w Prop("WebServerPort")

This is a mix of the 2 other suggestions:

select count(*)
from Ens.MessageHeader
where TimeCreated between '2025-02-01 00:00:00' and '2025-02-28 23:59:59'
group by sessionid

All 3 options will work, always more than 1 way to skin a cat.

I would look a the SQL Show Plan to see which one is the most efficient.