ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Health Report - slow performance and timeout with error "ORA-12154" due to DBLINK setup

book

Article ID: 104061

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When going to Administration - Health Report in the Clarity UI, the page is spinning and spinning and eventually times out with ORA-12154: TNS:could not resolve the connect identifier specified

Error in the app-ca.log:

ERROR 2018-06-28 13:08:22,695 [https-jsse-nio-443-exec-395] providers.DWHDBHealthReportProvider (clarity:admin:13381417__72DFC4BC-7A29-434D-B5EF-DC01EAFB7CEB:nmc.healthReport) Error validating dblink :PPMDBLINK
com.niku.union.persistence.PersistenceException:
SQL error code: 12154
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
 
Executed:
SELECT count(1) dblinkvalid from [email protected]

Cause

There is a problem with your DB LINK. Resolving the link makes the application retry the connection many times which could lead to a timeout.

Environment

Release: Any

Resolution

Ensure your DBLINK is correctly set up:

  1. Log in to your CSA and
  2. Go to Server - Data Warehouse and hit Save on the page twice.
  3. Once done, see if the link works, run this query on your DWH database with query analyzer:

    SELECT count(1) FROM [email protected]
  4. If it still does not work, check with your DBA to configure and troubleshoot the link as per the instructions in our documentation.