We found a bug in our software!

Well, yes, it hurts to admit it, but we found a small bug in SQList. But it's fixed now!

Description:

This bug surfaces rarely and is difficult to reproduce and occurs when numerous updates are performed to a SharePoint list programmatically (using CSOM, JSOM, etc.), especially when made from several locations simultaneously. In this situation, SQList occasionally misses some of these updates, and they do not get replicated to the SQL database.

Resolution:

Customers currently running SQList version 5.x should upgrade to the latest version of SQList, ver. 5.0.3.

Customers running SQList version 4.x should upgrade to SQList ver. 4.9.1.

Recommendation:

We recommend that all current users of SQList ver. 5.x and 4.x upgrade to the latest version at their earliest convenience, even if they have not experienced any missed updates. See below for detailed instructions on how to upgrade, and potential breaking changes.

Before you upgrade

Before you upgrade, ensure that you understand the changes explained below, as they are potentially breaking changes:

Affecting both, ver. 4.x and 5.x, users:

  • The system table (SQList.Status) has been removed and replaced by a new table named (SQList.SyncStatus);
  • A new column named SQList.ChangeToken has been added to all SQL tables generated by SQList;
  • We have removed the settings used to limit the maximum number of items that are retrieved when checking for changes and deletions (SQList now uses SharePoint’s internal throttling settings).


Affecting only ver. 4.x users:
Some features of version 5.x had to be retrofitted to version 4.9.1 to fix this issue; these are:


  • Changed handling of non-standard column types;
  • Increased precision for numbers "Displayed as percentage";
  • Added SiteID to UNION view;
  • All SharePoint system lists are now available.

You can find a full description of these changes in this article:

http://support.axioworks.com/upgrade-notes/what-is-new-in-sqlist-ver-50



We strongly recommend that, before upgrading your current production installation of SQList, you try the new version of SQList as a brand new installation on a separate machine and replicate your data to a new SQL database.



To try the new version you can use this temporary license for SQList Professional valid until 31st Dec 2016. This license does not require activation ad can be installed on as many machines as you need.

https://services.axioworks.com/MSIs/TrialLicense_exp31Dec2016.txt

You can use the “Update License” button in SQList Manager to install this license.



Once you have confirmed that the new version works as expected, you should take a backup of your SQL database(s) and then proceed with the upgrade of your current production installation of SQList.


How to upgrade

To upgrade your installation of SQList, please follow these steps:

  1. As a precaution, take a backup of all SQL databases being updated by SQList;
  2. Uninstall the current version of SQList (use the Windows "Add/Remove Programs" or "Uninstall a program", depending on the version of Windows);
  3. If you are running SQList version 5.x: download the SQList ver. 5.0.3 (or latest version) from this link: https://services.axioworks.com/MSIs/SQListSetup.msi
  4. If you are running SQList version 4.x: download the SQList ver. 4.9.1 from this link: https://services.axioworks.com/MSIs/previous-versions/SQListSetup_v491.msi
  5. Run the MSI package; this will install the new version of SQList;
  6. Start SQList and monitor for the event log.

Important notes:

  • Uninstalling SQList will leave your profile and license files in the installation folder; make sure you do not delete them;
  • If you made any changes to the .config files, make sure you make the same changes after the upgrade;
  • The first time it runs, this new version of SQList will check the integrity (and fix where necessary) of the SQL tables being exported; this may take some time depending on the amount of data, but is done only once.

Need help?


If you require assistance, or have any questions, with the upgrade process, please do not hesitate to contact us at support@axioworks.com