General Data Protection Regulation (GDPR) Dashboard missing and/or Center for Internet Security (CIS) - Critical Security Controls Dashboard returning busy error message.

Products

• Control Compliance Suite Windows

Issue/Introduction

Cannot find the GDPR dashboard.

When you click on CIS or GDPR dashboard you get a "server busy" message.

 

2019-02-07 07:44:25.575,2019-02-07 07:44:25.575,APP01,Error,DynamicDashboard,w3wp,3384,,16,GetParamSQL,,0,0,Error generating parameterized SQL statement
2019-02-07 07:44:25.632,2019-02-07 07:44:25.632,APP01,Error,DynamicDashboard,w3wp,3384,,16,ValidateCommand,,0,0,"System.InvalidOperationException:
ExecuteReader: 
CommandText property has not been initialized
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task,Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Symantec.CSM.DynamicDashboard.Business.QueryBase.Execute(StringconnectionString, Int32 timeout)
   at Symantec.CSM.DynamicDashboard.Business.QueryBase.Execute(StringconnectionString)
   at Symantec.CSM.DynamicDashboard.Views.UI.CCSChart.BindChartViaRows_Pie(CCSPanel panel)
   at Symantec.CSM.DynamicDashboard.Views.UI.CCSChart.BindChartViaRows(CCSPanel panel)
   at Symantec.CSM.DynamicDashboard.Views.UI.CCSChart.LoadChartData(CCSPanel panel, String dashboardPanelId, Int32 width, Int32 height)"

Cause

Issue was found and fixed in SQL code.

Environment

Control Compliance Suite 12.5 (clean install and upgrade)

Resolution

They are 2 separate scripts depending of the version you are running. These script will also fix the CIS dashboard error.

Warning : Before running any script make sure you have a Database backup.

Use SQL management studio, select the CCS reporting database:

For CCS 12.5 (Upgraded to 12.0)  - GDPR dashboard not working -> Run the gdpr-MCC-datamodel-changes.sql

For CCS 12.5 (clean installation) - GDPR Dashboard missing -> Run the GDPR-Dashboard.sql