Skip to content

Import Export PowerTool · How-to guides

Errors When Upgrading to Business Central 24

Last updated June 5, 2024

Some versions of Business Central extensions, including those from Insight Works and other providers, inserted data in a “Service Connection” table. Starting with Business Central 24, Microsoft has flagged this table as a temporary table, preventing data from being stored in it and generating errors if it already contains data. If this table has data in it from previous versions, Microsoft will prevent you from upgrading to Business Central 24 without performing manual steps.

To address the issue, you can either manually delete the records from the table or manually update the extensions from the Business Central Admin Center.

Option 1: Delete the data manually

  1. Install Insight Works’ free Import Export Powertool from AppSource.
  2. Navigate to the Import Export Powertool Setup page in Business Central and complete the setup.
  3. Set the Operation field to Delete.
  4. Set the Table ID field to 1400.
  5. Select Actions / Delete Data to delete all records from the table.

Option 2: Update the extensions manually

  1. Select the icon / Admin Center in Business Central.
  2. Select the environment to update and select Apps.
  3. Select Install update for all extensions with that option.

Once the extensions have been updated, you will be able to upgrade to Business Central 24 using the standard process.

View this article as Markdown

Still need help?

Ask other Business Central users in the Insight Works community, or send the details to the support team. Include the steps you took and any error message you saw.