Flyway Undo function not working for jenkins pipeline

Question

I am using Flyway Enterprise Edition (unlimited schemas) 6.1.0.

I am trying to undo flyway migration to a certain version. Created a config file and provided target flyway.target=90000. I am using mvn command to run the migration as shown below.

mvn -Dflyway.configFiles=database-flyway-dbscripts-undo-db22.conf -e -Dflyway.outOfOrder=true -Dflyway.ignoreMissingMigrations=true flyway:undo

The undo works when pointing to my db installed on my PC but does not work on the jenkins CB pipeline or when i point it to a remote DB from my PC.

I get

--- flyway-maven-plugin:6.1.0:undo (default-cli) @ ap-sales-database --- [INFO] Flyway Enterprise Edition (unlimited schemas) 6.1.0 by Redgate licensed to XXXX until XXXXX [INFO] Database: jdbc:oracle:thin:@salesdb_19c (Oracle 19.0) [INFO] Schema ""CB22_SALES"" has no migrations to undo.

But the CB22_SALES has migrations that need to be undone.

Maven is configured

<plugins>
    <plugin>
    <groupId>org.flywaydb.enterprise</groupId>
    <artifactId>flyway-maven-plugin</artifactId>
    <version>6.1.0</version>
    </plugin>
</plugins>

Am I missing something. Please help.

Flyway Undo function not working for jenkins pipeline

0 Answers0