Updating the metadata fails with "Column name "XXX" in table 'DSSCSDEVCKEY' is specified more than once." error.
SYMPTOM
When trying to perform an update of the metadata via Configuration Wizard, the user will get an error thrown, stating that there is a column specified more than once in the table DSSCSDEVCKEY
CAUSE
This is caused usually by a duplicated column, that could have been originated by an upgrade that didn't complete successfully
ACTION
Perform a backup of the metadata
Open DB Query Tool and connect to the metadata
Run the following commands:
ALTER TABLE DSSCSDEVCKEY DROP COLUMN TOKEN_TYPE;
ALTER TABLE DSSCSDEVCKEY DROP COLUMN CREATION_TIME;
ALTER TABLE DSSCSDEVCKEY DROP COLUMN MODIFICATION_TIME;
KB442020
