SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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) 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?

share|improve this question
up vote 0 down vote accepted

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

share|improve this answer
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 May 15 '12 at 11:05
I just ended up using another field with the null value as false. All working now. Thanks – rowdybeans May 15 '12 at 12:20
Glad it helped! – Marius Constantinescu - MVP May 15 '12 at 12:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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