(admin) org.postgresql.util.PSQLException: ERROR: could not create unique index "dwh_cmn_mv_lookup_u1"
Detail: Key (table_name, column_name, table_record_key, lookup_value_key, language_code)=(DWH_INV_INVESTMENT_LN, TU_PLATFORMS_KEY, 5460145, 1, en) is duplicated.
CREATE UNIQUE INDEX DWH_CMN_MV_LOOKUP_U1 ON DWH_CMN_MV_LOOKUP ( TABLE_NAME, COLUMN_NAME, TABLE_RECORD_KEY, LOOKUP_VALUE_KEY, LANGUAGE_CODE )
Detail: Key (table_name, column_name, table_record_key, lookup_value_key, language_code)=(DWH_RIM_RISK, ASSOCIATED_ISSUES_KEY, 5414005, 5414012, en) is duplicated.
This is caused by product defect DE63197
As part of the Defect resolution a cleanup script to clear duplicate rows from PPM and DWH schemas have been provided and it would ensure a smooth 16.0 upgrade.
On-premise Customers running 16.0 upgrades on PostgreSQL environment can raise a Broadcom support case for the Delete script.
Steps to resolve: