Issue
During upgrade k2 Five that database resides in Azure SQL, the following error may be encountered:
Could not successfully execute action 'SourceCode.Data.All.dacpac'. Exception: Verification of the deployment plan failed.
Error Code
When reviewing Install Trace log, the following error is present:
Error SQL72032: If this deployment is executed, [Category].[Data].[nci_wi_Data_2BDF6015B2331A5D25B58FAF2723D977] will be dropped and not re-created. This dynamic index is auto generated by Azure SQL.
Resolution
Dropping the above index on Category.Data table will allow the upgrade to complete successfully.