Wednesday, April 4, 2012

Error on SharePoint list: Invalid number value...

Got the following error while working on a list with BDC data columns:
Invalid number value.  A number field contains invalid data. Please check the value and try again.
Cause: On the database where the BDC is pulling data from, one of the columns was changed from type of Int32 to a String.  Even though the xml definition file was updated accordingly, this error comes when you try to save the list item after picking a BDC item.

Resolution:  Go to the list settings, click on the BDC column, uncheck the 'problem' column (i.e. the column that changed type), go back and the problem is gone.  You can re-add the column back by checking it.  Refresh.  All the data will be refreshed and no more errors.