Error Message

The pg_upgrade.log at \ProgramData\Symantec\VRTSsfmcs\logs\ would report below entries

[debug] pg_upgrade: C:\ProgramData\Symantec\VRTSsfmcs\pgsql_bkup\bin\pg_ctl -w -D C:\ProgramData\Symantec\VRTSsfmcs\db\data -o "-p 5636" start

[debug]  pg_upgrade: Command [C:\ProgramData\Symantec\VRTSsfmcs\pgsql_bkup\bin\pg_ctl -w -D C:\ProgramData\Symantec\VRTSsfmcs\db\data -o "-p 5636" start] failed with return code [1] with error message [No such file or directory].

This issue occurs due to either/both of the following reasons:

a) The VIOM DB is installed at a non-default location. The default location is \ProgramData\Symantec\VRTSsfmcs\db

OR/AND

b) The upgrade was attempted by a non-administrator user.

This causes the pg_ctl command from the upgrade script to fail. Thereby, causing the DB service to fail upon startup after the upgrade is completed.

Before proceeding with below steps ensure there is a valid DB backup taken from previous VIOM version 7.4.0.The default location for the VIOM DB is  C:\ProgramData\Symantec\db\data

1) Uninstall VIOM 7.4.2 and reboot the server.

2) Install VIOM 7.4.0 and once again reboot the server

3) Configure VIOM using Veritas InfoScale™ Operations Manager 7.4 Installation and Configuration Guide

4) Stop VIOM DB service using C:\Program Files\Veritas\VRTSsfmh\bin>perl.exe vomadm service --stop db

5) Rename data directory of this new 7.4.0 install to a different name. The default location of this folder is C:\ProgramData\Symantec\db\data

6) Now copy the DB backup of previous 7.4.0 install, into this newly created data directory. The default location for the data directory is C:\ProgramData\Symantec\db\data

7) Start VIOM db services.

8) Add itrpbld user to DB with SQL command 

For that,
         a. Open cmd prompt with Administrator access and run cmd to connect to db
"C:\Program Files\Veritas\VRTSsfmcs\pgsql\bin\psql.exe" -U habdbsync -p 5636 SFMdb3

         b. Next run SQL cmd to create user and assign roles - CREATE ROLE itrpbld WITH SUPERUSER CREATEDB CREATEROLE REPLICATION LOGIN;

9) Use vomadm  to restart the webserver (C:\Program Files\Veritas\VRTSsfmh\bin>perl.exe vomadm service --restart web)

10) Use the VIOM 7.4.2 installer to upgrade VIOM environment now.

11) Before launching the VIOM Console post upgrade, use the pg_upgrade_utility to finish schema update using the patch available at Infoscale Operations Manager 7.4.2 db migration Fix

12) Post applying the patch, confirm that DB service is in RUNNING state using the command 

C:\Program Files\Veritas\VRTSsfmh\bin>perl.exe vomadm service --status db

13) The VIOM console should now be able to launch successfully.