I'm not sure what I'm doing wrong in my workflow as when I download my artifact zip file and try to install it I get:
SQL> project deploy -file ./doctor-appointments-1.2.zip
ERROR: An error has occurred processing your request:
Your install.sql file does not exist
Backgroud:
If I add the verbose and debug options I can see where the zip file is unzipped to and the file does indeed exist:
SQL> project deploy -file ./doctor-appointments-1.2.zip -verbose -debug
----- DISPLAY ARGUMENTS -----
REQUIRED FILE: ./doctor-appointments-1.2.zip
DEBUG: true
VERBOSE: true
----- END ARGUMENTS -----
Check database connection...
Extract the file name: doctor-appointments-1.2
Artifact decompression in progress...
Artifact decompressed: /tmp/ee4437e6-90c8-4eb6-9070-16732c23cd872486501829950261980
ERROR: An error has occurred processing your request:
Your install.sql file does not exist
oracle.dbtools.extension.project.core.exceptions.ProjectDeployException: Your install.sql file does not exist
at oracle.dbtools.extension.project.commands.deploy.DeployCommand.run(DeployCommand.java:121)
at oracle.dbtools.extension.project.commands.handler.CommandHandler.DeployCommand(CommandHandler.java:149)
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:448)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:241)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:835)
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:1413)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1637)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:403)
SQL> !find /tmp/ee4437e6-90c8-4eb6-9070-16732c23cd872486501829950261980 | grep install.sql
/tmp/ee4437e6-90c8-4eb6-9070-16732c23cd872486501829950261980/doctor-appointments-1.2/dist/install.sql
And further, if I run that unzipped install file manually, then the installation does commence (full disclosure: it later fails due to a custom script error but that's unrelated to this initial problem):
SQL> @/tmp/ee4437e6-90c8-4eb6-9070-16732c23cd872486501829950261980/doctor-appointments-1.2/dist/install.sql
Installing/updating schemas
--Starting Liquibase at 2025-07-06T09:36:24.120579 using Java 11.0.27 (version 4.30.0 #0 built at 2025-04-01 10:24+0000)
Running Changeset: base-release/appointments/sequences/appoint_seq.sql::1751725641386::APPOINTMENTS
Sequence APPOINTMENTS.APPOINT_SEQ created.
Running Changeset: base-release/appointments/sequences/patient_seq.sql::1751725641406::APPOINTMENTS
Sequence APPOINTMENTS.PATIENT_SEQ created.
Running Changeset: base-release/appointments/tables/appointment.sql::1751725641438::APPOINTMENTS
Table APPOINTMENTS.APPOINTMENT created.
...
So I'm not sure what I'm doing wrong to cause the Your install.sql file does not exist error when it does indeed exist in the unzipped location? My guess might be that it's because I have a hyphon in my project name and that's reserved as a delimeter between the project name and the release version but that's just a guess?