Error message in the CSA When Clicking Save: Unable to persist configuration properties to database (Postgres)

Products

• Clarity PPM On Premise

Issue/Introduction

There is an error message that appears as a red banner in the CSA > Database page when clicking the 'Save' button.

The error is: Unable to persist configuration properties to database. Likely cause is database properties are not yet set or misconfigured
Postgres database is being used.

Steps To Reproduce:

1. Go to CSA > Database page
Enter correct database properties.

2. Click Save in CSA > Database

Actual: Database shows 'Available' however the red banner error displays:
Unable to persist configuration properties to database. Likely cause is database properties are not yet set or misconfigured

Expected: There should not be the red banner error.

Cause

The misconfiguration is caused by the database privileges/reference.

Resolution

Check the following:

1. Make sure the database/schema is being referenced properly.

Run command:
postgres=#\d

NOTE: Ensure schema name is renamed from clarity and ppm_dwh to the desired database/schema name, e.g.

postgres=#
ALTER DATABASE clarity RENAME TO fill_this ;

2. Run the command from the Clarity server:
admin db create-db-link -Dtype=app -Dsysusername=fill_this1 -Dsyspassword=fill_this2

3. If error encountered:
org.postgresql.util.PSQLException: ERROR: permission denied to create extension "dblink"
  Hint: Must be superuser to create this extension.

Have DBA fix the above error/recreate the foreign data wrapper with the following commands:
create extension postgres_fdw;
create extension dblink;

Additional Information

Reference:Configure a Database with PostgreSQL