Upgrade failure - duplicate key on 'niku.DWH_META_COLUMNS' with index 'DWH_META_COLUMNS_U1'

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Upgrading from 16.3.0 to 16.3.3 and it's failing on 16.3.3 with error:

12/19/25 7:15 AM (ExecTask) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'niku.DWH_META_COLUMNS' and the index name 'DWH_META_COLUMNS_U1'. The duplicate key value is (dwh_task_v, dwh_inv_task, pct_complete, pct_complete).

Upon checking we see two records with dwh_column_name pct_complete

Environment

Clarity 16.3.3

Resolution

Workaround:

Remove the extra entry before starting the upgrade to 16.3.3:

1. Backup table DWH_META_COLUMNS
2. Run the delete statement (should delete 1 record):
   • delete from dwh_meta_columns where attribute_code = 'prpctcomplete' and src_table_name ='dwh_task_v' and src_column_name ='pct_complete'
   • commit
3. Restart the upgrade
4. After upgrade, check that the records look correct, with query:
   • select * from dwh_meta_columns where attribute_code like 'prpctcomplete%'
   • You should be seeing the records as below: