Home | Clean Provisioning History failed

Modified on Wed, 10 May, 2023 at 1:12 PM

When does the error occur:
On home - when try to clean the provisioning

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 DBs is up to date, the database is not allowed to consume latest sql technique due to its compatibility setting. The compatibility setting is set to the db version when the DB was created and is not automatically updates when de DBs get a new version.

Solution:
In the sql management studio execute the following statement as an dbowner to change the compatibility setting of the db to SQL Server 2012 (110)

ALTER DATABASE YourDatabase SET COMPATIBILITY_LEVEL = 110;

Document information

Last Modified Date

02.05.2023

Verified versions
five(9)s Console version 4.3

five(9)s Console version 4.2
five(9)s Console version 4.1 or below

Tags

Clean Provisioning History
SQL error

Disclaimer

Even though every care has been taken by five(9)s GmbH to ensure that the information contained in this publication is correct and complete, it is possible that this is not the case. five(9)s GmbH provides the publication "as is", without any warranty for its soundness, suitability for a different purpose or otherwise. five(9)s GmbH is not liable for any damage which has occurred or may occur as a result of or in any respect related to the use of this publication. five(9)s GmbH may change or terminate this publication at any time without further notice and shall not be responsible for any consequence(s) arising there from. Subject to this disclaimer, five(9)s GmbH is not responsible for any contributions by third parties to this publication.