*Purpose
This page will help you to troubleshoot the Fatal Error message "Error while executing procedure - relation <table name> does not exist" which you may face while running the Snapshot.
*Observed in CAST AIP
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
*Observed on RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS3 | |
| CSS2 | |
Step by Step Scenario
- Run analysis
- Run snapshot
- Observed that snapshot failed with error- "Error while executing procedure - relation <table name> does not exist"
Action Plan
- In CAST-MS log file, identify the table or the view that is involved in the error message.
The table name follows the error : "ERROR: relation "<Table / view Name>" does not exist".
In the above example the view name is: cdv_javadoc. - To create the view open server manager and perform component reinstall on KB.
- But it is noticed that even after performing the component reinstall view is not getting created in KB. In that case please refer - Server Manager - Component Reinstall - View is not getting created after component reinstall
Then in CAST-MS, take a snapshot by skipping analysis.
If the above points do not help you, contact Cast Technical Support and provide the following Relevant Input to reproduce the issue.
Notes/Comments
Related Pages
