DB errors on installing Introscope enterprise manager

book

Article ID: 141424

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) CA Application Performance Management (APM / Wily / Introscope) INTROSCOPE DX Application Performance Management

Issue/Introduction

After Installing introscope enterprise manager windows 64 bit, received a error message at the end of the installation 

Install Database Failed
                          Status: ERROR
                          Additional Notes: ERROR - (STDOUT: postgres install arguments: mode unattended --unattendedmodeui none --servicename "pgsql-9.6" --serviceaccount "postgres" --servicepassword "******" --superaccount "postgres" --superpassword "******" --serverport 5432 --prefix "C:\Program Files\CA APM\PostgreSQL-9.6.2" --datadir "C:\Program Files\CA APM\PostgreSQL-9.6.2\data" 
launched the database installer file postgresql-9.6.2-3-windows-x64.exe. Installation in progress...
postgres installation has taken longer than expected. Assuming it as a hung process. 
Killing the process postgresql-9.6.2-3-windows-x64.exe
SUCCESS: Sent termination signal to the process "postgresql-9.6.2-3-windows-x64.exe" with PID 22152.
Failed to load SQL modules into the database cluster.
Problem running post-install step. Installation may not complete correctly
 Error reading file C:/Program Files/CA APM/PostgreSQL-9.6.2/data/postgresql.conf
Problem creating uninstaller. Installation may have not completed correctly.

Cause

Permission issue.

Environment

Release : 10.7.0

Component : APM Agents

PostgreSQL: 9.6

OS: windows 10

Resolution

This is the output of the below command which will run successfully 

"cscript //NoLogo "C:\Program Files\CA APM\PostgreSQL-9.6.2/installer/server/initcluster.vbs" "postgres" "postgres" "****" "C:\Program Files\CA APM\PostgreSQL-9.6.2" "C:\Program Files\CA APM\PostgreSQL-9.6.2\data" 5432 "DEFAULT" 0"

====================
Called AclCheck(C:\Program Files\CA APM\PostgreSQL-9.6.2\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the LVNTEST005937\Administrator account can read the path C:\Program Files\CA APM\PostgreSQL-9.6.2\data
Executing batch file 'rad82B25.bat'...
processed file: C:\Program Files\CA APM\PostgreSQL-9.6.2\data
Successfully processed 1 files; Failed processing 0 files
===========================================

. Run the above command in the postgres installation directory and check with your system team why the error was coming.

If that command ran successfully, postgres installation should be fine.