Product: TIBCO Spotfire®
Unable to save Spotfire server configuration to the Spotfire Server DB (SQL DB).
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.
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.
Comments
0 comments
Article is closed for comments.