Home | Clean Provisioning History failed

An error can occur when cleaning up the provisioning history on the Home page.

Error in log file:
2019-12-04 16:33:42,452 [124] ERROR Data - Data RemoveProvisioningHistory System.Data.SqlClient.SqlException (0x80131904): 'TRY_CONVERT' is not a recognized built-in function name. at ...

Reason:
Even if the database (DB) is up to date, it might not support the latest SQL techniques due to its compatibility setting. The compatibility setting is initially set at the time of database creation and is not automatically updated when the DB is upgraded or moved to a newer version.

Solution:
In SQL Management Studio, execute the following statement as a db_owner to change the database compatibility setting to SQL Server 2012:

ALTER DATABASE YourDatabase SET COMPATIBILITY_LEVEL = 110;

Tags

• Clean Provisioning History
• SQL error