Skip to Main Content
Forums

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.

Error message when compiling package body from a file

achim.rosenfeldOct 16 2024

When I open a package body from a file and press the compile button I get an error message since the update to 24.3.0.

The script output tab says that the package body compiled normally, and the change is visible in the database. Everything seems normal, except for the error message. When I open the package body from sql developer directly, the error does not occur.

I'm working on Windows 10, SQL Dev 24.3.0.

Log output:
[10/16/2024, 3:50:10 PM] [DBToolsServerApp(8284)] [ERROR] 2024-10-16T13:50:10.448Z ERROR DBTS-04000: Server Error

DBTS-04000: Server Error. An unexpected error with the following message occurred: file:///x%3A/apex/pk_ver_validierung_kredit.pkb. Retry the request, if the issue persists, report it to product support

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.jsonrpc.JsonRpcException.of(JsonRpcException.java:56)

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.jsonrpc.JsonRpc.handleError(JsonRpc.java:65)

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

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.jsonrpc.JsonRpc$Server.dispatch(JsonRpc.java:1184)

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.jsonrpc.JsonRpc$Server.onMessage(JsonRpc.java:1199)

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.jsonrpc.JsonRpc$Server$Endpoint.onMessage(JsonRpc.java:1601)

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.jsonrpc.JsonRpc$Server$Endpoint.onMessage(JsonRpc.java:1588)

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.lsp.LanguageServer$EndpointAdaptor.onMessage(LanguageServer.java:475)

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.lsp.LanguageServer$EndpointAdaptor.onMessage(LanguageServer.java:457)

at com.oracle.dbtools.utils.core@24.3.0/com.oracle.dbtools.utils.core.transport.WebSocketTransport$ListenerAdaptor.onText(WebSocketTransport.java:272)

at com.oracle.dbtools.utils.core@24.3.0/com.oracle.dbtools.utils.core.web.socket.WebSocket$ListenerFilter.onText(WebSocket.java:405)

at com.oracle.dbtools.utils.core@24.3.0/com.oracle.dbtools.utils.core.web.socket.server.WebSocketSupport$ErrorListener.onText(WebSocketSupport.java:501)

at com.oracle.dbtools.utils.jetty@24.3.0/com.oracle.dbtools.utils.jetty.JettyWebServerBridge$ListenerAdapter.onWebSocketPartialText(JettyWebServerBridge.java:290)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.messages.PartialStringMessageSink.accept(PartialStringMessageSink.java:58)

at org.eclipse.jetty.websocket.common@12.0.13/org.eclipse.jetty.websocket.common.JettyWebSocketFrameHandler.acceptFrame(JettyWebSocketFrameHandler.java:397)

at org.eclipse.jetty.websocket.common@12.0.13/org.eclipse.jetty.websocket.common.JettyWebSocketFrameHandler.onTextFrame(JettyWebSocketFrameHandler.java:368)

at org.eclipse.jetty.websocket.common@12.0.13/org.eclipse.jetty.websocket.common.JettyWebSocketFrameHandler.onFrame(JettyWebSocketFrameHandler.java:216)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.WebSocketCoreSession$IncomingAdaptor.lambda$onFrame$0(WebSocketCoreSession.java:647)

at org.eclipse.jetty.server@12.0.13/org.eclipse.jetty.server.handler.ContextHandler$ScopedContext.run(ContextHandler.java:1513)

at org.eclipse.jetty.server@12.0.13/org.eclipse.jetty.server.handler.ContextHandler$ScopedContext.run(ContextHandler.java:1500)

at org.eclipse.jetty.websocket.core.server@12.0.13/org.eclipse.jetty.websocket.core.server.internal.AbstractHandshaker$1.handle(AbstractHandshaker.java:179)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.WebSocketCoreSession$IncomingAdaptor.onFrame(WebSocketCoreSession.java:647)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.AbstractExtension.nextIncomingFrame(AbstractExtension.java:145)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.internal.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:239)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.util.DemandingFlusher.emitFrame(DemandingFlusher.java:143)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.internal.PerMessageDeflateExtension$IncomingFlusher.inflate(PerMessageDeflateExtension.java:492)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.internal.PerMessageDeflateExtension$IncomingFlusher.handle(PerMessageDeflateExtension.java:417)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.util.DemandingFlusher.process(DemandingFlusher.java:167)

at org.eclipse.jetty.util@12.0.13/org.eclipse.jetty.util.IteratingCallback.processing(IteratingCallback.java:262)

at org.eclipse.jetty.util@12.0.13/org.eclipse.jetty.util.IteratingCallback.succeeded(IteratingCallback.java:401)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.util.DemandingFlusher.onFrame(DemandingFlusher.java:105)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.internal.PerMessageDeflateExtension.onFrame(PerMessageDeflateExtension.java:96)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.ExtensionStack.onFrame(ExtensionStack.java:113)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.WebSocketCoreSession.onFrame(WebSocketCoreSession.java:463)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.WebSocketConnection.onFrame(WebSocketConnection.java:254)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.WebSocketConnection.fillAndParse(WebSocketConnection.java:447)

at org.eclipse.jetty.websocket.core.common@12.0.13/org.eclipse.jetty.websocket.core.WebSocketConnection.onFillable(WebSocketConnection.java:332)

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

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

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

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

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

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

at org.eclipse.jetty.util@12.0.13/org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:201)

at org.eclipse.jetty.util@12.0.13/org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:311)

at org.eclipse.jetty.util@12.0.13/org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:979)

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

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

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

Caused by: java.lang.IllegalArgumentException: file:///x%3A/apex/pk_ver_validierung_kredit.pkb

at com.oracle.dbtools.server.common.bridge@24.3.0/com.oracle.dbtools.server.common.bridge.sql.ObjectIdentifier.of(ObjectIdentifier.java:68)

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.lsp.text.document.TextDocuments.diagnostic(TextDocuments.java:286)

at com.oracle.dbtools.server.lsp@24.3.0/com.oracle.dbtools.server.jsonrpc.JsonRpc$Server$Builder.lambda$register$2(JsonRpc.java:1296)

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

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

... 46 more

[10/16/2024, 3:50:10 PM] [Worksheet ] [ERROR] Server Error

[10/16/2024, 3:50:10 PM] [Worksheet ] [ERROR] Server Error

Server Error
This post has been answered by thatJeffSmith-Oracle on Nov 5 2024
Jump to Answer

Comments

Post Details

Added on Oct 16 2024
4 comments
199 views