Summary
Description
The Lansweeper Patch Tuesday report is currently non-functional. Users depend on this monthly report, and its failure indicates potential underlying issues. The error message suggests that the TRY_CONVERT function, which is essential for the report, is unavailable.
Cause
The issue arose due to the database compatibility level. The Lansweeper database was configured to compatibility level 100, which does not support the TRY_CONVERT function. This function necessitates compatibility level 110 (SQL Server 2012). The misconfiguration impeded the generation of the report.
Troubleshooting
- Verify the database compatibility level in SQL Server. This resource from Microsoft provides guidance on how to check this in SQL Server Management Studio (SSMS): View or Change the Compatibility Level of a Database - SQL Server | Microsoft Learn
- Note that TRY_CONVERT is only supported starting from compatibility level 110. For official documentation regarding TRY_CONVERT, please refer to TRY_CONVERT (Transact-SQL) - SQL Server.
- Confirm that the Lansweeper database is set to compatibility level 110 or higher.
Solution
- The database compatibility level has been upgraded to 150.
- The Lansweeper Patch Tuesday report was successfully generated following the adjustment of the compatibility level.
