The Reporter server cannot connect to its target database

book

Article ID: 85877

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

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.

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.

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

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