Summary
Error
The user receives the following error message when trying to launch the reporting menu for iSPI Performance for Metrics from the NNMi Console after selecting Actions then Reporting - Report Menu:
Error: Unable to connect to the Network Performance Server database. Error message is (java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect).Check the database status using the statusDB.ovpl command.
The initial verification of the problem appears obvious as the error message states to make sure the database is running by using the statusDB.ovpl command.
Upon verification using the suggested script below, everything is in a running state:
On Windows: %NPSInstallDir%\NNMPerformanceSPI\bin
On Unix: /opt/OV/NNMPerformanceSPI/bin
# %NPSInstallDir%\NNMPerformanceSPI\bin\statusDB.ovpl
HP NNM iSPI Performance Database and DB SQL Rewrite Proxy processes are running.# %NPSInstallDir%\NNMPerformanceSPI\bin\statusAll.ovpl
NNM iSPI Performance BIContentStore is running
NNM iSPI Performance BIServer is running
HP NNM iSPI Performance BI Service is running.
HP NNM iSPI Performance Database is running.
HP NNM iSPI Performance ETL Service is running.HP NNM iSPI Performance Services all running OK
However, there is a different error message when stopping and restarting all the NPS processes. The following pop-up message is presented:
Server failed to start: Cannot access "d:\PROGRA~1\HP\HPBTOS~1\Data\NNMPerformanceSPI\database\perfspiDEMO.db"file does not exist.
The %NPSDataDir%\NNMPerformanceSPI\logs\perfspiUI.log file contains the following error message:
FATAL D:\Program Files\HP\HP BTO Software\Application\NNMPerformanceSPI\lib\perllibs\lib/perfspi.pm[1253] Utility.startALL Failed running: "D:/Program Files/HP/HP BTO Software/Application/nonOV/sybaseiq/IQ-15_2/bin64/start_iq" @perfspiDEMO.cfg
Cause
The problem is the demo database that comes with iSPI Performance for Metrics is enabled. This should be disabled in a production environment.
Fix
To disable the demo database, run:
# %NPSInstallDir%\NNMPerformanceSPI\bin\demoData.ovpl disable
[4524] C:\Program Files (x86)\HP\HP BTO Software\NNMPerformanceSPI\bin\demoData.ovpl(45) INFO: Setting BISrvr DataSource Connection PerfSPI_Diagnostics to use DSN PerfSPIDSN-32
[4524] C:\Program Files (x86)\HP\HP BTO Software\NNMPerformanceSPI\bin\demoData.ovpl(45) INFO: Setting BISrvr DataSource Connection Component_Health to use DSN PerfSPIDSN-32
[4524] C:\Program Files (x86)\HP\HP BTO Software\NNMPerformanceSPI\bin\demoData.ovpl(45) INFO: Setting BISrvr DataSource Connection Interface_Health to use DSN PerfSPIDSN-32
[4524] C:\Program Files (x86)\HP\HP BTO Software\NNMPerformanceSPI\bin\demoData.ovpl(45) INFO: Setting BISrvr DataSource Connection FrameRelayPvc_Health to use DSN PerfSPIDSN-32
[4524] C:\Program Files (x86)\HP\HP BTO Software\NNMPerformanceSPI\bin\demoData.ovpl(45) INFO: Setting BISrvr DataSource Connection AtmPvc_Health to use DSN PerfSPIDSN-32
[4524] C:\Program Files (x86)\HP\HP BTO Software\NNMPerformanceSPI\bin\demoData.ovpl(50) INFO: Demo Data Disabled
NOTE: Please close any open browser sessions. Use a new browser session to view reports
Hit Enter key to exit...
Once completed and there are no error messages as shown in the above output, then execute a stop and start:
# %NPSInstallDir%\NNMPerformanceSPI\bin\stopALL.ovpl
# %NPSInstallDir%\NNMPerformanceSPI\bin\startAll.ovpl
Close all browsers and test cross launching from NNMi to PerfSpi.
Related documents:
KM1202944 Troubleshooting NNM iSPI Performance for Metrics issues from the NNMi perspective
KM1300740 Troubleshooting NPS console issues
KM1203038 Troubleshooting NNM iSPI Performance for Metrics issues from the Network Performance Server perspective