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)"
Control Compliance Suite 12.5 (clean install and upgrade)
Issue was found and fixed in SQL code.
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