Purpose (problem description)

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

SQL Error: ERROR: relation "<TABLE NAME>" does not exist (Severity 1, Msg No 1).




Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)
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 :
    1. Open Servman of the version before migration.
    2. Select the central schema before analysis and perform a component reinstall
    3. In PGADMIN, refresh the central database
    4. Check that the table has been installed.
  7. 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