Product: TIBCO Spotfire®
Spotfire Server fails to start after import and throws error: "TIBCO Spotfire Server will not be started. Database consistency verification failed. Errors found: Missing constraint for table LIB_DATA"
After successful export from one environment (such as Production) and import to another environment (such as Test) of the Spotfire database, the Spotfire Server service does not start and shows the following error:
Caused by: com.spotfire.server.ServerInitializationException: TIBCO Spotfire Server will not be started. Database consistency verification failed. Errors found: Missing constraint for table LIB_DATA: OracleDatabaseConstraint[ name: FK_LIB_DATA_ITEM_ID type: R searchCondition: null ]
????This is probably due to that something has changed in the database and a constraint is missing. It's quite commonly seen when trying to move/copy a Spotfire database on Oracle from one instance to another. It is caused by not all constraints being moved/copied which leads to problems.
This usually gets resolved by doing a new export and import.
It is, of course, always a good idea to double-check with the DBA admin to make sure the move/copy of the database included all the content of the source database.