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:
Dashboard table constraint mismatch issue after the upgrade
Release : 20.3
Component : UNIFIED INFRASTRUCTURE MGMT
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