Last post May 16, 2006 07:39 AM by romia
May 07, 2006 06:43 AM|romia|LINK
Since yesterday I am getting a very strange error whenever I try to access my portal Log Viewer in DotNetNuke version 3.1.1.
The error is as follows:
Error: Log Viewer is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot resolve collation conflict for equal to operation. ---> System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to
operation. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection
connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType
commandType, String commandText, SqlParameter commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object parameterValues) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLog(Int32
PageSize, Int32 PageIndex) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLog(Int32 PageSize, Int32 PageIndex, Int32& TotalRecords) at DotNetNuke.Services.Log.EventLog.LogController.GetLog(Int32 PageSize, Int32 PageIndex, Int32&
TotalRecords) at DotNetNuke.Modules.Admin.Log.LogViewer.BindData() at DotNetNuke.Modules.Admin.Log.LogViewer.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Does anyone know what is the problem??
Please help me..
May 07, 2006 10:01 AM|b_alghazi|LINK
I used to have this error when the log of my site gets too huge, check out
this post for resolution.
May 07, 2006 12:56 PM|romia|LINK
Thank you for the reply but this didn't solve my problem and my dnn site is not that huge (actually we are still deploying it now). I think it is related to collation in some way because this is what the error message say and also my application has COLLATE
Arabic_CI_AI in some modules.
Does anyone have any other suggestion?
May 08, 2006 04:09 PM|portvista|LINK
May 16, 2006 07:39 AM|romia|LINK
First thank you very much for trying to help me with the problem.
I was able to fix it and here is what I have done:
- Added Collate database_default to every equal operation in the stored procedure that was causing the problem (GetEventLog in my case).
The SQL Server will raise errors in case the Collate database_default was used with integer attributes so in order to avoid that don't add the collate with integter attributes.
Now my log viewer is finally working!