The Reporter server cannot connect to its target database

Document ID : KB000085877
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
The following error message would appear from Univiewer Console or server.log:
###################
ORA-12514; TSN: Listener does not currently of service requested in connect descriptor.
###################

Patch level detected:Reporter 4.0.00
Product Version: Dollar.Universe 6.0.0

Description :The Reporter server cannot connect to its target database. It could be during extraction or reporter generation or validating DB connection from Univiewer Console.
Environment:
OS: Linux
OS Version: Linux casplda02 2.6.18-194.26.1.el5 #1 SMP Tue Nov 9 12:54:20 EST 2010 x86_64 x86_64 x86_64 GNU/Linux
Cause:
Cause type:
Defect
Root Cause: The value of "DB Instance ID" in the Database Settings of the NodeSettings of the Reporter is incorrect. The issue would appear if you leave the parameter "DB Name (MSSQL only)" empty instead putting "null" and restart the Reporter server. The Nodesettings for reporter node database configuration were not handled properly. The DB name was showing even if the Oracle db type was selected.
Resolution:
Make sure to put the word "null" into the parameter "DB Name (MSSQL only)" in the Database Settings of the NodeSettings of the Reporter .

Fix Status: Released

Fix Version(s):
Component: Reporter
Version: Dollar.Universe 6.0.0
Additional Information:
Workaround :
N/A