Spotfire Server fails to start. ERROR: (com.spotfire.server.ServerInitializationException: Unable to insert a life cycle event).

Spotfire Server fails to start. ERROR: (com.spotfire.server.ServerInitializationException: Unable to insert a life cycle event).

book

Article ID: KB0077827

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

Description:
Unable to browse the Spotfire server URL (Admin Console). Error in the "Server.log" (\\Spotfire_server_install_dir\tomcat\logs).
---------------------------------------------------
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.
----------------------------------------------------

Symptoms:
When trying to open Spotfire server URL, the folowing error in the server.log file (\\Spotfire_server_install_dir\tomcat\logs) is reproted:

--------------------------------------------
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.spotfire.server.ServerInitializationException: Unable to insert a life cycle event
.
.
.
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
-------------------------------------------- 

Cause:
The default language of Spotfire DB user is changed to a language other than ‘US-English’.

Issue/Introduction

Spotfire Server fails to start. ERROR: (com.spotfire.server.ServerInitializationException: Unable to insert a life cycle event).

Resolution

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

Steps:

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.

Additional Information

10.3 Spotfire Server installation manual: https://docs.tibco.com/pub/spotfire_server/10.3.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-DC46EFFA-C512-4DC2-9F93-BE69D1244235-homepage.html