SQL Developer for VS Code

We're readying an update to address a few known issues around connections, but to see if this is one of them, can you share the text shown on the Output panel, once you've set the filter to ‘SQL Developer - Log’ ?

Hi Jeff,
do you mean the Output Panel that appears at the bottom of the page where there are other tabs like Problems, Debug Console and so on?

If yes, I don't see anything in there, I get a notification, that's all.

PS: I am using VS Code on Windows 10.

Yes, but you need to set the filter on the right, and you may need to set the logging level of the extension to ‘TRACE’

Hi Jeff,

here is the output:

[8/7/2024, 10:00:08 AM] [DBToolsServerApp(53312)] [ERROR] Error for: POST /20221610/databases/connections/definitions/

DBTU-03005: The resource identified by : 3elNxjKHsYxoWsaHO7S0Gw could not be created due to an unexpected error

DBTU-03005: The resource identified by : 3elNxjKHsYxoWsaHO7S0Gw could not be created due to an unexpected error. An unexpected error occurred during the create operation: C:\Users\flacasetta\AppData\Roaming\DBTools\connections\3elNxjKHsYxoWsaHO7S0Gw.temp -> C:\Users\flacasetta\AppData\Roaming\DBTools\connections\3elNxjKHsYxoWsaHO7S0Gw. Ensure the resource is correctly formed

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.common.WebException.of(WebException.java:179)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.server.ErrorHandler.handleError(ErrorHandler.java:29)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.server.WebContainer.handleError(WebContainer.java:54)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.routes.Routes$Builder.lambda$new$0(Routes.java:155)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:100)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.routes.Routes$Resource.accept(Routes.java:715)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.routes.Routes$Resource.accept(Routes.java:696)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.routes.Routes.dispatch(Routes.java:110)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.actions.Actions$ImmutableRegistration.callIfMatches(Actions.java:325)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:93)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.server.EmbeddableComponent.dispatch(EmbeddableComponent.java:55)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.actions.Actions$ImmutableRegistration.callIfMatches(Actions.java:325)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:93)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.server.EmbeddableComponent.dispatch(EmbeddableComponent.java:55)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.web.server.EmbeddableContainer.dispatch(EmbeddableContainer.java:96)

at com.oracle.dbtools.utils.jetty@24.2.0/com.oracle.dbtools.utils.jetty.JettyWebServerBridge.handle(JettyWebServerBridge.java:79)

at org.eclipse.jetty.server@12.0.7/org.eclipse.jetty.server.handler.ContextHandler.handle(ContextHandler.java:765)

at org.eclipse.jetty.server@12.0.7/org.eclipse.jetty.server.Handler$Wrapper.handle(Handler.java:716)

at org.eclipse.jetty.server@12.0.7/org.eclipse.jetty.server.handler.EventsHandler.handle(EventsHandler.java:81)

at org.eclipse.jetty.server@12.0.7/org.eclipse.jetty.server.Server.handle(Server.java:179)

at org.eclipse.jetty.server@12.0.7/org.eclipse.jetty.server.internal.HttpChannelState$HandlerInvoker.run(HttpChannelState.java:619)

at org.eclipse.jetty.server@12.0.7/org.eclipse.jetty.server.internal.HttpConnection.onFillable(HttpConnection.java:411)

at org.eclipse.jetty.io@12.0.7/org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:322)

at org.eclipse.jetty.io@12.0.7/org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:99)

at org.eclipse.jetty.io@12.0.7/org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)

at org.eclipse.jetty.util@12.0.7/org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:478)

at org.eclipse.jetty.util@12.0.7/org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:441)

at org.eclipse.jetty.util@12.0.7/org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:293)

at org.eclipse.jetty.util@12.0.7/org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.produce(AdaptiveExecutionStrategy.java:195)

at org.eclipse.jetty.util@12.0.7/org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:971)

at org.eclipse.jetty.util@12.0.7/org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1201)

at org.eclipse.jetty.util@12.0.7/org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1156)

at java.base/java.lang.Thread.run(Thread.java:1583)

Caused by: DBTU-03005: The resource identified by : 3elNxjKHsYxoWsaHO7S0Gw could not be created due to an unexpected error. An unexpected error occurred during the create operation: C:\Users\flacasetta\AppData\Roaming\DBTools\connections\3elNxjKHsYxoWsaHO7S0Gw.temp -> C:\Users\flacasetta\AppData\Roaming\DBTools\connections\3elNxjKHsYxoWsaHO7S0Gw. Ensure the resource is correctly formed

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.identifiers.ResourceException.createException(ResourceException.java:32)

at com.oracle.dbtools.server.connections@24.2.0/com.oracle.dbtools.server.connections.definitions.ConnectionDefinitions.create(ConnectionDefinitions.java:174)

at com.oracle.dbtools.server.connections@24.2.0/com.oracle.dbtools.server.connections.definitions.ConnectionDefinitions.create(ConnectionDefinitions.java:38)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.hypermedia.Hypermedia$Collection.create(Hypermedia.java:360)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.hypermedia.Hypermedia$Collection.createItem(Hypermedia.java:280)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.actions.Actions$ImmutableRegistration.callIfMatches(Actions.java:325)

at com.oracle.dbtools.utils.core@24.2.0/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:93)

... 28 more

Caused by: java.nio.file.AccessDeniedException: C:\Users\flacasetta\AppData\Roaming\DBTools\connections\3elNxjKHsYxoWsaHO7S0Gw.temp -> C:\Users\flacasetta\AppData\Roaming\DBTools\connections\3elNxjKHsYxoWsaHO7S0Gw

at java.base/sun.nio.fs.WindowsException.translateToIOException(WindowsException.java:89)

at java.base/sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:103)

at java.base/sun.nio.fs.WindowsFileCopy.move(WindowsFileCopy.java:328)

at java.base/sun.nio.fs.WindowsFileSystemProvider.move(WindowsFileSystemProvider.java:291)

at java.base/java.nio.file.Files.move(Files.java:1430)

at com.oracle.dbtools.server.connections@24.2.0/com.oracle.dbtools.server.connections.definitions.ConnectionDefinitions.write(ConnectionDefinitions.java:555)

at com.oracle.dbtools.server.connections@24.2.0/com.oracle.dbtools.server.connections.definitions.ConnectionDefinitions.create(ConnectionDefinitions.java:171)

... 33 more

[8/7/2024, 10:00:08 AM] [Connections Navigator] [ERROR] Failed action details

{

"action": "Save",

"connection": {

"name": "AGRPRD"

},

"error": {

"errorCode": "DBTU-03005",

"message": "The resource identified by : 3elNxjKHsYxoWsaHO7S0Gw could not be created due to an unexpected error",

"cause": "An unexpected error occurred during the create operation: C:\\\\Users\\\\flacasetta\\\\AppData\\\\Roaming\\\\DBTools\\\\connections\\\\3elNxjKHsYxoWsaHO7S0Gw.temp -> C:\\\\Users\\\\flacasetta\\\\AppData\\\\Roaming\\\\DBTools\\\\connections\\\\3elNxjKHsYxoWsaHO7S0Gw",

"action": "Ensure the resource is correctly formed"

}

}

Hi,

is there any solution for this. I am experiencing the same error, identical stack trace here. SQL Developer extension version
24.4.1 and VSC Version 1.96.3

Thanks

Daniel

Issue has been raised and we're currently tracking it for future release.

When will the Oracle solution arrive?

When will it be ready?

Next scheduled update is March, 25.1