SQL Script error during upgrade from 17.1 to 17.2

Symptom:  Running the mssql_upgrade_17.1_to_17.2.sql script the following error happens at the end:

ERROR: Occurred at Stage 3
Code: 245
Message : Conversion failed when converting the varchar value 'Disabled' to data type bit.


Cause: The script attempts to insert some values in a table without explicitly defining the column order.  On some older databases, the columns were originally created in a different order, causing the issue seen in the error message above.


Solution:  Run the attached modified version of the upgrade script, which will specify the columns in the correct order.

Was this article helpful?
0 out of 0 found this helpful