Symptoms
Problems with K2 Workspace after Upgrade
Diagnoses
Upgrading from 4.5 to 4.6.8 . We setup a new IIS server and database server and copied over our previous databases over to the new database server. We then installed fresh with 4.6.8 and went through the install/upgrade process where the configuration analyzer is reporting no errors.
Everything seems to come up okay except when we try to access Reports such as Activity Statistics, Process Information etc.
We get the following errors:
Could not load type 'SourceCode.SmartObjects.Client.ExecuteSQLQueryReaderOptions' from assembly 'SourceCode.SmartObjects.Client, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d'.
Invalid archive type
at SourceCode.Serialization.ArchiveX.GetInt64() at SourceCode.SmartObjects.Client.SmartObject.GetRuntimeData(ArchiveX ax) at SourceCode.SmartObjects.Client.SmartObjectClientServer.ExecuteScalar(SmartObject smartObject, DataTable inputTable) 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: String was not recognized as a valid Boolean.
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)
There was an error when trying to modify a SmartObject service
1058 SourceCode.Security.OAuth.OAuthManagement not hosted!
Resolution
Run the setup manager one more time and selected Configure to go thru the configuration settings. Make sure the reports run after going thru the process.
