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.
When running admin db create-db-link the command fails as well
STEPS TO REPRODUCE:
- Restore Clarity and DWH database backups for PostgreSQL
- Now open CSA for the same Clarity version
- Enter the details on page Database (Clarity application), Save
- Now go to page Data Warehouse
- 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)