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.
Resolution
The solution is to use the correct database backup which has all the constraints included.
Issue/Introduction
Spotfire Server does not start up after restoring the Oracle Spotfire Database.