Purpose (problem description)
This page will help you to resolve the issue when the installation of a CSS (CAST Storage Service) database may fail with the following errors:
SQL Error: ERROR: relation "test_mngt.cms_portf_system" does not exist.
SQL Error: LINE 3: from test_mngt.CMS_PORTF_System s .
SQL Error: ^ (Severity 1, Msg No 1).
SQL Error: ERROR: current transaction is aborted, commands ignored until end of transaction block (Severity 1, Msg No 1).
Observed in CAST Version, CAST Extension Version, CAST Component Version
Release | Yes/No |
|---|---|
| 8.3 |  |
Observed in RDBMS
RDBMS | Yes/No |
|---|---|
| CSS | |
Step by Step scenario
- Use Server Manager to try to install schema in a given CSS databases
Action Plan
Perform the below actions
- Check the values used in the connection profile, while paying particular attention to the field 'Server name/IP:port'. This field should contain ONLY the name or IP and the port. The error above was caused in one case where a user put the following for this field:
localhost/postgres:2282 (instead of just localhost:2282) - If you do not find the information you are looking for or solution for your problem, in this page, contact CAST Technical Support and provide the relevant input to investigate your problem and to reproduce the issue.
Notes/comments
Ticket # 16369
Related Pages
