NPS 10 installation failed on "Create Perfspi Database"

  • KM01742194
  • 17-Jul-2015
  • 23-Jul-2015

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.


NPS 10 intallation is failing on DB creation. # initializeNPS.ovpl INFO: Select action interactively: HP Network Performance Server (NPS) Initialization Program -- A utility tool to configure and initialize NPS. Number Action Status ------------------------------------------------------------ 1: Install Sybase IQ Success 2: Install BI Server Success 3: Install Sybase ASE Database Success 4: Create Sybase ASE Content Store Success 5: Create Perfspi Database Failed 6: Drop Perfspi Database NotRun 7: Pre-Configure BI Server Success 8: Configure PMi Success 9: Start BI Server Success 10: Restore BI Config and ContentStore Success 11: Setup Content Store Roles and Security Success 12: Configure BI Server Access Control List Success 13: Restart BI Server Success 14: Enable Auto FS on Linux Success 15: Creating Man Pages Success 16: Install PerfSPI_Diagnostics Reportpack Failed 17: Initialize custom collections Success 18: Install Metrics Extension Packs Failed 19: Upgrade Metrics Extension Packs Success 20: Get Help for This Script 21: Quit This Script ------------------------------------------------------------


Step 5 failed:

5:      Create Perfspi Database                      Failed

See full error message in "PerfSPI_RunInitializeNPS_CreatePerfSPIDB.txt"
Error! The connection to the database was closed by the server.
  Connection was terminated
  SQLCODE=-308, ODBC 3 State="HY000"
  File: "create_database.sql" on line 1, column 9
  create database '/var/opt/OV/NNMPerformanceSPI/database/perfspi.db'
          IQ PATH '/var/opt/OV/NNMPerformanceSPI/database/'
          IQ SIZE 19587
          IQ PAGE SIZE 131072
Died at /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/ line 194.
FATAL: Stacktrace: 0. /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/ [NPS::npslog::FATAL()]
FATAL: Stacktrace: 1. /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/ [main::system_or_die()]
FATAL: Stacktrace: 2. /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/ [main::createDB()]
FATAL: Stacktrace: 3. /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/ [main::PerfSPIDB_actions()]
FATAL: Stacktrace: 4. initializeNPS.ovpl:132 [main::CreatePerfSPIDB()]
FATAL: Failed command system("dbisql" -onerror exit -nogui -c "DBN=UTILITY_DB;UID=DBA;PWD=sql;HOST=localhost"  "/var/opt/OV/NNMPerformanceSPI/database/create_database.sql"): 1280
FATAL ERROR: initializeNPS.ovpl -a CreatePerfSPIDB Failed. (Logfile /var/tmp/PerfSPI_RunInitializeNPS_CreatePerfSPIDB.txt)


Sybase IQ does not allow to create any datafile more than 4gb. That is a defect with Sybase IQ
It cannot create a temp space more than 4 GB
When server has disk space available, NPS tries to create temp space more than 4 GB causing the failure.


Contact the support to get the hotfix

1. Delete all the files in /var/opt/OV/NNMPerformanceSPI/database

2. Backup original pm file "/opt/OV/nonOV/perl/a/lib/5.8.8/NPS/"
rename the to
copy it to "/opt/OV/nonOV/perl/a/lib/5.8.8/NPS/"


And execute all "Failed" steps.

Note that step 16 and 18 could take time to complete (1 hour).