Incompatibility with certain versions of SQL Server 2012/2014

Due to problems detecting the SQL Server version, Lime CRM Server may stop functioning with the following versions of SQL Server:

  1. SQL Server 2012 Service Pack 2 with Cumulative Update package 9 (CU9)
  2. SQL Server 2012 Service Pack 2 with Cumulative Update package 7 (CU7)
  3. SQL Server 2012 Service Pack 3/GDR
  4. SQL Server 2014 Service Pack 1 with Cumulative Update package 3 (CU3)

In Lime CRM Desktop Client, after logging in, all operations requiring roundtrips to the database (e.g. loading lists and records) will cause the error messages similar to the ones below to be displayed:

Conversion failed when converting the nvarchar value ('CU7) (KB3072100) - 11' to data type int.

or

Conversion failed when converting the nvarchar value 'CU3) (KB3094221) - 12' to data type int.

or

Conversion failed when converting the nvarchar value 'CU9) (KB3098512) - 11' to data type int.

Apply this hotfix to patch the relevant stored procedure.

An issue with the SQL Server detection logic in combination with the version string used by the new update package causes Lime CRM Server to be unable to execute many database queries.

All Lime CRM Server versions of Lime CRM Server up to and including 12.0.973.15.

Please contact our support team if you have questions regarding any of the above.

  • Last modified: 6 years ago
  • (external edit)