Error Messages and Resolution Tips

You may notice one or more of the error messages given below when using External Data Connector to connect to SharePoint and perform synchronization. This is not an exhaustive compilation of all error messages, but an attempt to include as many known error messages and how to resolve the errors. Please refer Troubleshooting section of online help document for more information.

Error Message Resolution
The remote server returned an error: (407) Proxy Authentication Required. Enable the Bypass proxy server for local addresses option available at LAN Settings of Internet Options of Internet Explorer Browser.
The remote server returned an error: (401) Unauthorized. Make sure the username and password is valid to connect the SharePoint site.
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Make sure the domains of the current user and the data source are trusted to access with windows authentication.
The remote name could not be resolved Ensure that the entered Site URL is valid.
Select atleast one table to continue this operation Ensure that you select at least one table in the query builder, to generate the SELECT statement.
Left and Right table names cannot be same, select unique tables In query builder, to perform JOIN operation, the selected left and right table should not be same. Select unique tables to perform JOIN operation.
Select columns of same datatype to join The selected columns for JOIN operation must be of same data type to proceed the JOIN operation.
Select atleast one reference column The reference column is used to avoid adding duplicate items in SharePoint list. So, it is mandatory to select atleast one column while mapping columns.
String was not recognized as a valid Date Time Ensure that the mapped column in the data source contains a valid data time value.
User/Group [group_name] is not found Check whether the reported group exists in the destination site collection. If it is a user name, ensure that the given user name exists in the corresponding SharePoint site or Active Directory domain.