Hi @walid-sabhi-oracle, @danmcghan-Oracle,
you commented on
https://forums.oracle.com/ords/apexds/post/sqlcl-project-fails-to-stage-changes-when-working-inside-a-7170
i am facing a different error, but it is also a git issue.
i set up a project as described in
https://www.thatjeffsmith.com/archive/2025/05/sqlcl-projects-automated-oracle-database-app-deployments/
- except the git setup, as i am using Eclipse
→ /path/to/workspace/KOI/koi_demo/.git/
everything works fine: project init / config / export / stage / release
only the last bit fails: project deploy (and verify)
[ as woraround i successfully ran (to generate the objects in my destination schema):
SQL> @dist/install.sql
]
what do i have to do successfully run project deploy / verify?
---------------
My environment:
SQL> version
Oracle SQLDeveloper Command-Line (SQLcl) version: 25.3.2.0 build: 25.3.2.317.1117
-- project and git branch are correct
SQL> project config -list -name project
+=================================+
| SETTING NAME | VALUE |
+=================================+
| project | koi_demo_project |
+---------------------------------+
SQL> project config -list -name git.defaultBranch
+===========================+
| SETTING NAME | VALUE |
+===========================+
| git.defaultBranch | main |
+---------------------------+
---------------
-- verify fails
SQL> project verify -debug
----- DISPLAY ARGUMENTS -----
GROUP: null
TEST: null
LIST-GROUPS: null
LIST-TESTS: null
COMPARED-BRANCH-NAME:null
DEBUG: true
VERBOSE: false
----- END ARGUMENTS -----
ERROR: An error has occurred processing your request:
org.eclipse.jgit.errors.RepositoryNotFoundException: repository not found: /path/to/workspace/KOI/koi_demo/Verwaltung/lbproject
DEBUG:
java.lang.RuntimeException: org.eclipse.jgit.errors.RepositoryNotFoundException: repository not found: /path/to/workspace/KOI/koi_demo/Verwaltung/lbproject
at oracle.dbtools.extension.project.core.verify.services.stage.StageSourceDiff.doTest(StageSourceDiff.java:127)
at oracle.dbtools.extension.project.core.verify.interfaces.VerifyServiceInterface.executeTest(VerifyServiceInterface.java:68)
at oracle.dbtools.extension.project.core.verify.VerifyEngine.runService(VerifyEngine.java:424)
at oracle.dbtools.extension.project.core.verify.VerifyEngine.runGroup(VerifyEngine.java:555)
at oracle.dbtools.extension.project.core.verify.VerifyEngine.runAllGroups(VerifyEngine.java:577)
at oracle.dbtools.extension.project.commands.verify.VerifyCommand.run(VerifyCommand.java:106)
at oracle.dbtools.extension.project.commands.handler.CommandHandler.VerifyCommand(CommandHandler.java:79)
at oracle.dbtools.extension.project.commands.handler.ProjectCommand.handleEvent(ProjectCommand.java:89)
at oracle.dbtools.raptor.newscriptrunner.util.command.ParsedCommandListener.handleEvent(ParsedCommandListener.java:62)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:454)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:241)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:837)
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:1394)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1637)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:306)
Caused by: org.eclipse.jgit.errors.RepositoryNotFoundException: repository not found: /path/to/workspace/KOI/koi_demo/Verwaltung/lbproject
at org.eclipse.jgit.lib.BaseRepositoryBuilder.build(BaseRepositoryBuilder.java:681)
at org.eclipse.jgit.api.Git.open(Git.java:95)
at org.eclipse.jgit.api.Git.open(Git.java:74)
at oracle.dbtools.extension.project.core.verify.services.stage.StageSourceDiff.getSrcModifiedFiles(StageSourceDiff.java:342)
at oracle.dbtools.extension.project.core.verify.services.stage.StageSourceDiff.doTest(StageSourceDiff.java:69)
... 17 more
---------------
-- deploy fails
SQL> project deploy -file artifact/koi_demo_project-1.0.0.zip -verbose -debug
----- DISPLAY ARGUMENTS -----
REQUIRED FILE: artifact/koi_demo_project-1.0.0.zip
LOG-PATH: null
DEBUG: true
VERBOSE: true
----- END ARGUMENTS -----
Check database connection...
Extract the file name: koi_demo_project-1.0.0
Artifact decompression in progress...
Artifact decompressed: /tmp/9eba72f8-56eb-427c-8206-e220b754914e16723062037920153037
Starting the migration...
ERROR: An error has occurred processing your request:
Input length = 1
java.nio.charset.MalformedInputException: Input length = 1
at java.base/java.nio.charset.CoderResult.throwException(CoderResult.java:279)
at java.base/sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:334)
at java.base/sun.nio.cs.StreamDecoder.read(StreamDecoder.java:186)
at java.base/java.io.InputStreamReader.read(InputStreamReader.java:183)
at java.base/java.io.BufferedReader.fill(BufferedReader.java:166)
at java.base/java.io.BufferedReader.readLine(BufferedReader.java:333)
at java.base/java.io.BufferedReader.readLine(BufferedReader.java:400)
at java.base/java.nio.file.Files.readAllLines(Files.java:3088)
at java.base/java.nio.file.Files.readAllLines(Files.java:3122)
at oracle.dbtools.extension.project.commands.deploy.DeployCommand.run(DeployCommand.java:113)
at oracle.dbtools.extension.project.commands.handler.CommandHandler.DeployCommand(CommandHandler.java:149)
at oracle.dbtools.extension.project.commands.handler.ProjectCommand.handleEvent(ProjectCommand.java:93)
at oracle.dbtools.raptor.newscriptrunner.util.command.ParsedCommandListener.handleEvent(ParsedCommandListener.java:62)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:454)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:241)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:837)
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:1394)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1637)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:306)