BDC Exception thrown during SharePoint Workspace sync if External list's Data Base table fields have some special chars

Symptoms

Using SharePoint Designer create an external list from data base, if the data base table field contains special characters such as " . " or " \ " or " [ " a BCD  Exception will throw when syncing this list with the SharePoint WorkSpace.  The item can not be synced to the SharePoint WorkSpace.

Error:  This list doesn't have items to display

Cause

SharePoint cannot parse these special characters

Resolution

Do not use these special characters in database table fields.

More Information

Repro steps:

1.Using SharePoint Designer create an External Content Type from a table whose field contains some special chars such as " . " or " \ " or " [ ".
2.Using SharePoint Designer create an External List from that External Content Type.
3.Put some items in the list.
4.Add the list to a SharePoint Workspace.

Properties

Article ID: 2018462 - Last Review: Oct 19, 2010 - Revision: 1

Feedback