Bootstrap creation fails with error "Invalid object name 'SN_VERSION'"

Bootstrap creation fails with error "Invalid object name 'SN_VERSION'"

book

Article ID: KB0082057

calendar_today

Updated On:

Products Versions
Spotfire Server All Supported Versions

Description

When you try to create a bootstrap file using the Spotfire Server configuration tool, it may fail with an error message similar to this example (which is for a case in which Microsoft SQL Server is used for the Spotfire database):

Error connecting to the specified data source: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]Invalid object name 'SN_VERSION'.
 

Environment

All Supported environments

Resolution

1) Make sure you have created the Spotfire database using the appropriate script from the Spotfire Server software bundle.

Examples:

    \TIB_sfire_server_7.12.0_win\scripts\mssql_install\create_databases.bat
    \TIB_sfire_server_7.12.0_win\scripts\oracle_install\create_databases.bat

2) Confirm that you are using the right database for creating the bootstrap file.

3) Make sure the SN_VERSION table does exist in your Spotfire database. 

 

Issue/Introduction

Bootstrap creation fails with error "Invalid object name 'SN_VERSION'"