Symptoms

When attempting to load any report from K2 workspace (i.e. Process Overview) the following error occurs:

An error occurred loading the report. Click on Details below for more information.
Details
Service: K2GenericSettings Service Guid: f832fc2c-55eb-4635-8837-61879cb1feff Severity: Information Error Message: The save method failed InnerException Message:
at SourceCode.Workspace.OOBReports.K2ReportSettingsHelper.SetReportConfigString(String value, String reportID) at SourceCode.Workspace.OOBReports.K2ReportSettingsHelper.SaveReportConfigEventArgs(ReportConfigEventArgs e) at SourceCode.Workspace.OOBReports.K2ReportViewer.LoadReportConfig(Boolean mustSetValue, Boolean isDrillThrough, LocalReport localReport) at SourceCode.Workspace.OOBReports.K2ReportViewer.OnInit(EventArgs e)
 

Diagnoses

This occurs when No Count is enabled on the database.
 

Resolution

1. Open SQL Management Studio
2. Right click on the server name and select properties
3. Select the 'Connection' option
4. Uncheck 'no count' under the "Default connection options" if it is selected
5. Restart the SQL instance
6. Load the report in K2 Workspace