cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Duplicate column name error message when importing patches

Duplicate column name error message when importing patches

You may see an error message while importing a cumulative database patch script such as the following:

ERROR 1060 (42S21) at line 11: Duplicate column name 'decision_certification_id'

In most cases these error messages are benign during the import of DB patch scripts on top of existing patches.

If your database version does not automatically ignore errors during the execution of ddl scripts you will need to add an option to the command line to force the entire DDL file to be interpreted.

For example in MySQL this is:  mysql --force < iiq-patch.ddl

Labels (1)
Version history
Revision #:
4 of 4
Last update:
‎Feb 15, 2023 11:08 PM
Updated by:
 
Contributors