Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Error: "Object reference not set to an instance of an object"

You may find this error in the SQList event log:

An error occured while updating entries in list "List name", connection [...] The list export was aborted. System.NullReferenceException: Object reference not set to an instance of an object.

This error is caused by a known issue with older versions of SQList, in which expired SharePoint change tokens were not handles correctly; this was rectified this in version 5.2.

  1. To resolve this issue, please follow these steps:
  2. Using SQList Manager, stop the SQList service;
  3. From the destination database, run: select * from [(SQList.SyncStatus)];
  4. Locate the row that contain the list "List name";
  5. Delete that row from the table;
  6. Using SQList Manager, start the SQList service.
  7. Monitor the event log, the error message should no longer come up. If that is not the case, please contact us again.
We recommend that you upgrade to the latest version of SQList; should you decide to do so, we strongly recommend that you try the upgrade on a test environment first and take a backup of your destination database before the upgrade, as there may be several changes from the version you are currently running.

For a full list of changes, please refer to this support article: