The database schema version '148' does not match the required '151'.
I am trying to change the spotfire database, i have changed it through configuration tool, while saving i am getting "The database schema version '148' does not match the required '151'." error.
What could be the resolution for this?
Do I need to run the create-database.bat script? If so will it overwrite the existing data?
Please help to resolve this issue?
Thanks in advance!
You are having this issue because the Spotfire database you are trying to use is not designed for the version of Spotfire you are running. For instance, you are currently running Spotfire 10.0 but the database was created and designed for Spotfire 7.14.
To update your database, you need to run the Spotfire upgrade tool. To do so, you have to uninstall and re-install the Spotfire Server service (not as bad as it sounds, only takes a couple of minutes). Run the setup-win64 application file for your new version (which you download from TIBCO edelivery site). Run once to uninstall and run it again to install service.
Once the installation is completed, make sure to select "Launch the upgrade tool" before clicking "Finish".
When prompted, enter the connection information for the database you wish to use. Complete the upgrade process, and this will update your database to run on your new version.
I hope this helps!
You need to run the oracle scripts according to the spotfire version which you installed. It is wise you always go for oracle install folder scripts that comes along with spotfire server downloads. Please check the sn version in the DB and it should match with populate db script.sh sn version.
You need to run the database patch that is a part of the server hotfix.
In the server hotfix download, you should also have a folder named "database" when you extract its content.
In there, there are database schema patches as well and an included document on applying them. Please do this, and start the server after this.
This error generally comes when you have not applied Spotfire database hotfix mentioned in Spotfire server hotfix instructions document.
- Have you applied Spotfire server hotfix?
- If yes, have you applied Spotfire database hotfix mentioned in Spotfire server hotfix instructions document? If not then please apply the DB patch as mentioned in Spotfire server hotfix instructions document and then apply Spotfire server hotfix if not applied before.
Thanks! I did not applay any hot fix, is it mandatory to apply hotfix, i just wanted to change the database of the existing spotfire server. I just changed in configuration tool (bootstrap), do i need to change anywhere else?