Unable to save Spotfire server configuration to the Spotfire Server DB (SQL DB).

Unable to save Spotfire server configuration to the Spotfire Server DB (SQL DB).

book

Article ID: KB0081873

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

You may come across below error in Spotfire server logs(server.log) while saving Spotire server configuration to the Spotfire Server DB.
-------------
WARN 2018-02-14T17:36:49,770+0100 config.tool.ConfigApp: Error executing command import-config
com.spotfire.server.config.tool.CommandException: Error importing the new server configuration to the database: Unable to save configuration
    at com.spotfire.server.config.tool.ImportCommand.run(ImportCommand.java:172) ~[server.jar:?]   
    at com.spotfire.server.config.tool.ConfigApp.executeCommand(ConfigApp.java:369) [server.jar:?]
    at com.spotfire.server.config.tool.ConfigApp.access$400(ConfigApp.java:50) [server.jar:?]
    at com.spotfire.server.config.tool.ConfigApp$RunScriptCommand.run(ConfigApp.java:627) [server.jar:?]
    at com.spotfire.server.config.tool.ConfigApp.executeCommand(ConfigApp.java:369) [server.jar:?]
    at com.spotfire.server.config.tool.ConfigApp.main(ConfigApp.java:458) [server.jar:?]
Caused by: com.spotfire.server.config.ConfigurationException: Unable to save configuration
     at com.spotfire.server.config.DatabaseConfigurationProvider.insertConfigurationMSSQL(DatabaseConfigurationProvider.java:463) ~[server.jar:?]
     at com.spotfire.server.config.DatabaseConfigurationProvider.saveConfiguration(DatabaseConfigurationProvider.java:361) ~[server.jar:?]
     at com.spotfire.server.config.DatabaseConfigurationProvider.saveConfiguration(DatabaseConfigurationProvider.java:302) ~[server.jar:?]
     at com.spotfire.server.config.tool.ImportCommand.run(ImportCommand.java:145) ~[server.jar:?]
     ... 5 more

Caused by: java.sql.SQLDataException: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.
-------------

Translation : Converting a varchar data type to a datetime datatype has created a value out of bounds.

 

Issue/Introduction

Unable to save Spotfire server configuration to the Spotfire Server DB (SQL DB).

Environment

- All supported Operating System. - All Supported SQL DB for Spotfire

Resolution

This error generally comes when the Default language of Spotfire DB user (Database user mentioned in the bootstrap.xml file) set to some different language other than "US-English"
To resolve this, option is to perform below steps for the Database user mentioned in the bootstrap.xml file.
Change the Default language of Spotfire DB user to "US-English" using SQL Server Management Studio.

Steps:
- Connect to SQL Server using DB Administrator user account e.g 'SA' account.
- Select the Spotfire DB user and Right click.
- Select properties-> Default language settings.
- Select ”English” from drop-down menu and click OK.
- Restart the Spotfire Server service.