Application Delivery Management
Application Modernization & Connectivity
IT Operations Management
When upgrading SSC and running the ssc-migration.sql script, an error is presented regarding a duplicate column name. This describes some troubleshooting steps for finding and fixing the error in MySQL/Linux.
Fortify Software Security Center
Software Security Center
Linux Red Hat
When running the ssc-migration script, the database is throwing duplicate column errors. The script does not complete.
Examples (from 22.2 upgrade):
ERROR 1060 (42S21) at line 19: Duplicate column name 'parserType'.
ERROR 1060 (42S21) at line 21: Duplicate column name 'priorityOverrideActive'.
The character set and collation must match and be case-sensitive. If the character set does not match the collation, the script may err with 'parserType'. Some of the script may actually run and not get rolled back. If this happens, and the script is run again, some columns may already exist.
VERY IMPORTANT: Always have a backup of your database prior to upgrading and/or running any database scripts.
SSC upgrade 22.1 to 22.2 ssc-migration script MySQL duplicate column error Linux Red Hat case-sensitive collation