web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

The following SQL error was unexpected: Cannot insert the value NULL into column ...

(0) ShareShare
ReportReport
Posted on by 305

Hi

I am trying to add a few fields in Resource Table. When I try to publish my extension, the following error is thrown in VSCode:

The request for path /v1.0/sandbox/dev/apps?SchemaUpdateMode=forcesync&DependencyPublishingOption=default failed with code 422. Reason: The following SQL error was unexpected: Cannot insert the value NULL into column 'Extension', table '<id>.dbo.CRONUS UK Ltd_$Resource$<id>'; column does not allow nulls. INSERT fails. The statement has been terminated.

Please Note: 'Extension' is the name of my field here.

What is the cause for this and how can I resolve it?

Thanks

Khudeja

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,172 Most Valuable Professional on at

    Have you changed something on this "Extension" field (like its data type for example) from version A to version B of your extension? Have you tryed with SchemaUpdateMode:Recreate?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 665 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 418 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 280 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans