Self-Solve Knowledge Search

Minimize Maximize
NPS 10 installation failed on "Create Perfspi Database"
This document has not been formally reviewed for accuracy and is provided as is
Title :
NPS 10 installation failed on "Create Perfspi Database"
Document ID :
KM01742194
Product - Version:
network node manager ispi performance for metrics 10.00 ;
OS :
Linux,Windows
Updated :
Thu Jul 23 08:28:56 GMT 2015
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 ------------------------------------------------------------
Problem

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