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

Document ID : KB000048817
Last Modified Date : 14/02/2018
Show Technical Document Details

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.