Activity overview
Latest activity by Obiero
Hi @DanC I think I am beginning to understand the problem. flyway clean command only deletes the flyway_schema_history table leaving other objects untouched hence the object already exists error... / comments
Hi @DanC I think I am beginning to understand the problem. flyway clean command only deletes the flyway_schema_history table leaving other objects untouched hence the object already exists error...
Hi @DanC I am still running into issues with the Drift and Change Report. Why does it try to execute the baseline script, yet it was already been applied? What could I be doing wrong yet I followed your guide step by step? 2024-07-21T09:30:49.8083842Z Dry Run: Database will NOT be modified. The following messages only represent what would happen in a normal Flyway migration run.
2024-07-21T09:30:49.8088821Z =================================================================================================================================
2024-07-21T09:30:49.8236095Z Successfully validated 3 migrations (execution time 00:00.003s)
2024-07-21T09:30:49.8484953Z Current version of schema [dbo]: 002.20240719123640
2024-07-21T09:30:49.8485715Z WARNING: outOfOrder mode is active. Migration of schema [dbo] may not be reproducible.
2024-07-21T09:30:49.8486551Z Schema [dbo] is up to date. No migration necessary.
2024-07-21T09:30:49.9867036Z ERROR: Script B001_20240719130702__baseline.sql failed
2024-07-21T09:30:49.9911726Z A Flyway report has been generated here: C:\agent\_work\11\a\flyway_prd01-158304-Drift-And-Change-Report.html
2024-07-21T09:30:49.9975601Z -----------------------------------------------
2024-07-21T09:30:49.9991081Z SQL State : S0001
2024-07-21T09:30:49.9992585Z Error Code : 2714
2024-07-21T09:30:50.0001870Z Message : There is already an object named 'orders' in the database.
2024-07-21T09:30:50.0007484Z Location : C:\agent\_work\11\s\flyway-01\migrations\B001_20240719130702__baseline.sql (C:\agent\_work\11\s\flyway-01\migrations\B001_20240719130702__baseline.sql)
2024-07-21T09:30:50.0014214Z Line : 17
2024-07-21T09:30:50.0014787Z Statement : Run Flyway with -X option to see the actual statement causing the problem / comments
Hi @DanC I am still running into issues with the Drift and Change Report. Why does it try to execute the baseline script, yet it was already been applied? What could I be doing wrong yet I followed...
Thank you @DanC Quick question: Is the databaseName in this variable group supposed to be the one for Production or for Checking? And isn't the target_database_JDBC supposed to be the full JDBC connection string and not just the database name? [image] / comments
Thank you @DanC Quick question: Is the databaseName in this variable group supposed to be the one for Production or for Checking? And isn't the target_database_JDBC supposed to be the full JDBC con...