Cannot insert the value NULL into column 'SelectedOptionValues',

(0) Share

Report

Posted on by nozd

For update operation I can set OptionSetValueCollection field to null; for example:
kc_accountcontact.kc_directions = null

But for create operation I can't set directly OptionSetValueCollection field to null; I get error:
Sql error: 'Cannot insert the value NULL into column 'SelectedOptionValues', table '***.dbo.MultiSelectAttributeOptionValuesBase'; column does not allow nulls. INSERT fails. The statement has been terminated.'

How can I set OptionSetValueCollection field to null for create operation?
I use XrmToolBox / Early Bound Generator; since today this plugin has gotten opportunity to work with Multi-Select OptionSets, but this doesn't resolve my issue

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (0)

Report

RE: Cannot insert the value NULL into column 'SelectedOptionValues',

Hello,

You can open a ticket with Microsoft and ask for a fix in their core. I'm afraid there is no other way of doing it. Anyway - good luck.
nozd 30 on at

Like (0)

Report

RE: Cannot insert the value NULL into column 'SelectedOptionValues',

Thank's, I know it; now I use this workaround. But I use Upsert operation and I'd like to set null directly as well as other type fields
Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Cannot insert the value NULL into column 'SelectedOptionValues',

Hello,

Just don't populate field and it'll be created as null. Experienced this issue as well.