Product: TIBCO Spotfire®
Error after Spotfire Server upgrade - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'NODE_SERVER_INFO'
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).
Comments
0 comments
Article is closed for comments.