7.4 Upgrade Error

Ryan Carrie shared this problem 1 year ago
Resolved

I get the following error when upgrading 7.4:


com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '74yellowfin.EtlStepMetadataField' doesn't exist

Comments (1)

photo
1

You have two options:

1. Roll back your upgrade using this process.


2. As a work around to get the upgrade installer to complete, you can manually rename a table in your Yellowfin Configuration Database.

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.

The following will rename the table so the update installer will pick it up:

ALTER TABLE ETLStepMetadataField RENAME EtlStepMetadataField;
Now re-run the installer and test Yellowfin!

If you have issues with either of these solutions, please don't hesitate to open a ticket!

Thanks,

Ryan