SymptomsWhen attempting to switch Plesk database provider from MySQL to MSSQL, the process fails and the following error message is displayed:
Error converting data type nvarchar to bigint.
CauseThe issue can occur because of incorrect records in the “limits” table.
ResolutionRemove the incorrect records from the “limits” table using the following query:
delete from limits where concat( '', value + 0 ) != value;