Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unable to create new connection or modify existing one

Matej D.Aug 13 2024

I got the same error when creating or modifying the existing connection (latest VS Code):

This error is from modifying connection 23ai (trying to rename to 23aix):

2024-08-13T19:00:02.698Z DEBUG - - - [13/Aug/2024:19:00:02 +0000] "GET /20221610/databases/connections/definitions/23ai HTTP/1.1" 200 - "-" "-" 39
[8/13/2024, 9:00:02 PM] [DBToolsServerApp(6444)] [DEBUG] PUT /20221610/databases/connections/definitions/23ai HTTP/1.1
Host: localhost
Request-Id: ndIzrHWfvNKwQLHfB054_A
Accept: application/json
Authorization: Signature key***dZA=="
Content-Length: 399
Content-Type: application/json
x-content-sha256: 7JghSF6l9aHjUns0F6F8EvH4sAlYQiD5iy2WjBvRDzw=
x-date: Tue, 13 Aug 2024 19:00:02 GMT
User-Agent: node-fetch/1.0 (+https://github.com/bitinn/node-fetch)
Accept-Encoding: gzip,deflate
Connection: close

{
"type": "ORACLE_BASIC",
"name": "23aix",
"host": "10.10.10.150",
"port": 1521,
"serviceName": "freepdb1",
"userName": "hr",
"userPassword": {
"valueType": "******",
"content": "******"
},
"links": [
{
"rel": "self",
"href": "http://localhost:56904/20221610/databases/connections/definitions/23ai"
}
]
}
[8/13/2024, 9:00:02 PM] [DBToolsServerApp(6444)] [DEBUG] HTTP/1.1 500 Internal Server Error
Request-Id: ndIzrHWfvNKwQLHfB054_A
Content-Type: application/json
2024-08-13T19:00:02.997Z DEBUG - - - [13/Aug/2024:19:00:02 +0000] "PUT /20221610/databases/connections/definitions/23ai HTTP/1.1" 500 - "-" "-" 288
[8/13/2024, 9:00:02 PM] [DBToolsServerApp(6444)] [ERROR] Error for: PUT /20221610/databases/connections/definitions/23ai
DBTU-03005: The resource identified by : 23ai could not be created due to an unexpected error

DBTU-03005: The resource identified by : 23ai could not be created due to an unexpected error. An unexpected error occurred during the create operation: C:\Users\xxxxx\AppData\Roaming\DBTools\connections\23ai -> C:\Users\xxxxx\AppData\Roaming\DBTools\connections\23ai.old. Ensure the resource is correctly formed
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.common.WebException.of(WebException.java:179)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.server.ErrorHandler.handleError(ErrorHandler.java:29)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.server.WebContainer.handleError(WebContainer.java:54)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.routes.Routes$Builder.lambda$new$0(Routes.java:155)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:100)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.routes.Routes$Resource.accept(Routes.java:715)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.routes.Routes$Resource.accept(Routes.java:696)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.routes.Routes.dispatch(Routes.java:110)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions$ImmutableRegistration.callIfMatches(Actions.java:325)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:93)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.server.EmbeddableComponent.dispatch(EmbeddableComponent.java:55)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions$ImmutableRegistration.callIfMatches(Actions.java:325)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:93)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.server.EmbeddableComponent.dispatch(EmbeddableComponent.java:55)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.web.server.EmbeddableContainer.dispatch(EmbeddableContainer.java:96)
at com.oracle.dbtools.utils.jetty@24.2.1/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.run(AdaptiveExecutionStrategy.java:201)
at org.eclipse.jetty.util@12.0.7/org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:410)
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 : 23ai could not be created due to an unexpected error. An unexpected error occurred during the create operation: C:\Users\xxxxx\AppData\Roaming\DBTools\connections\23ai -> C:\Users\xxxxx\AppData\Roaming\DBTools\connections\23ai.old. Ensure the resource is correctly formed
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.identifiers.ResourceException.createException(ResourceException.java:32)
at com.oracle.dbtools.server.connections@24.2.1/com.oracle.dbtools.server.connections.definitions.ConnectionDefinitions.update(ConnectionDefinitions.java:287)
at com.oracle.dbtools.server.connections@24.2.1/com.oracle.dbtools.server.connections.definitions.ConnectionDefinitions.update(ConnectionDefinitions.java:38)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.hypermedia.Hypermedia$Collection.update(Hypermedia.java:430)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.hypermedia.Hypermedia$Collection.updateItem(Hypermedia.java:301)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions$ImmutableRegistration.callIfMatches(Actions.java:325)
at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:93)
... 29 more
Caused by: java.nio.file.AccessDeniedException: C:\Users\xxxxx\AppData\Roaming\DBTools\connections\23ai -> C:\Users\xxxxx\AppData\Roaming\DBTools\connections\23ai.old
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.1/com.oracle.dbtools.server.connections.definitions.ConnectionDefinitions.write(ConnectionDefinitions.java:553)
at com.oracle.dbtools.server.connections@24.2.1/com.oracle.dbtools.server.connections.definitions.ConnectionDefinitions.update(ConnectionDefinitions.java:281)
... 34 more
[8/13/2024, 9:00:03 PM] [Connections Navigator] [ERROR] Failed action details
{
"action": "Save",
"connection": {
"name": "23aix"
},
"error": {
"errorCode": "DBTU-03005",
"message": "The resource identified by : 23ai could not be created due to an unexpected error",
"cause": "An unexpected error occurred during the create operation: C:\\Users\\xxxxx\\AppData\\Roaming\\DBTools\\connections\\23ai -> C:\\Users\\xxxxx\\AppData\\Roaming\\DBTools\\connections\\23ai.old",
"action": "Ensure the resource is correctly formed"
}
}

Regards

Comments
Post Details
Added on Aug 13 2024
11 comments
124 views