Cannot connect to server and error in server.log La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites. The conversion of a varchar data type to a datetime data type resulted in an out-of-range value"

Cannot connect to server and error in server.log La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites. The conversion of a varchar data type to a datetime data type resulted in an out-of-range value"

Spotfire Server is installed and service is running but trying to go to <hostname>:port/spotfire gives a 404 error and in server.log the error is shown:

===========================================
web.context.ContextLoader: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lifecycleManager' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is com.spotfire.server.ServerInitializationException: Unable to insert a life cycle event

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 
La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
===========================================
 

The locale for the Spotfire Server OS and the default language for Spotfire Database has to be set to English, United States.

• For Windows OS, go to Control Panel > Clock, Language, and Region and set both language and region to English, United States

• Change the Default language of Spotfire DB user to "US-English" using SQL Server Management Studio.

  1).  Connect to SQL Server using ‘SA’ account(DB Administrator user).
  2).  Select the Spotfire DB user and Right click.
  4).  Select properties-> Default language settings.
  5).  Select ‘”English” from drop-down menu and click OK.
  6).  Restart the Spotfire Server service.