We are running 6.10.41 version of Dollar Universe. We had Oracle migration to of the DB to Exadata post which we see that the reporter node not working and failing with below error:
[ERROR] XXX [RestartTimer2] com.orsyp.reppub.server.manager.continuous.ContinuousIntevalExecutionQueue -
com.orsyp.reppub.common.exception.PersistenceException: Database communication error: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Why reporter doesn't show any notification?
How do we fix this error?
Release : 6.X
Component : REPORTER SERVER
The error below in the logs, state that reporter is having an issue while connecting to DB.
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
[ERROR] 01 Nov 2021 01:06:38 [class com.orsyp.reppub.server.manager.continuous.ContinuousIntevalExecutionQueue 2] com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusConsolidatedPMImpl -
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
In case of connectivity failure, reporter will not alerts or notify explicitly, however the status of the same should be validate on UVC -> Administration->Nodes. The reporter will stop reporting or saving data to DB in case of DB connectivity failure.
Resolving Reporter connectivity issue
1: Please validate reporter database settings as express in document. (applicable for all DB types)
2: In case if there is any DB upgrade or server migration please validate connection viability
Oracle:
3: Oracle only: Oracle DB can be connected either via service-name or SID. Please use appropriate configuration based on your DB configuration
4: Post validating above configuration, restart the reporter and validate connectivity to DB.