Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

SQLcl 25.4.1 project stage StringIndexOutOfBoundsException

Arvydas K19 hours ago

Hello,

trying to stage project files using project stage -bn sqlcl_setup -debug -verbose produces error:

Updated change:dist\releases\next\changes\sqlcl_export\stage.changelog.xml 
ERROR: An error has occurred processing your request: 
Range [30, -1) out of bounds for length 35 
java.lang.StringIndexOutOfBoundsException: Range [30, -1) out of bounds for length 35 
at java.base/jdk.internal.util.Preconditions$1.apply(Preconditions.java:55) 
at java.base/jdk.internal.util.Preconditions$1.apply(Preconditions.java:52) 
at java.base/jdk.internal.util.Preconditions$4.apply(Preconditions.java:213) 
at java.base/jdk.internal.util.Preconditions$4.apply(Preconditions.java:210) 
at java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:98) 
at java.base/jdk.internal.util.Preconditions.outOfBoundsCheckFromToIndex(Preconditions.java:112) 
at java.base/jdk.internal.util.Preconditions.checkFromToIndex(Preconditions.java:349) 
at java.base/java.lang.String.checkBoundsBeginEnd(String.java:4865) 
at java.base/java.lang.String.substring(String.java:2834) 
at oracle.dbtools.extension.project.commands.export.DbObj.order(DbObj.java:109) 
at oracle.dbtools.extension.project.commands.export.DbObj.order(DbObj.java:71) 
at oracle.dbtools.extension.project.commands.stage.utils.interfaces.AbstractChangeLogSorter.sort(AbstractChangeLogSorter.java:40) 
at oracle.dbtools.extension.project.commands.stage.utils.StageUtils.saveAllChangeLogs(StageUtils.java:568) 
at oracle.dbtools.extension.project.commands.stage.utils.StageUtils.stageStartProcessing(StageUtils.java:1318) 
at oracle.dbtools.extension.project.commands.stage.StageCommand.run(StageCommand.java:113) 
at oracle.dbtools.extension.project.commands.handler.CommandHandler.StageCommand(CommandHandler.java:59) 
at oracle.dbtools.extension.project.commands.handler.ProjectCommand.handleEvent(ProjectCommand.java:88) 
at oracle.dbtools.raptor.newscriptrunner.util.command.ParsedCommandListener.handleEvent(ParsedCommandListener.java:64) 
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:474) 
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:241) 
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:838) 
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:124) 
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:1437) 
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1680) 
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:331)

No log file is available, no other errors were seen.
/src contains 729 files.
After error, stage.changelog.xml does not contain any <include … elements.

Any suggestions on what might be causing this or how to debug this?

Also, possible typo in another error message, when staging files while disconnected:
ERROR: Error running SQL Query using current **connexion.**

Regards,
Arvydas

Comments
Post Details
Added 19 hours ago
0 comments
16 views