The CSPSystem user has probably been disabled because it has not been active for so long. You can connect to the terminal and use the ^SECURITY routine to display all the users and check the ones disabled. 

If this doesn't work and you need access quickly, contact the WRC. 

Understood! Thanks. 

Just to be sure I understand, the VS Code - InterSystems Lite Terminal (based on web sockets) also has the Xecute limitations you mentioned. If so, can you give some examples of the limitations and what your terminal can do better? I guess other people will have the same questions (especially people who doesn't live on terminal 😅

Hey @Dmitry Maslennikov , awesome job!

Have you thought about using WebSockets with a simple HTML/JS setup for your terminal, as the VS Code extension does? If you've already tried that and moved on, I’d love to know why. If not, it’s a super easy approach, and I’m sure you’ll have it working in no time.

Just create a WebSocket connection:

const socket = new WebSocket("ws://localhost:8273/api/atelier/v8/%25SYS/terminal");

Then hook it into your terminal like this:

term.onData(data => socket.send(data)); // Send input to the server

I did some tests and got a working terminal. It’s not as smooth as VS Code Lite or yours, but it's close! Let me know if you want to dive deeper.

Thanks! 

Adding the self-signed certificate to the operating System's root certificates (in my case, the Mac keychain under System) worked.

Once the certificate was added, I didn't need to set http.proxyStrictSSL to false.

I think this is not working anymore. I tried installing the v2.12.6 but got the message that the extension is not available from Visual Studio Code for the Web 🙁

I am having this same problem and I am using the latest extension. 

I added the 

"http.proxyStrictSSL": false

to the User settings.json , which is the same as

But still getting the error: 
 

Check your server details in Settings (vgorillaaws[VGORILLA]).

request to https://ec2-x.x.x.x.us-east-2.compute.amazonaws.com/api/atelier/ failed, reason: self signed certificate

I am using [2.5.0] - 2024-05-02 InterSystems Language Server

Thanks! And nice tips and lovely explanation,  now everything is making more sense. 

Regarding the pure Python approach, I am still struggling with how to use it in a much simpler way. Your last example is still too complex for a very simple scenario of one or two python files. 

Let me explain. I have this class in the file hello_world.py

class HelloWorld:
    def sayhello(self):
        print("Hello, World!")
        return "you did it!"

Then I would like to use it doing something like: 

Class dc.boto Extends %RegisteredObject
{

ClassMethod test1() [ Language = python ]
{
    from hello_world import HelloWorld
    # Create an instance of HelloWorld
    greeting = HelloWorld()

    # Call the say_hello method
    ret=greeting.sayhello()
    print(ret)
}

ClassMethod test2()
{
    Set hello = ##class(%SYS.Python).Import("/iris-shared/python/hello_world.py")
    Write hello.sayhello()
}

}

But this is throwing ModuleNotFoundError errors. 

I don't know if I have to create a packet and import it with pip... if so, it will be still complex. 😌
Is this possible? Do you see my point?

Yes, open a WRC problem and mention this GitHub. 

Great article!

I've gained a clearer understanding after reading it. However, I'm struggling a bit with your example. It seems a bit complex, especially for those of us who are new to integrating ObjectScript with custom Python classes and routines. A more straightforward example would be really helpful.

Your code particularly draws attention to the use of this class:

ClassMethod GetPythonInstance(
	pModule,
	pRemoteClassname) As %SYS.Python
{
    set importlib = ##class(%SYS.Python).Import("importlib")
    set builtins = ##class(%SYS.Python).Import("builtins")
    set sys = ##class(%SYS.Python).Import("sys")

    set module = importlib."import_module"(pModule)
    do importlib."reload"(module)

    set class = builtins.getattr(module, pRemoteClassname)
    return class."__new__"(class)
}

Could you elaborate on the rationale behind this specific structure, particularly the inclusion of builtins, importlib, and sys? Is there a simpler alternative you might suggest?

In my own projects, I've been using embedded Python with the Python tag, which usually is enough due to its simplicity and speed. However, as you mentioned, it lacks certain features. Eventually, I end up with numerous embedded functions, repeatedly importing the same libraries for each method, which looks cluttered. See:
 

ClassMethod moveFile() [ Language = python ]
{
    import boto3,iris
    # do stuff
}

ClassMethod getFile() [ Language = python ]
{
    import boto3,iris,json,datetime
    # do stuff
}

At this juncture, adopting your strategy to transfer all code to a .py file (not as a class) seems like a viable option, then accessing these methods via ObjectScript. I'm inclined to avoid Python classes due to their complexity and the need for instantiation. I prefer using functions for their simplicity and ease of understanding. What would you recommend in this scenario? How would calling code looks like? 

 

@Dmitry Maslennikov , WIJ file of 8GB means that the system wrote 8GB of cache buffers. This doesn't have to be a bad sign by itself and can be perfectly normal. 

Ups! I just realized you wrote the system is Caché and not Iris. So, instead of the messages.log, you should read cconsole.log. Instead of ^SystemCheck, it would be ^Buttons, and, instead of ^PerformanceCheck, it will be ^pButtons. 

This is not a nice error to see in a production environment. If this is a production site, I recommend contacting the Support department. 

To find the problem, you can look at the messages.log. There should be an error written with more details.

Most of the time, these errors are related to disk permissions or disk stress. Tools like ^SystemCheck and/or ^SystemPerformance will gather the required information to diagnose the problem. If you contact Support, they will probably ask for this.