How to migrate to a different server and upgrade spotfire version

[Natsuki Nakagawa]

Hi

I'm trying upgrade spotfire from 7.10 to 10.3. In addition, I also want to doserver migration.

Here are the steps I did.

Oracle database export. (old server)

Oracle database import.(New Server)

Spotfire 10.3.1 install.(New Server))

Then I try to do upgrade tool, but It doesn't work.

What should I do next Is the prcedure I did wrong

 

Please tell me how to upgrade and migrate Spotfire.

[David Boot-Olazabal]

Hi nn,

What error messages are displayed Is that maybe that "no sqljdbc_auth in java.library.path" is available

In that case, you can copy this specific dll file from the 7.10 folder (/tomcat/bin) to the one for Spotfire 10.3.1 (/jdk/jre/bin). And then you should be able to continue the upgrade.

An other workaround, we did, was adding this file to a C:/Java folder and added it manually to the Path in environment variables.

Let me know if this is the issue you're facing or that it is somehing else you encounter.

 

Kind regards,

David Boot-Olazabal

[Natsuki Nakagawa]

Thank you for your advice.

 

After installed the Spotfire 10.3.1 (setup-win64.exe) ,

 

I double-clicked "upgradetool.bat ".

 

But the program remains stopped all the time after entering the DB connection information.

 

Are there any steps missing

 

 [/code]

[David Boot-Olazabal]

Hi nn,

 

Did you start the upgradetool seperately from the Spotfire installation I normally choose the Run the upgradetool from the last window during the installation of Spotfire. Nevertheless, it might be that you need to start the upgradetool.bat as an administrator.

If that doesn't make a difference, try starting the configuration tool first, to check if the database is properly connected. Otherwise, you might have to fix that first before running the upgrade.

Kind regards,

David Boot-Olazabal

[Natsuki Nakagawa]

I run the upgradetool during the installation of Spotfire. The result is the same...Should I need to set new bootstrap.xml

I am trying  to start the configuration tool, I getted

"The database schema version 'xx' does not match  the required 'xxx" "error.

[David Boot-Olazabal]

Hi nn,

 

 

 

Ok, I see. You can start indeed by creating a new bootstrap. You may also need to start the configuration tool via the run as administrator option. We had problems in the past saving the bootstrap afterwards...

 

Let me know if that solves the issue of the error message when opening the config tool.

 

 

 

Kind regards,

 

David

 

 

[Natsuki Nakagawa]

Hi David,

 

Thank you.

 

Could you tell me a simple migration method for Spotfire Server

 

I'm going to upgrade Spotfire Server after migrating it to a new server.

 

I'm using Oracle.I also applied HotFix.

 

 

[David Boot-Olazabal]

Hi nn,

 

These are the steps I normally take:

 

- install new Spotfire software on Spotfire server(s) (in case of existing older version, stop the services first);

 

- if it concerns an upgrade, launch the Upgrade Tool when the installation has succesfully finished;

 

- copy the configuration from an older version or don't copy the configuration if not applicable;

 

- connect to the database with the user that created the database in the first place. So be sure to have the correct user account (at least this is what I've done on SQL Server, I assume Oracle works the same way);

 

- The upgrade should start , executing scripts and finish succesfully.

 

In case you have more than one Spotfire server (in a cluster), you need to install the software on all the servers, but you ony have to run the upgrade once.

 

Once the upgrade has finished, you then can proceed to load the nodemanager packages and client packages and deploy them on the server. Save the deployment area and update your services (webplayer, automation services).

 

Once done, I always restart all servers to be sure everything works fine and no installation files are pending.

 

This has always worked out for me. 

 

Kind regards,

 

David Boot-Olazabal

[Natsuki Nakagawa]

This problem has beenresolved.

I used Spotfire 10.3.4)

Thank you for your advice.