SDM Installer stuck at 93% while applying RU22 on 17.3

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

While applying RU22 on 17.3.0.16 one of the APP servers got stuck at 93%.

As per logs it is failing at step loading "upd_usp_servers_load.dat":

INFO  Task.java              215 Running: Update Miscellaneous data
INFO  UpdateMiscDataTask.java    96 ## loading D:\PROGRA~1\CA\SERVIC~1\data\upd_usp_servers_load.dat with (-u) options.

 

Environment

Release : 17.3

Resolution

1. From SQL server management studio executed the command -> select * from al_cdb_componentinstallstate where packageid like '%sdm%17.3%' and took the backup of these rows. 

2. Now executed the command to make these tasks as failed for this particular application server:

 "update al_cdb_componentinstallstate set installationstate='Failed' where packageid='%sdm%17.3%' AND machinename='SERVERNAME' AND packageid IN(

      'task.sdm.patch.binaries.17.3.0.22',

      'task.sdm.patch.locale.17.3.0.22',

      'task.sdm.preconfigure.steps.17.3.0.22',

      'task.sdm.patch.binaries.17.3.0.2',

      'task.sdm.patch.locale.17.3.0.2',

      'task.sdm.preconfigure.steps.17.3.0.2',

      'task.sdm.postinstall.steps.17.3.0.2',

      'task.sdm.patch.binaries.17.3',

      'task.sdm.preconfigure.steps.17.3',

      'task.sdm.patch.locale.17.3',

      'task.sdm.postinstall.steps.17.3'

3. Then, re-ran the setup.exe to upgrade SDM on the app server and it was successful.