This error is raised when a document cannot be downloaded from a SharePoint site, in which case SQList will abort the entire item (including the properties).
Description
SQList treats document libraries in much the same way as regular lists. The only difference is in the fact that, for document libraries, the binary content of the document is downloaded and stored in the "Document.Bytes" field of the target SQL Server database table.
This error is raised when a document cannot be downloaded from a SharePoint site, in which case SQList will abort the entire item (including the properties).
This error is common with SharePoint system lists (e.g. "List Template Gallery", "Master Page Gallery", "Theme Gallery", etc.) as those lists have special permissions.
To try and determine the reason the download is failing, follow these steps:
- From the same machine on which SQList is installed: open a new browser in incognito/private browsing;
- Copy and paste the URL of the document that is failing into the browser;
- When asked for credentials, use the same credentials used in SQList to connect to the SharePoint site;
- The download should fail at this point, and display the error with the reason for the failure.
Message Contents
The message contains the table name that failed, the ID and the URL of the document that could not be downloaded.
Resolution
This error could be caused by network issues preventing SQList from downloading a file, for example if it is of a very large size, or a lack of permissions available for the user being used to access the SharePoint site.
If your version of SQList allows list selection, and the error is generated from one of SharePoint system lists, you can simply select not to export that list (system lists are of no practical use in the SQL database).
If you cannot exclude the list from be exported, SQList can be configured to ignore the error by changing the "
Abort list synchronisation when document download fails" setting in the SQList Manager. If this is set to "false" SQList will ignore failed downloads and proceed with updating the properties of the list items (thus treating the library as a normal list).