3499313 - Deployment was stuck with "Migrate Data" mode due to an SQLTimeoutException error

Deployment with "Migrate Data" step was stuck, then failed due to a SQLTimeoutException that was thrown similar to below:

----

problem executing sql [reason: StatementCallback; SQL [ALTER TABLE addresses ADD p_patronymic NVARCHAR(255); ALTER TABLE basestore ADD p_enablecanceldoforstore TINYINT; ALTER TABLE cartentries ADD p_namedpreordershipmentlastday DATETIME2; ALTER TABLE cartentries ADD p_originaldeliverygroup INTEGER; ALTER TABLE catalogs ADD p_productthresholdcheckforspec TINYINT; ALTER TABLE categories ADD p_returnabledays INTEGER; ALTER TABLE cmssite ADD p_tokorewardsconfig BIGINT; ALTER TABLE deliverymodes ADD p_displaydispatchnoteonemail TINYINT; ALTER TABLE deliverymodes ADD p_pickupdeliverywidget BIGINT; ALTER TABLE deliverymodes ADD p_productdimmmlimit INTEGER; ALTER TABLE deliverymodes ADD p_productdimsummmlimit INTEGER; ALTER TABLE deliverymodes ADD p_deliveryslotservicecode BIGINT; ALTER TABLE deliverymodes ADD p_rddconfig BIGINT; ALTER TABLE discountslp ADD p_tnclink NVARCHAR(255); 
...
CREATE INDEX i90a41021_nameidx_typesystemprops2 ON typesystemprops2 (NAME); CREATE INDEX i90a41021_itempk_typesystemprops2 ON typesystemprops2 (ITEMPK); CREATE INDEX i90a41021_realnameidx_typesystemprops2 ON typesystemprops2 (REALNAME)]; The query has timed out.; nested exception is java.sql.SQLTimeoutException: The query has timed out.]

----

It may be possible that the deployment will fail due to the same error, but the query it was trying to execute is different.

SAP Commerce Cloud

deployment failed, SQLTimeoutException error, SQLTimeoutException, deployment stuck , KBA , CEC-SCC-CLA-DEP , Deployments , Problem