Issue while upgrading TDV 7.0.6 to 7.0.8

Issue while upgrading TDV 7.0.6 to 7.0.8

book

Article ID: KB0079936

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.6, 7.0.8,

Description

TDV Server not able to start the services after upgradation from 706 to 708.

Lets say if the base installer was 7.0.2, the history of upgrade done earlier is 7.0.2>7.0.4>7.0.6> now they are upgrading to 7.0.6 to 7.0.8

Then you will notice below errors in the pg_upgrade_server.log:
-----------------------------------------------------------------
  pg_upgrade run on Thu Sep 20 09:39:17 2018
-----------------------------------------------------------------
command: "/apps/composite/CIS_7.0/install/pre708/repository/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/apps/composite/CIS_7.0/install/pre708/repository/data" -o "-p 9408 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/apps/composite/CIS_7.0'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....2018-09-20 09:39:17.803 UTC [  7349]FATAL:  could not open log file "../../logs/cs_repository/cs_repository-Thu.log": No such file or directory
.... stopped waiting
pg_ctl: could not start server
Examine the log output.
-----------------------------------------------------------------
  pg_upgrade run on Thu Sep 20 09:46:21 2018
-----------------------------------------------------------------
command: "/apps/composite/CIS_7.0/install/pre708/repository/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/apps/composite/CIS_7.0/install/pre708/repository/data" -o "-p 9408 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/apps/composite/CIS_7.0'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....2018-09-20 09:46:21.599 UTC [  9807]FATAL:  could not open log file "../../logs/cs_repository/cs_repository-Thu.log": No such file or directory
.... stopped waiting
pg_ctl: could not start server
Examine the log output.
-----------------------------------------------------------------

Environment

Any

Resolution

From TDV Server 7.0.2

1>  TDV Server : Stop the TDV Repository, TDV Cache and TDV Monitor processes.
2> Apply the TDV Server patch (7.0.7 or higher)

3> Edit the following file(s):
           TDV Server :
               Edit files <INSTALL_DIR>/repository/data/postgresql.conf and <INSTALL_DIR>/repository/data_cache/postgresql.conf
               Replace " log_directory = '../../logs/cs_repository'" with "log_directory = '../../logs'"
               Replace " log_directory = '../../logs/cs_data_cache' " with  "log_directory = '../../logs'"
4> UNIX and Window installations:
   Execute the 7.0.7 or higher TDV Server
              Examples:   $ cd <INSTALL_DIR>; ./bin/cis_upgrade_patch.sh (TDV upgrade) 

==================================================

Issue/Introduction

Issue while upgrading TDV 7.0.6 to 7.0.8, pg_ctl: could not start server, Examine the log output.