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

Article translations Article translations
Close Close
Article ID: 2018462 - View products that this article applies to.
Expand all | Collapse all

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: October 19, 2010 - Revision: 4.0
APPLIES TO
  • Microsoft SharePoint Designer 2010
  • Microsoft SharePoint Server 2010
Keywords: 
KB2018462

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com