Server Manager - Update Database - Fatal Error - Central base fails to update - SQL Error relation table_name does not exsist

Purpose (problem description)

This page troubleshoot the below error while updating the central database with the Server Manager:

SQL Error: ERROR: relation “

” does not exist (Severity 1, Msg No 1).

Observed in CAST AIP

ReleaseYes/No
8.3.x✅

Observed on RDBMS

RDBMSYes/No
CSS✅

Step by Step scenario

Use CUT to update the databases to a more recent CAST version.

Action Plan

  1. Open the Servman log file

  2. Check for the name of the table that is in the SQL Error message. For the above example the name of the table is : wk_tcc_correct_df

  3. Open PGADMIN and connect to the Central Schema before migration (restore the backup before migration).

  4. Expand the list of the tables

  5. Check if the table (in the example it is wk_tcc_correct_df) exists.

  6. If it does not exist :

  7. Open Servman of the version before migration.

  8. Select the central schema before analysis and perform a component reinstall

  9. In PGADMIN, refresh the central database

  10. Check that the table has been installed.

  11. If the table exists  contact CAST Technical Support. and provide the following Relevant input in order to reproduce the issue

Notes/comments

Ticket #  9512

Related Pages