After running the upgrade tool to upgrade Spotfire, the following errors may occur, causing the upgrade to fail.
 

ERROR 2024-07-11T11:45:39,825 tools.upgrade.UpgradeManager: Unable to upgrade database com.spotfire.server.tools.upgrade.DatabaseUpgradeException: Error while upgrading database: Error while upgrading database: ERROR: syntax error at or near "function" Position: 147

 

Error while upgrading database: ERROR: cannot drop column content_size of table lib_current_items beca use other objects depend on it   Detail: view scheduled_job_view depends on column content_size of table lib_current_items   Hint: Use DROP ... CASCADE to drop the dependent objects too. Caused by: org.postgresql.util.PSQLException: ERROR: cannot drop column content_size of table lib_current_items because other objects depend on it   Detail: view scheduled_job_view depends on column content_size of table lib_current_items   Hint: Use DROP ... CASCADE to drop the dependent objects too.

ERROR 2024-07-11T11:45:39,825 tools.upgrade.UpgradeManager: Unable to upgrade database com.spotfire.server.tools.upgrade.DatabaseUpgradeException: Error while upgrading database: Error while upgrading database: ERROR: syntax error at or near "function" Position: 147

The above error occurs if the database version you are using is not supported in the upgraded version. To resolve this issue, please confirm that the database version you are using is compatible with the version you are upgrading to.

And for the below error

Error while upgrading database: ERROR: cannot drop column content_size of table lib_current_items because
other objects depend on it
  Detail: view scheduled_job_view depends on column content_size of table lib_current_items

This error occurs if modifications were made to the Spotfire meta-database in the earlier version, such as adding views or columns. Since these views or columns will be unknown to the Spotfire upgrade tool, it will fail with the above error. To resolve this issue, please remove these added columns or views before upgrading.

This article outlines the process for resolving the errors that may occur while running the Spotfire upgrade using the upgrade tool.

System Requirements of the product

• https://docs.tibco.com/pub/spotfire/general/sr/sr/topics/system_requirements_for_spotfire_products.html

Spotfire Server Upgrade tool

• https://docs.tibco.com/pub/spotfire_server/14.4.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/run_the_spotfire_server_upgrade_tool.html