How to apply Incremental 1 patch RO53528 using a non-default SQL port number.

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

Description:

If a non-default MSSQL port is specified when running the "Install_INCR_NT.bat" file to apply Incremental 1 patch RO53528 , the patch installation fails. For example:

 	Install_INCR_NT.bat -t S -d MSQ -n AEDB,2680 -u sa -p sapswd -s WAAEPROD 

Where:

AEDB is the db_name

2680 is a non-default MSSQL DB port number

WAAEPROD is the db_server

During the install the patch replaces a number of binaries but then rolls back after it fails to connect to the DB.

Solution:

As a workaround, the following manual steps can be applied:

1. Modify the 'Install_INCR_NT.bat' file and change the following value:
   
   From this:
   
   set /a rollback=1
   
   To this:
   
   set /a rollback=0
   
   This will disable the rollback of the patch when it fails, allowing the newly replaced binaries to remain.
   
   
2. Refresh AEDB by running 'perl RefreshAEDB.pl'.
   
   When prompted to enter "RefreshAEDB: <db_server>", enter the following:
   
   db_server,2860
   
   Where 2860 is the SQL port number (use the appropriate port number for your environment)
   
   This will update the DB and thus the patch will be fully installed.

Environment

Release:
Component: ATSYS