NPS 10 installation failed on "Create Perfspi Database"

  • Document ID:KM01742194
  • Creation Date:17-Jul-2015
  • Modified Date:23-Jul-2015
    • Micro Focus Products:
      network node manager ispi performance for metrics 10.00

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

Summary

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 ------------------------------------------------------------

Error

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'
          COLLATION 'UTF8BIN'
          IQ PATH '/var/opt/OV/NNMPerformanceSPI/database/perfspi_IQ_SYSTEM_MAIN.iq'
          IQ SIZE 19587
          IQ PAGE SIZE 131072
  ...
Died at /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/npslog.pm line 194.
FATAL: Stacktrace: 0. /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/nps.pm:1636 [NPS::npslog::FATAL()]
FATAL: Stacktrace: 1. /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/npsini.pm:1584 [main::system_or_die()]
FATAL: Stacktrace: 2. /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/npsini.pm:148 [main::createDB()]
FATAL: Stacktrace: 3. /opt/OV/nonOV/perl/a/lib/5.8.8/NPS/npsini.pm:334 [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)
___________________________________________________________________________

Cause

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.

Fix

Contact the support to get the hotfix QCCR1B136699.zip

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/configureNpsServer_Db.pm"
rename the configureNpsServer_Db_modified.pm to configureNpsServer_Db.pm
copy it to "/opt/OV/nonOV/perl/a/lib/5.8.8/NPS/"

3.Run
initializeNPS.ovpl

And execute all "Failed" steps.

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