Error after Spotfire Server upgrade - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'NODE_SERVER_INFO'

Created
October 08, 2021 23:14

Date Posted: 2020-07-01
Product: TIBCO Spotfire®

Problem:

Solution:

After upgrading Spotfire Server from version 6.5 or later to a newer version on SQL Server database, Spotfire server fails to start and the following error is logged:
----------------------------------------------------------------------------------------------------------------------------------
server.lifecycle.SpotfireApplicationInitializer: Unable to retrieve the multipart configuration
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'NODE_SERVER_INFO'
----------------------------------------------------------------------------------------------------------------------------------

This is caused if the new tables and views created in the Spotfire Database at the time of upgrade has a different Schema Owner.

Example: It is updated to "domainname/username.tablename" instead of "dbo.tablename" Involve a DBA to update the Schema owner to "dbo" or same as other Spotfire Database tables. Refer below screenshot (Filename: Schema Owner dbo.PNG).