When accessing "Detailed Site Log" on one of our websites built on DNN 7.3.4, we get this exception:

 Error: Site Log is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Conversion failed when converting the nvarchar value 'A' to data type int. ---> System.Data.SqlClient.SqlException: Conversion failed when converting the nvarchar value 'A' to data type int. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DbEnumerator.MoveNext() at Telerik.Web.UI.GridDataTableFromEnumerable.FillData() at Telerik.Web.UI.GridResolveEnumerable.EnsureInitialized() at Telerik.Web.UI.GridEnumerableFromDataView..ctor(GridTableView owner, IEnumerable enumerable, Boolean CaseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText) at Telerik.Web.UI.GridDataSourceHelper.CreateGridEnumerable(GridTableView owner, IEnumerable enumerable, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText) at Telerik.Web.UI.GridTableView.get_ResolvedDataSource() at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource) at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at Telerik.Web.UI.GridTableView.PerformSelect() at Telerik.Web.UI.GridTableView.DataBind() at DotNetNuke.Modules.Admin.SiteLog.SiteLog.BindData() at DotNetNuke.Modules.Admin.SiteLog.SiteLog.OnDisplayClick(Object sender, EventArgs e) --- End of inner exception stack trace ---

 

I tried scanning contents of the table SiteLog, but did not find any issues. Any ideas on what else I can check? Thanks!

Thank you very much, Sebastian!

On further investigation I found that the stored proc GetSiteLog2 was failing because of a row that contained a UserAgent value of "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) AppleWebKit/537.75.14 (KHTML, like Gecko) Version/7.0.3 Safari/7046A194A"

Thanks for your help.

Hi I got the latest DNN 8.0.0 install and set it up in my webserver and was able to configure the same. I was also able to launch the portal via localhost/appname but when i try to login the site crashes with this error - "Conversion failed when converting the nvarchar value SigmaUse to data type int." Kindly let me know the cause since I have verified the Exception and Eventlog tables etc and the SIteLog table is empty