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

(0) Share

Report

Posted on by khudeja

305

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No