liquibase.exception.ValidationFailedException

Stephanus Adisuprijanto shared this question 2 months ago
Answered

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 ---

Comments (1)

photo
1

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:

UPDATE databasechangelog SET md5sum = '7:9349c460e673cf61717e8a67185f27e9' WHERE id like 'YFN-9269%'
After running the above, please try to run the upgrade again and let me know how it goes.

Cheers,

Neal

photo
1

Thanks Neal,

The update was good now.


Cheers,

Adi

photo