Spotfire Server does not start up after restoring the Oracle Spotfire Database.

Spotfire Server does not start up after restoring the Oracle Spotfire Database.

Environment:

Product: TIBCO Spotfire Server

Version: All

OS: All Supported Operating Systems

--------------------

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.

Resolution:

The solution is to use the correct database backup which has all the constraints included.