liquibase.exception.ValidationFailedException
Hi there,
We are facing an exception of liquibase.exception.ValidationFailedException during update from 9.2 to 9.3 using yellowfin-9.3.1-20201022-update.jar
These are the detailed output of the update:
--- Installing ---
Backing up webapp ................................................... [OK]
Updating libraries .................................................. [OK]
Extracting update ................................................... [OK]
Extracting update ................................................... [OK]
Updating Yellowfin Schema ........................................... [OK]
Updating reference data ............................................. [OK]
Updating Yellowfin Schema ........................................... [OK]
Converting Report Content ........................................... [OK]
Converting Report Content
Installation Error
An error occurred during installation:
liquibase.exception.ValidationFailedException: Validation Failed:
1 change sets check sum
com/hof/util/liquibase/db-runalways.xml::YFN-9269 Update schema version and schema release in Configuration::cesar was: 7:9349c460e673cf61717e8a67185f27e9 but is now: 8:0802a3d66aa5b5d59aeaab5b49d56dec
liquibase.exception.ValidationFailedException: Validation Failed:
1 change sets check sum
com/hof/util/liquibase/db-runalways.xml::YFN-9269 Update schema version and schema release in Configuration::cesar was: 7:9349c460e673cf61717e8a67185f27e9 but is now: 8:0802a3d66aa5b5d59aeaab5b49d56dec
at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:276)
at liquibase.Liquibase.update(Liquibase.java:198)
at liquibase.Liquibase.update(Liquibase.java:179)
at com.hof.util.LiquibaseRunner.runLiquibaseUpdate(LiquibaseRunner.java:37)
at com.hof.patch.process.job.LoggedCustomUpdateJob.run(LoggedCustomUpdateJob.java:33)
at com.hof.patch.PatchInstaller.runInstallJobs(PatchInstaller.java:478)
at com.hof.patch.cmd.CmdInstaller.install(CmdInstaller.java:192)
at com.hof.patch.cmd.CmdInstaller.main(CmdInstaller.java:36)
at com.hof.patch.PatchInstaller.runCmd(PatchInstaller.java:783)
at com.hof.patch.PatchInstaller.runInstaller(PatchInstaller.java:747)
at com.hof.patch.PatchInstaller.main(PatchInstaller.java:817)
[FAILED]
--- Yellowfin Patch Installation Failed ---
Hi,
Thank you for reaching out to us on this. I just want to check if you received my reply earlier today to try and address this issue? If not, I am pasting it below, please let me know how you go with this:
I have tried to replicate your issue without luck, but I have a possible solution for you which will involve running a query directly against your Yellowfin Configuration database prior to re-trying the upgrade. When running any queries directly against the Yellowfin Configuration Database it's possible to cause irrevocable data loss. This process isn't directly supported nor recommended unless otherwise advised to do so. Before running any queries against your Yellowfin Configuration Database, please make sure you have full, up-to-date backups of both your Yellowfin Configuration Database and your Yellowfin Installation folder. This way, if something goes wrong you can revert back to your current state.
With that being said, please run the following query against your Yellowfin Configuration database:
After running the above, please try to run the upgrade again and let me know how it goes.Cheers,
Neal
Hi,
Thank you for reaching out to us on this. I just want to check if you received my reply earlier today to try and address this issue? If not, I am pasting it below, please let me know how you go with this:
I have tried to replicate your issue without luck, but I have a possible solution for you which will involve running a query directly against your Yellowfin Configuration database prior to re-trying the upgrade. When running any queries directly against the Yellowfin Configuration Database it's possible to cause irrevocable data loss. This process isn't directly supported nor recommended unless otherwise advised to do so. Before running any queries against your Yellowfin Configuration Database, please make sure you have full, up-to-date backups of both your Yellowfin Configuration Database and your Yellowfin Installation folder. This way, if something goes wrong you can revert back to your current state.
With that being said, please run the following query against your Yellowfin Configuration database:
After running the above, please try to run the upgrade again and let me know how it goes.Cheers,
Neal
Replies have been locked on this page!