I'm trying to view CRM Customer data from the SQL database in SharePoint so that I can use it in surveys etc.

I followed these instructions (amongst others) http://crmconsultancy.wordpress.com/2011/12/15/integrating-dynamics-crm-data-into-sharepoint-2010/ and am having no joy. I've got the list page to show up but there is no data showing.

In SharePoint Designer when creating the Read List and Read Views I get the following error.

"This operation type can modify data in the data source. The data source element statecode is not nullable in the data source. Mark this data source element as a field in the operation."

I've no idea what this means. If anyone could help?

1 Answer 1


If i'm not mistaken your error simply states that a certain field (which does not allow NULL) have to be also added during the configuration of your BDC Model (most likely in the Read Item). Make sure you are not missing any of the Key fields in your selection.

Hope it helps, C:\Marius

  • I have an accountid field picked, which has null set to false. For now I'm only trying to get the first name and last name to display, but can't get around this error.
    – rowdybeans
    Commented May 15, 2012 at 11:05
  • I just ended up using another field with the null value as false. All working now. Thanks
    – rowdybeans
    Commented May 15, 2012 at 12:20
  • Glad it helped! Commented May 15, 2012 at 12:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.