Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

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

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

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


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).

Related articles