Exception: Verification of the deployment plan failed.

  • 16 February 2021
  • 0 replies
  • 124 views

Badge +6
  • Nintex Employee
  • 11 replies

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.

 

Additional Information

Related Links


0 replies

Be the first to reply!

Reply