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.