Resolving Error - 'Invoke-NAVApplicationDatabaseConversion: An unexpected error occurred after a database command was cancelled.'
Introduction: While doing Data Migrations from BC14 to BC22, there was an error ' Invoke-NAV ApplicationDatabaseConversion: An unexpected error occurred after a database command was cancelled.' in Business Central in the Database Conversion. I confirmed the DB connectivity is working fine and failed only at Invoke-NAVApplicationDatabaseConversion. Pre-requisites: 1. Understanding of BC Data Migrations 2. Basic understanding of SQL versions Demonstration: As you know that while upgrading NAV / Business Central, you are requested to run the Application Database Conversion. In this case, I was directly trying to convert from BC14 to BC22 and I ended up with this error. To confirm this I checked the Upgrade compatibility matrix https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-v14-v15-compatibility and then there was an unexpected error. I tried to do the steps again and seem to receive the error again. After checking the Event Viewer it w...