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 |
Observed on RDBMS
RDBMS | Yes/No |
---|---|
CSS |
Step by Step scenario
Use CUT to update the databases to a more recent CAST version.
Action Plan
- Open the Servman log file
- 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
- Open PGADMIN and connect to the Central Schema before migration (restore the backup before migration).
- Expand the list of the tables
- Check if the table (in the example it is wk_tcc_correct_df) exists.
- If it does not exist :
- Open Servman of the version before migration.
- Select the central schema before analysis and perform a component reinstall
- In PGADMIN, refresh the central database
- Check that the table has been installed.
- 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