Update DWH database for PostgreSQL in CSA throws NSA-0132

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When we update the Data Warehouse database details for PostgreSQL in CSA, an error is thrown: NSA-0132: Database link could not be created successfully. Please verify the Database and Data Warehouse connection details.

This happens even after service restart

When running admin db create-db-link the command fails as well

 

STEPS TO REPRODUCE:

1. Restore Clarity and DWH database backups for PostgreSQL
2. Now open CSA for the same Clarity version
3. Enter the details on page Database (Clarity application), Save
4. Now go to page Data Warehouse
5. Enter the details, hit Save

Expected Results:

• To be able to set schema on Data Warehouse page
• The Save action should be successful and create the DBLINK

Actual Results:

• Schema field is missing from Data Warehouse page (not from Database). This can fail the link creation as it uses this field.
• The Save action fails with error: "NSA-0132: Database link could not be created successfully. Please verify the Database and Data Warehouse connection details.".
• The DBLINK has to be created manually by running admin db create-db-link (works automatically upon Save for Oracle and MSSQL)

 

Environment

Release : 15.9.2

Resolution

This is DE60978, fixed in 15.9.3

Additional Information

Note: If you have not restarted the services, please restart the services after adding the schema information, as this is required