Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Spotfire Server does not start up after restoring the Oracle Spotfire Database.
Solution:
Description:
Spotfire Server does not start up after restoring the Oracle Spotfire Database.
Symptoms:
When trying to connect to the restored database the following error is returned in the logs and the Server fails to startup.
=============
ERROR [*Initialization*] 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]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.spotfire.server.LifecycleManager]: Constructor threw exception; nested exception is com.spotfire.server.ServerInitializationException: TIBCO Spotfire Server will not be started. Database consistency verification failed. Errors found:
Missing constraint for table LIB_WORDS: OracleDatabaseConstraint[
name: FK_LIB_WORDS_LIB_ITEM
type: R
searchCondition: null
==============
Cause:
The back up scripts of the database did not include all the required database constraints. The solution is to use the correct database backup which has all the constraints included.