Database error -2 while performing Identity Manager upgrade (183793)

Identity Manager configuration wizard was "stuck" on schema installation process for some time and eventually the database timeout.

Error message:
Error during execution of statement: Could not execute the following statement: exec vid_DropColumn 'xxx', 'xxx_alt'.
Error during execution of statement: exec vid_DropColumn 'xxx', 'xxx_alt'

Database error -2:
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Database contains a lot of hypothetical indexes which impacts the database migration during upgrade.

WORKAROUND:

Engage SQL Server Database Administrator (DBA) to clean up all hypothetical indexes before performing Identity Manager upgrade. If clearing the hypothetical indexes are not an option, please contact support for further assistance.

STATUS:

Defect 24193 has been filed to improve the migration process that resulted in database timeout caused by hypothetical indexes.