How to resolve the errors encountered when attempting to upgrade Spotfire using the upgrade tool, which may cause the process to fail

How to resolve the errors encountered when attempting to upgrade Spotfire using the upgrade tool, which may cause the process to fail

book

Article ID: KB0070166

calendar_today

Updated On:

Products Versions
Spotfire Server All

Description

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.

Issue/Introduction

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

Resolution

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.

Additional Information

System Requirements of the product Spotfire Server Upgrade tool
Powered by Wolken Software