Skip to Main Content

SQLcl

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.

project stage error

Evaristo EusebioJan 24 2025

I'm trying to follow the example from Examples to test sqlcl project. I'm running sqlcl v24.3.2.330.1718 from a Windows CMD and I've managed to follow the steps without any issues until the project stage step where it throws an error:

normal output:

Stage is Comparing:
Old Branch refs/heads/master
New Branch refs/heads/base-release

ERROR: An error has occurred processing your request:
Cannot parse null string

verbose output:

result: diff DiffEntry[ADD src/database/dummy_schema/views/dummy1.sql]
result: diff DiffEntry[ADD src/database/dummy_schema/views/dummy2.sql]
result: diff DiffEntry[ADD src/database/dummy_schema/views/dummy3.sql]

ERROR: An error has occurred processing your request:
Cannot parse null string
java.lang.NumberFormatException: Cannot parse null string
at java.base/java.lang.Integer.parseInt(Integer.java:630)
at java.base/java.lang.Integer.parseInt(Integer.java:786)
at oracle.dbtools.extension.project.core.utils.ProjectUtils.checkValidSchemas(ProjectUtils.java:382)
at oracle.dbtools.extension.project.commands.stage.utils.StageUtils.createChangelogFiles(StageUtils.java:331)
at oracle.dbtools.extension.project.commands.stage.utils.StageUtils.checkDirectories(StageUtils.java:241)
at oracle.dbtools.extension.project.commands.stage.utils.StageUtils.<init>(StageUtils.java:139)
at oracle.dbtools.extension.project.commands.stage.StageCommand.run(StageCommand.java:163)
at oracle.dbtools.extension.project.commands.handler.CommandHandler.StageCommand(CommandHandler.java:59)
at oracle.dbtools.extension.project.commands.handler.ProjectCommand.handleEvent(ProjectCommand.java:75)
at oracle.dbtools.raptor.newscriptrunner.util.command.ParsedCommandListener.handleEvent(ParsedCommandListener.java:62)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:448)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:236)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:833)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:119)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:1223)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1401)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:370)

any assistance would be appreciated!

Comments

Post Details

Added on Jan 24 2025
5 comments
141 views