Creating dashboard in UIM 20.3.x OC gives "Error saving dashboard. Please make sure the name is unique"

Products

• DX Infrastructure Management

Issue/Introduction

Unable to create a new dashboard or edit an existing dashboard with superuser ACL  after upgrading from UIM  8.51 to 20.3.1 and also an Issue occurs with custom dashboard created and designed in UIM 8.51

When trying to save a new dashboard  it shows the following error message: 

Cause

Dashboard table constraint mismatch issue after the upgrade

Environment

Release : 20.3

Component : UNIFIED INFRASTRUCTURE MGMT

Resolution

To Fix, please run the below DDL query. 

--------------------------------------------------------------------------------------------------------------------------------

 

ALTER TABLE umpDashboard ADD CONSTRAINT umpDashboard_pk PRIMARY KEY (id);

 

ALTER TABLE [dbo].[umpDashboard] ADD DEFAULT ((0)) FOR [published]

GO

ALTER TABLE [dbo].[umpDashboard] ADD DEFAULT (getdate()) FOR [created]

GO

ALTER TABLE [dbo].[umpDashboard] ADD DEFAULT (getdate()) FOR [modified]

GO

ALTER TABLE [dbo].[umpDashboard] ADD DEFAULT ((0)) FOR [autoimported]

-------------------------------------------------------------------------------------------------------------------------

 

Please Note : Before executing the query below point has to be taken care 

- Check if any umpDashboard_pk already constraint exist or not. If exists then please drop that constraint

- Stop the Wasp probe on which OC is running 

- Take "umpDashboard" scheme and data backup 

- Please take DBA help to perform above operation 

 

After performing the above activity, please verify the issue and also share the modified "umpDashboard" Table definition