Data Center Security Server (DCS) Database Upgrade Fails with "Violation of PRIMARY KEY constraint 'REPORT_PK'"

Products

• Data Center Security Server Advanced

Issue/Introduction

1389 2022-02-17 08:25:54.663 [DEBUG] [DatabaseUtil:694] Report Logger Exception occurred.
1390 2022-02-17 08:25:54.663 [DEBUG] [DatabaseUtil:694] Exception Details:java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'REPORT_PK'. Cannot insert duplicate key in object 'dbo.REPORT'. The duplicate key value is (1).
1391 2022-02-17 08:25:54.694 [DEBUG] [DatabaseUtil:699] Exception in thread "main" java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'REPORT_PK'. Cannot insert duplicate key in object 'dbo.REPORT'. The duplicate key value is (1).
1392 2022-02-17 08:25:54.694 [DEBUG] [DatabaseUtil:699]  at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1069)
1393 2022-02-17 08:25:54.694 [DEBUG] [DatabaseUtil:699]  at com.symantec.server.configuration.report.ReportLoader.main(ReportLoader.java:448)
1394 2022-02-17 08:25:54.710 [DEBUG] [DatabaseUtil:708] You may want to investigate possible issue. Exit Value 1
1395 2022-02-17 08:25:54.710 [DEBUG] [DatabaseUtil:716] Investigate error: An error occured while loading DcsReportsMetaData
1396 2022-02-17 08:25:54.710 [ERROR] [ProgressPage$UpgradeDatabaseWorker:2337] java.lang.Exception: An error occured while loading DcsReportsMetaData

Resolution

SOLUTION : Suggested to perform below action plan:

Execute below queries in the Data Center Security database :

DELETE FROM [dbo].[REPORT_FROM_WHERE]
DELETE FROM [dbo].[REPORT_COLUMN]
DELETE FROM [dbo].[REPORT]

Reboot the DCS server after running the above queries and then try to upgrade it to the latest release build.