Server Manager - Update Database - Fatal Error - Central base fails to update - SQL Error could not create unique index dss me val typ pk

Purpose (problem description)

This page troubleshoot the below error message you may face while updating the central database with Servermanager.

SQL Error: ERROR: could not create unique index "dss_me_val_typ_pk"

Observed in CAST AIP

Release	Yes/No
8.3.x

Observed on RDBMS

RDBMS	Yes/No
CSS

Step by Step scenario

Use CUT to update the databases to a more recent CAST version.

Action Plan

Restore the pre-migrated databases (management, central and local databases).

Run the following queries on the pre-migrated central database.

TRUNCATE TABLE dss_metric_value_types;

vacuum FULL dss_metric_types;

Rerun CUT on the pre-migrated databases.
If the previous steps does not resolve the issue, contact CAST Technical Support with below Relevant input in order to reproduce and understand the issue.

This solution may also be valid on similar issues with CUT on either of the tables dss_metric_value_types or dss_metric_types during a central database update. Here are the indexes for these tables which may have this issue:

dss_me_val_typ_pk - dss_metric_value_types index

dss_metr_typ_pk - dss_metric_types index

dss_met_typ_idx2 - dss_metric_types index

Relevant Input

Screenshot showing the issue like below:
Local, Central and Management databases Backup before the migration
Sherlock (CAST Support Tool (CST) - alias Sherlock). Options to select : Export configuration files, Export logs.
CUT log files: To find out the location and the logs to be provided, please refer to CAST Management Studio - Information - How to find logs

Notes/comments

Ticket # 9512

Related Pages