Unable to publish extensions involving Item table in Business Central

(2) Share

Report

Posted on by CU03101250-0

Hello Guys,

In my Business Central sandbox, I am unable to publish any extension that involves the Item table or Item Card. Extensions for other tables (e.g. Customer, Sales line) work fine.

When adding fields to an Item, only Code or Boolean types succeed.

Adding Decimal, Date, or other field types always fails with an error:
“An unexpected error occurred after a database command was cancelled. The original extensions have been restored.”

I have already tried creating a completely new extension with unique field IDs and names, but the issue persists.

Could you please advise how to resolve this? Is it related to schema synchronization or residual extensions on the Item table?

Thank you.

Categories:

Dynamics 365 Business Central

{EA4894FC-B831-4F...

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Aman Kakkar 172 on at

Like (1)

Report
Unable to publish extensions involving Item table in Business Central

Hi,

It seems like a schema synchronization issue.

Try the below mentioned approaches (you’ll need to test which one resolves it in your sandbox):

Go to launch.json, and try using "schemaUpdateMode": "ForceSync". Use this with caution as it might delete your data.

Go to Extension Management and review any extensions with a Publisher other than Microsoft. Check with your colleagues which of these can be removed, as they may interfere with your extension deployment.

If the above approaches don’t work, create a new sandbox environment or test the same code in another sandbox to verify if the issue is environment-specific.

I hope it helps.

Aman K

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 3,648 on at

Like (1)

Report

Unable to publish extensions involving Item table in Business Central

Hi,

This usually happens because the Item table is heavily used and has dependencies, especially in standard Business Central tables and pages. Decimal, Date, or other field types require schema changes that the sandbox cannot handle automatically if there are residual or conflicting extensions.

Possible solutions:
> Check for residual extensions: Remove any previously published extensions that touched the Item table.
> Incremental field IDs: Make sure the new field IDs do not conflict with any existing or deleted fields.
> Use a fresh sandbox: Sometimes sandbox databases retain old metadata; creating a new sandbox often resolves publishing issues.
> Publish in stages: Add only one new field at a time to minimize schema lock conflicts.
> Check AL code: Ensure decimal/date fields have default values if marked mandatory and proper table extension references.

If the issue persists, this may require Microsoft support, as certain table schema changes in production or long-lived sandboxes can fail silently.

Thanks

Rishabh

Was this reply helpful? Yes No

Community site session details

Unable to publish extensions involving Item table in Business Central

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Unable to publish extensions involving Item table in Business Central

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates