Hi all, I have a question about the new Oracle SQL Developer extension in VS Code.
We have installed VS Code on our Citrix machine and the extension in the "C:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1" directory.
When VS Code is started on the Citrix machine itself, the extension loads fine (using the local Administrator account). However, if we start VS Code via remote Citrix using personal AD accounts, the extension is stuck on "Activating Oracle SQL Developer Extension for VSCode...".
I suspect it's a permission issue, because VS Code was installed on the Citrix machine using the local Administrator account. We want the extension to be globally available for all AD users of the Citrix machine.
What we have tried so far to fix this:
- Delete the extension from the global \app\extensions\ folder, run VS Code from Citrix as AD user and then install the extension manually from the .vsix file. This installs the extension for the logged-in user only, but the error is still present.
- Edit the "activationEvents" to "*" in the \oracle.sql-developer-24.3.1\package.json file.
- Temporarily change permissions of the “C:\Program Files\Microsoft VS Code\resources\app\extensions” directory, to allow full access for all users.
Any suggestions to make this work via Citrix?
// UPDATE
Some output from the logs:
[11/21/2024, 2:09:16 PM] [dbtools-ext ] [INFO ] Activating Oracle SQL Developer Extension for VSCode...
[11/21/2024, 2:09:16 PM] [dbtools-client ] [INFO ] Starting server...
[11/21/2024, 2:09:16 PM] [dbtools-ext ] [ERROR] connect error spawn EPERM
[11/21/2024, 2:09:16 PM] [language-service] [INFO ] Closing
[11/21/2024, 2:09:16 PM] [language-service] [INFO ] closed
[11/21/2024, 2:09:16 PM] [dbtools-client ] [INFO ] Closing
[11/21/2024, 2:09:16 PM] [dbtools-client ] [INFO ] Sending server shutdown
[11/21/2024, 2:09:16 PM] [dbtools-client ] [INFO ] dbtools-server process terminated
[11/21/2024, 2:09:16 PM] [dbtools-client ] [INFO ] Closed
2024-11-21 14:09:16.546 [info] Extension host with pid 1920 started
2024-11-21 14:09:16.554 [info] Eager extensions activated
2024-11-21 14:09:16.556 [info] ExtensionService#_doActivateExtension Oracle.sql-developer, startup: false, activationEvent: 'onStartupFinished'
2024-11-21 14:09:16.877 [error] Activating extension Oracle.sql-developer failed due to an error:
2024-11-21 14:09:16.877 [error] Error: spawn EPERM
at ChildProcess.spawn (node:internal/child_process:421:11)
at Object.spawn (node:child_process:796:9)
at t.DBToolsServerApp.spawn (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:487414)
at t.DBToolsServerApp.startServer (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:488701)
at c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:494884
at new Promise (<anonymous>)
at t.DatabaseToolsClient.<anonymous> (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:494773)
at Generator.next (<anonymous>)
at c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:490169
at new Promise (<anonymous>)
at r (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:489914)
at t.DatabaseToolsClient.startServer (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:494606)
at t.DatabaseToolsClient.<anonymous> (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:493300)
at Generator.next (<anonymous>)
at c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:490169
at new Promise (<anonymous>)
at r (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:489914)
at t.DatabaseToolsClient.connect (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:493236)
at c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:652189
at Generator.next (<anonymous>)
at c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:651394
at new Promise (<anonymous>)
at r (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:651139)
at F (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:652118)
at c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:654545
at Generator.next (<anonymous>)
at c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:651394
at new Promise (<anonymous>)
at r (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:651139)
at t.activate (c:\Program Files\Microsoft VS Code\resources\app\extensions\oracle.sql-developer-24.3.1\dist\extension.js:2:652859)
at pw.kb (file:///c:/Program%20Files/Microsoft%20VS%20Code/resources/app/out/vs/workbench/api/node/extensionHostProcess.js:118:15214)
at pw.jb (file:///c:/Program%20Files/Microsoft%20VS%20Code/resources/app/out/vs/workbench/api/node/extensionHostProcess.js:118:14921)
at file:///c:/Program%20Files/Microsoft%20VS%20Code/resources/app/out/vs/workbench/api/node/extensionHostProcess.js:118:13079
at async B0.n (file:///c:/Program%20Files/Microsoft%20VS%20Code/resources/app/out/vs/workbench/api/node/extensionHostProcess.js:114:4447)
at async B0.m (file:///c:/Program%20Files/Microsoft%20VS%20Code/resources/app/out/vs/workbench/api/node/extensionHostProcess.js:114:4410)
at async B0.l (file:///c:/Program%20Files/Microsoft%20VS%20Code/resources/app/out/vs/workbench/api/node/extensionHostProcess.js:114:3866)