chk_auto_up shows primary server details for both Primary and Shadow

Products

• Autosys Workload Automation

Issue/Introduction

chk_auto_up output shows that the Primary and Shadow processes are running in the same server.

______________________________________________________________________________

CAUAJM_I_50054 Attempting (1) to Connect with Database: ATS121
CAUAJM_I_50055 *** Have Connected successfully with Database: ATS121. ***
______________________________________________________________________________

CAUAJM_I_50128 Connected with Event Server: ATS121
______________________________________________________________________________

______________________________________________________________________________

CAUAJM_I_50038 Checking AutoSys Primary Scheduler on Machine: machine1.example.com
CAUAJM_I_50044 Primary Scheduler is RUNNING on machine: machine1.example.com
______________________________________________________________________________

CAUAJM_I_50038 Checking AutoSys Shadow Scheduler on Machine: machine1.example.com
CAUAJM_I_50045 Shadow Scheduler is RUNNING on machine: machine1.example.com

Cause

An unexpected entry ion the UJO_HA_PROCESS table showed duplication for the primary server.

SELECT * FROM AEDBADMIN.UJO_HA_PROCESS

HA_DESIGNATOR_ID	HA_STATUS_ID	HOSTNAME	PID	PORT	QUEUE_ID	TIMESTAMP
1	1	machine1.example.com	4,132,043	49,176	32,950	1,719,252,749
2	1	machine2.example.com	3,681,660	49,175	17,551	1,719,252,752
1	1	machine1.example.com	4,132,043	49,176	32,950	1,719,252,749

 

 

 

Resolution

 

• Stop the Primary and Shadow AutoSys scheduler and application server processes.
• Delete Primary and Shadow from UJO_HA_PROCESS table.
  DELETE from aedbadmin.UJO_HA_PROCESS where PID=<primary pid number> or PID=<shadow pid number>
• Start Primary scheduler process
• Verify Primary updated UJO_HA_PROCESS table.
  SELECT * FROM AEDBADMIN.UJO_HA_PROCESS should result in just the Primary server being listed.
• Start Shadow scheduler process
• Verify Shadow updated UJO_HA_PROCESS table.
  SELECT * FROM AEDBADMIN.UJO_HA_PROCESS should now reflect both Primary and Shadow servers.
• Run chk_auto_up to verify.
  chk_auto_up
  
  ______________________________________________________________________________

  CAUAJM_I_50054 Attempting (1) to Connect with Database: ATS121
  CAUAJM_I_50055 *** Have Connected successfully with Database: ATS121. ***
  ______________________________________________________________________________

  CAUAJM_I_50128 Connected with Event Server: ATS121
  ______________________________________________________________________________

  ______________________________________________________________________________

  CAUAJM_I_50038 Checking AutoSys Primary Scheduler on Machine: machine1.example.com
  CAUAJM_I_50044 Primary Scheduler is RUNNING on machine: machine1.example.com
  ______________________________________________________________________________

  CAUAJM_I_50038 Checking AutoSys Shadow Scheduler on Machine: machine2.example.com
  CAUAJM_I_50045 Shadow Scheduler is RUNNING on machine: machine2.example.com