Symptoms

K2 Database Master Key Issue
 

Diagnoses

Error occurs in workspace when going to the main site page:

Please create a master key in the database or open the master key in the session before performing this operation. The key 'SCSSOKey' is not open. Please open the key before using it.
at SourceCode.Hosting.Client.BaseAPI.BaseAPIConnection.RemoteCall(String TypeName, String MethodName, Objectc] Parameters, Booleana] NullList, MarshalMessageType CallType) at SourceCode.Hosting.Client.BaseAPI.BaseAPI.RemoteCall(String TypeName, String MethodName, Objectc] Parameters, Booleana] NullList, MarshalMessageType CallType) at SourceCode.Hosting.Client.BaseAPI.BaseAPI.RemoteSessionCall(String TypeName, String MethodName, Objectc] Parameters) at SourceCode.SmartObjects.Client.SmartObjectClientServer.GetSmartObject(String systemName) at SourceCode.Workspace.OOBReports.K2ReportSettingsHelper.GetReportConfigString(String reportID) at SourceCode.Workspace.OOBReports.K2ReportSettingsHelper.LoadReportConfigEventArgs(String reportID) at SourceCode.Workspace.OOBReports.K2ReportViewer.LoadReportConfig(Boolean mustSetValue, Boolean isDrillThrough, LocalReport localReport)

Could not Initialise ReportFilterControl: Failed to build CriteriaTable Scheme: Please create a master key in the database or open the master key in the session before performing this operation. The key 'SCSSOKey' is not open. Please open the key before using it.
at SourceCode.Workspace.OOBReports.ReportFilterControl.Initialise(String filterXML, String filterObject, K2ReportViewerConfiguration currentConfiguration) at SourceCode.Workspace.OOBReports.ReportConfigControl.Initialise(ReportConfigEventArgs e, K2ReportViewerConfiguration reportViewerConfiguration, XmlDocument reportListXMLDoc, Boolean initialiseFilter) at SourceCode.Workspace.OOBReports.ReportConfigControl.Initialise(ReportConfigEventArgs e, K2ReportViewerConfiguration reportViewerConfiguration, XmlDocument reportListXMLDoc) at SourceCode.Workspace.OOBReports.K2ReportViewer.LoadReportConfig(Boolean mustSetValue, Boolean isDrillThrough, LocalReport localReport) at SourceCode.Workspace.OOBReports.K2ReportViewer.OnInit(EventArgs e)

 

Resolution

Please do contact K2 support to obtain a script to resolve the issue here.