Running Python script from terminal vs studio

Question

Question

Akshay Pandey · Oct 25, 2021

#Caché

I have created on class method which execute below command

From terminal : _System account works fine where code=0

From Studio : _System account give syntax error where code=1

set code = $zf(-1,"python C:\keys\GetToken.py")

w !, code

Product version: IRIS 2020.1

$ZV: IRIS for Windows (x86-64) 2020.1 (Build 215U) Mon Mar 30 2020 20:14:33 EDT

Discussion (20)3

Log in or sign up to continue

Robert Cemper · Oct 25, 2021

In a terminal session you have a process and $ZF(-1) starts a child process
From Studio this is definitely different as Studio uses a different type of connection using SuperServer port.
https://docs.intersystems.com/iris20211/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fzf-1

0 0

Robert Cemper · Oct 25, 2021

this looks like "python" is not recognized in the spawned process
You may try a full reference "C:\......python.exe...."

0 0

Vic Sun · Oct 26, 2021

Hello all,

I just wanted to emphasize this point by Robert, which I think is the most critical. Studio is not a real terminal. I understand it can be convenient to test small bits of code in the Studio window, but I would not expect everything to work.

0 0

Robert Cemper · Oct 26, 2021

Hi @Vic Sun , @Akshay Pandey :
Just to complete this discussion.
From Terminal I could run Py also from a JOB, and over CPIPE without problems.
From Studio Output all this FAILS.
Which makes clear that the process behind Studio is far away from being a normal
IRIS/Caché process and just good for editing and compiling. FullStop.

I would even assume that running COS commands was not planned but rather an accident that happened 20 yerars ago.

0 0

Robert Cemper · Oct 26, 2021

Just an idea:
I assumed that you use a local installation of IRIS
Is this correct ?
Or does it run on some instance separate from your local WIN.
whoami is equivalent to echo %USERDOMAIN%\%USERNAME%

write $zf(-1,"hostname > c:\temp\hostname.txt")

may clarify this.
If it's not the same machine you need a PY installation this server

0 0

Robert Cemper · Oct 26, 2021

I spent quite a while on the subject of python. Also the asynchronous $ZF(-2) + error log

write $zf(-2,"C:\Users\cemper\AppData\Local\Microsoft\WindowsApps\pythonw3.9.exe <c:\temp\in.py 1>c:\temp\5out.txt 2>c:\temp\5er.txt")

And the error from WINDOWS was always: the program can not be executed
A further reason to use Embedded Python!

in.pyw is simply

print("success") exit()

1 0

Vitaliy Serdtsev · Nov 2, 2021

I did a small test locally (for Caché).

test.py:

print("success")

exit()

From terminal:

USER>w $zf(-1,"python C:\tmp\test.py")
0

From Studio Output Window:

w $zf(-1,"python C:\tmp\test.py")
0

Make sure that your service for Caché/IRIS use an account with administrative rights:

0 0

score 0 · Answer 1 · 2021-10-25T10:26:08-04:00

Robert Cemper · Oct 25, 2021

does it change using %cde instead of code as variable ?

0 0

score 0 · Answer 2 · 2021-10-25T11:05:43-04:00

nope...code =0 means sucess

code =1 means syntax error

I am not sure how same method is behaving differently

score 1 · Answer 3 · 2021-10-25T11:15:00-04:00

Robert Cemper · Oct 25, 2021

studio is not a real terminal with an isolated session context.

1 0

score 0 · Answer 4 · 2021-10-25T11:22:45-04:00

Classmethod Test() {

set code = $zf(-1,"python C:\keys\GetToken.py")

W ! , code

}

Classmethod Test2() {

set code = $zf(-1,"echo hello>C:\keys\test.txt")

W ! , code

}

Studio Output Window

Do ##class(Test).Test()

1

Do ##class(Test).Test2()

0

Cache terminal

Do ##class(Test).Test()

0

Do ##class(Test).Test2()

0

this is what is happening

score 2 · Answer 5 · 2021-10-25T17:42:05-04:00

Hi Akshay,

Robert is correct.

$ZF(-1,{os command}) is used to call commands from the underlying operating system.

The shell that you execute won't know where to find the python executable.

We can see this by trying to print the Windows PATH environment variable (below) as you would normally be able to do in a Windows CMD shell:

As we can see above the CMD shell can see the environment variable %PATH% but if we do the same echo %PATH% in terminal we see nothing.

Cheers,
Patrick

score 0 · Answer 6 · 2021-10-25T18:02:43-04:00

thanks for the clarification. I had a similar experience with node.js before.
But was not so certain to know the reasoning.

score 0 · Answer 7 · 2021-10-26T03:01:11-04:00

I have tried with full path as well still not working

Studio
d $zf(-1,"whoami > c:\temp\whoami.txt")

nt authority\system ( i dont know which user is this

Terminal

d $zf(-1,"whoami > c:\temp\whoami.txt")

give local user

score 0 · Answer 8 · 2021-10-26T04:22:55-04:00

this is local installation

I did tried with complete python.exe path as well.

but when -ZF(-1) running from studio its not working

score 0 · Answer 9 · 2021-10-26T06:14:52-04:00

When you use 'Studio', you are recognised like an administrator (nt authority\system) and not a local user.

Don't use $ZF(-1) : $ZF(-1) is a deprecated function. All new code development should use $ZF(-100).

What about your python with the new recommendation?

score 0 · Answer 10 · 2021-10-26T06:40:15-04:00

I tried with $ZF(-100) as well still I get code=1 (Syntax error)

same method while running from cache terminal works fine

whereas running from studio gives error

score 1 · Answer 11 · 2021-10-26T12:09:02-04:00

John Murray · Oct 26, 2021

My article at https://community.intersystems.com/post/who-does-windows-think-i-am may be relevant here.

1 0

score 0 · Answer 12 · 2021-10-26T13:20:06-04:00

Robert Cemper · Oct 26, 2021

Excellent fit!

0 0

score 2 · Answer 13 · 2021-11-02T09:03:20-04:00

Small suggest - use $zf(-100) rather than $zf(-1) as it is more secure and $zf(-1) is not supposed to be used anymore (it is kept in place for backward compatibility but it really is deprecated for use in new code)