Error Example:An error occurred while executing connection '<connectionName>': Column '<columnName>' does not allow nulls. Cause:This error can come from different sources that allow for the user to set a column as not allowing for NULLs. Most commonly seen in SQL and other databases, they can also be set in SharePoint and other systems. It is caused when the user has a sync that would pass a NULL or blank value to a column set not to allow nulls. It can also occur with SharePoint if the column already had NULL values but was later configured to "Require a unique value". SharePoint UI only checks the constraint when the record is going to be saved, but when Cloud Connector checks, this situation will cause this error.
Resolution/Workaround:You will need to check your data and make sure no NULL values are being passed to a column that doesn't allow for NULL data. This could be due to mapping mistake, that the column doesn't have a default value and should, or another error is causing an inserted item not to recieve the value. |
Column 'X' Does Not Allow Nulls
