Error after Spotfire Server upgrade - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'NODE_SERVER_INFO'
Article ID: KB0075040
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 7.6 and above |
Description
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"
----------------------------------------------------------------------------------------------------------------------------------
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"
Issue/Introduction
Spotfire Server fails to start after upgrading with the following error in the logs- com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'NODE_SERVER_INFO'
Environment
All supported operating systems
Resolution
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).
Attachments
Feedback
Yes
No
Powered by
