How to solve 'Attribute : .......cannot be set to null' error

Question

I am setting 'statecode' field of entity 'quote' of CRM using script component in ssis as:

if(!Row.activated_IsNull)
        {
            quote.Attributes["statecode"] = Row.activated;
        }
        else
        {
            quote.Attributes["statecode"] = null;
        }

But I am getting following error when I run the it:

What can be the reason for this?

Answer 1

Because Dynamics CRM (aka PowerApps) statecode/statuscode is not nullable, and cannot accept the null value in DB. The pair is kind of pre-defined/pre-paired/configurable set of values that can correlate together. Read more and the documentation link can help you to understand it.

Either you should default it to the Initial status (for ex. "Draft" or "Active") or create your own custom picklist attribute for nullable status field.