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:%sessionid%: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 dual@PPMDBLINK
Release: Any
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.
Ensure your DBLINK is correctly set up:
SELECT count(1) FROM SRM_RESOURCES@PPMDBLINK