Server Manager - Install Database - Error - relation xxx cms_portf_system does not exist

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

ReleaseYes/No
8.3✅

Observed in RDBMS

RDBMSYes/No
CSS✅

Step by Step scenario

  1. Use Server Manager to try to install schema in a given CSS databases

Action Plan

Perform the below actions

  1. 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)
  2. 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