Postgresql database script execution is unsuccessful

Sreevignesh — Thu, 14 Sep 2017 16:29:31 GMT

Hello,

I tried installing HP Performance Advisor 7.1 on a server. The installation fails with the message " PostgreSQl database installation is successful. postgresql database script execution is unsuccessful. HPE XP7 performance advisor management station installation is rollback". I have also been working on other set of servers, where the installation is smooth. But this has happened only in two servers until now. Has anyone else faced the same?

Below is the log extract from where the fail kicks off,

9-14-2017 05:08:26 :: INFO :: Successfully launched Postgres batch file :C:\HPE\HPSS\utils\silentInstall.bat

9-14-2017 05:08:26 :: INFO :: File (C:\HPE\HPSS\utils\silentInstall.bat) deleted Successfully

9-14-2017 05:08:26 :: INFO :: Postgres Successfully installed

9-14-2017 05:08:26 :: INFO :: Postgres Bin Path :C:\HPE\HPSS\Postgres\bin

9-14-2017 05:08:26 :: INFO :: Directory(C:\HPE\HPSS\padb\)s Created Successfully

9-14-2017 05:08:26 :: INFO :: Data Dir Path :C:\HPE\HPSS\padb\

9-14-2017 05:08:26 :: INFO :: Directory (C:\HPE\HPSS\padb\) Already exists

9-14-2017 05:08:26 :: INFO :: Postgres database command line :Y C:\HPE\HPSS\Postgres\bin C:\HPE\HPSS\padb\

9-14-2017 05:08:43 :: INFO :: Exitcode from the program C:\HPE\HPSS\scripts\installdb.bat=2

9-14-2017 05:08:43 :: ERROR :: Launch Application Failure

9-14-2017 05:08:43 :: ERROR :: Database installation fails, unable to create database :C:\HPE\HPSS\scripts\installdb.bat

9-14-2017 05:09:13 :: ERROR :: PostagreSQL database installation is successful. PostagreSQL database script execution is unsuccessful. HPE XP7 Performance Advisor Management Station installation is rollback.

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:26.61 - START - installdb xxx xxx Y C:\HPE\HPSS\Postgres\bin

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:26.61 - Installing as NT Service...start

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:26.70 - Installing as NT Service...end

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:26.71 - Initializing database...- start

9-14-2017 05:09:13 :: The files belonging to this database system will be owned by user "SYSTEM".

9-14-2017 05:09:13 :: This user must also own the server process.

9-14-2017 05:09:13 ::

9-14-2017 05:09:13 :: The database cluster will be initialized with locale "English_United States.1252".

9-14-2017 05:09:13 :: The default text search configuration will be set to "english".

9-14-2017 05:09:13 ::

9-14-2017 05:09:13 :: Data page checksums are disabled.

9-14-2017 05:09:13 ::

9-14-2017 05:09:13 :: creating directory C:/HPE/HPSS/padb/data ... ok

9-14-2017 05:09:13 :: creating subdirectories ... ok

9-14-2017 05:09:13 :: selecting default max_connections ... 100

9-14-2017 05:09:13 :: selecting default shared_buffers ... 128MB

9-14-2017 05:09:13 :: selecting dynamic shared memory implementation ... windows

9-14-2017 05:09:13 :: creating configuration files ... ok

9-14-2017 05:09:13 :: creating template1 database in C:/HPE/HPSS/padb/data/base/1 ... ok

9-14-2017 05:09:13 :: initializing pg_authid ... ok

9-14-2017 05:09:13 :: setting password ... ok

9-14-2017 05:09:13 :: initializing dependencies ... ok

9-14-2017 05:09:13 :: creating system views ... ok

9-14-2017 05:09:13 :: loading system objects' descriptions ... ok

9-14-2017 05:09:13 :: creating collations ... not supported on this platform

9-14-2017 05:09:13 :: creating conversions ... ok

9-14-2017 05:09:13 :: creating dictionaries ... ok

9-14-2017 05:09:13 :: setting privileges on built-in objects ... ok

9-14-2017 05:09:13 :: creating information schema ... ok

9-14-2017 05:09:13 :: loading PL/pgSQL server-side language ... ok

9-14-2017 05:09:13 :: vacuuming database template1 ... child process exited with exit code 1

9-14-2017 05:09:13 :: initdb: removing data directory "C:/HPE/HPSS/padb/data"

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:32.42 - Initializing database...- end

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:32.42 - copy postgresql.conf file to data folder. -start

9-14-2017 05:09:13 :: The system cannot find the path specified.

9-14-2017 05:09:13 :: 0 file(s) copied.

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:32.42 - copy postgresql.conf file to data folder. -end

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:32.42 - deleting C:\HPE\HPSS\Postgres\bin.\pgpass.txt...- start

9-14-2017 05:09:13 :: Thu 09/14/2017 5:08:32.43 - deleting C:\HPE\HPSS\Postgres\bin.\pgpass.txt...- end

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.43 - check and create C:\HPE\HPSS\padb\\data\dbs -start

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.43 - check and create C:\HPE\HPSS\padb\\data\dbs -end

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.43 - check and create C:\HPE\HPSS\padb\\data\indexes -start

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.43 - check and create C:\HPE\HPSS\padb\\data\indexes -end

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.43 - call startdb.bat - start

9-14-2017 05:09:14 :: 'net' is not recognized as an internal or external command,

9-14-2017 05:09:14 :: operable program or batch file.

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.48 - call startdb.bat - end

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.48 - call build_datamodel.bat xxx xxx PA - start

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:43.06 - ERROR :: Create datamodel - Failed Error level 2

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.50 - START - build_datamodel xxx xxx padb C:\HPE\HPSS\Postgres\bin

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.50 - Calling getdbport - start

9-14-2017 05:09:14 :: C:\HPE\HPSS\scripts\\getdbport

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.53 - Calling getdbport - end

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.53 - delete datamodel.sql - start

9-14-2017 05:09:14 :: Could Not Find C:\HPE\HPSS\scripts\datamodel.sql

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.53 - delete datamodel.sql - end

9-14-2017 05:09:14 :: Thu 09/14/2017 5:08:32.53 - dropdb.exe padb - start

9-14-2017 05:09:14 :: dropdb: could not connect to database template1: could not connect to server: Connection refused (0x0000274D/10061)

9-14-2017 05:09:14 :: Is the server running on host "localhost" (127.0.0.1) and accepting