NSA-0132: Database link could not be created successfully.

Products

• Clarity PPM On Premise

Issue/Introduction

Unable to create Database link from CSA and getting an error NSA-0132: Database link could not be created successfully. Please verify the Database and Data Warehouse connection details.

Steps to Reproduce: 

Pre-requisite: This is only reproduced when using JDBC URL as connection example: jdbc:oracle:thin:@//<hostname>:<port>/<service_name>
 

1. Set up Clarity and Data warehouse schema in the database using the documentation
2. Set up Clarity application servers and configure all the necessary parameters in CSA
3. Under Data warehouse menu fill up the database details and click on save 

Expected Results: Database link should be created 

Actual Results: Database link is not created and error "NSA-0132: Database link could not be created successfully" is seen 

Environment

Clarity 16.4.0 

Cause

DE180554

Resolution

Fixed in

• Clarity 16.4.2 
  
  

Workaround:

• Create DB Link directly at the database using the information provided in documentation
• After filling the correct database information in the CSA for Clarity and Data warehouse schema, navigate to CLARITY_HOME\Bin directory and run the command admin db create-db-link and it will create the DB link