The extension throws an error and stays on the “Activating Oracle SQL Developer Extension for VSCode..” step of the start up when there is an empty history file in the .dbtools/history folder.
This happened at some point using the extension, and I have no idea why there ended up being an empty (0 byte) YfS7qA.json file.
VSCode: 1.91.1
Extension: 24.1.2 & 24.1.1
Trace Log:
[6/18/2024, 12:41:30 PM] [DBToolsServerApp] [DEBUG] startServer: DBToolsServerApp
[6/18/2024, 12:41:30 PM] [DBToolsServerApp(25805)] [DEBUG] spawning
[6/18/2024, 12:41:30 PM] [dbtools-client ] [INFO ] Server startup completed
[6/18/2024, 12:41:32 PM] [DBToolsServerApp(25805)] [ERROR] DBTU-01004: An unexpected error occurred
DBTU-01004: An unexpected error occurred. An unexpected exception, of type: oracle.sql.json.OracleJsonException occurred. Please report this issue to product support
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.cli.CommandLineException.of(CommandLineException.java:42)
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.cli.ErrorHandler.handleError(ErrorHandler.java:19)
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:100)
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.cli.CommandLineInterface.dispatch(CommandLineInterface.java:250)
at com.oracle.dbtools.app@24.1.2/com.oracle.dbtools.app.DatabaseToolsApplication.main(DatabaseToolsApplication.java:41)
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.cli.Shell.execute(Shell.java:133)
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.cli.Shell.executeAndExit(Shell.java:163)
at com.oracle.dbtools.app@24.1.2/com.oracle.dbtools.app.DatabaseToolsApplication.main(DatabaseToolsApplication.java:33)
Caused by: oracle.sql.json.OracleJsonException: Invalid token EOF at line 1, column 0. Expected tokens are: [CURLYOPEN, SQUAREOPEN, STRING, NUMBER, TRUE, FALSE, NULL]
at com.oracle.database.jdbc@21.12.0.0.230906/oracle.jdbc.driver.json.OracleJsonExceptions$OracleExceptionFactory.createJsonException(OracleJsonExceptions.java:126)
at com.oracle.database.jdbc@21.12.0.0.230906/oracle.jdbc.driver.json.OracleJsonExceptions$2.create(OracleJsonExceptions.java:189)
at com.oracle.database.jdbc@21.12.0.0.230906/oracle.jdbc.driver.json.parser.JsonParserImpl.parsingException(JsonParserImpl.java:380)
at com.oracle.database.jdbc@21.12.0.0.230906/oracle.jdbc.driver.json.parser.JsonParserImpl$NoneContext.getNextEvent(JsonParserImpl.java:369)
at com.oracle.database.jdbc@21.12.0.0.230906/oracle.jdbc.driver.json.parser.JsonParserImpl.next(JsonParserImpl.java:311)
at com.oracle.dbtools.utils.jdbc@24.1.2/com.oracle.dbtools.utils.jdbc.json.JsonValues.of(JsonValues.java:50)
at com.oracle.dbtools.utils.jdbc@24.1.2/com.oracle.dbtools.utils.jdbc.json.OracleJsonBinding.parse(OracleJsonBinding.java:535)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.history.HistoryStorage.generateStatementHistoryFrom(HistoryStorage.java:173)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.history.HistoryStorage.replaceNameIfHashCodeFileExists(HistoryStorage.java:150)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.history.HistoryStorage.lambda$processStatementsHistory$1(HistoryStorage.java:116)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
at java.base/java.util.stream.SortedOps$RefSortingSink.end(SortedOps.java:395)
at java.base/java.util.stream.Sink$ChainedReference.end(Sink.java:261)
at java.base/java.util.stream.Sink$ChainedReference.end(Sink.java:261)
at java.base/java.util.stream.Sink$ChainedReference.end(Sink.java:261)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.history.HistoryStorage.processStatementsHistory(HistoryStorage.java:116)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.history.StatementHistoryFolder.load(StatementHistoryFolder.java:68)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.history.StatementHistoryFolder.(StatementHistoryFolder.java:30)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.history.StatementHistoryFolder$Builder.build(StatementHistoryFolder.java:194)
at com.oracle.dbtools.server.app@24.1.2/com.oracle.dbtools.server.api.DatabaseToolsServerApi.(DatabaseToolsServerApi.java:67)
at com.oracle.dbtools.server.app@24.1.2/com.oracle.dbtools.server.api.DatabaseToolsServerApi$Builder.build(DatabaseToolsServerApi.java:219)
at com.oracle.dbtools.server.app@24.1.2/com.oracle.dbtools.server.api.DatabaseToolsServerApiFactory.newInstance(DatabaseToolsServerApiFactory.java:80)
at com.oracle.dbtools.server.app@24.1.2/com.oracle.dbtools.server.api.DatabaseToolsServerApiFactory.newInstance(DatabaseToolsServerApiFactory.java:27)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.DatabaseToolsServer$Builder.register(DatabaseToolsServer.java:412)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at com.oracle.dbtools.server.core@24.1.2/com.oracle.dbtools.server.core.DatabaseToolsServer$Builder.registerExtensions(DatabaseToolsServer.java:426)
at com.oracle.dbtools.server.app@24.1.2/com.oracle.dbtools.server.app.DatabaseToolsServerApp.run(DatabaseToolsServerApp.java:153)
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.cli.CommandLineInterface$Definition.lambda$invoker$0(CommandLineInterface.java:775)
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.actions.Actions$ImmutableRegistration.callIfMatches(Actions.java:325)
at com.oracle.dbtools.utils.core@24.1.2/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:93)
... 5 more
[6/18/2024, 12:41:32 PM] [DBToolsServerApp(25805)] [TRACE] DBTU-01004: An unexpected error occurred. An unexpected exception, of type: oracle.sql.json.OracleJsonException occurred. Please report this issue to product support