Hi,

Each time I try to enable this scedule, I get a time out.

EXCEPTION: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
   at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.PurgeLog()
   at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.PurgeLogBuffer()
   at DotNetNuke.Services.Log.EventLog.PurgeLogBuffer.DoWork()

Can anyone help me?

Thanks

Mario
 

=========================================

I'm unable to reply to this thread because it keeps telling me I don't have access.  Anyway,   I believe I have a solution for this problem.  You'll need to truncate the EventLog table.  Use this script and the Host->Sql menu option, substite the things in {}'s, e.g. mine was "truncate table dbo.EventLog"

truncate table {databasOwner}{objectQualifier}Eventlog

Next you need to make sure the PurgeLogBuffer scheduled task is enabled.  Go to Host->Schedule and edit the DotNetNuke.Services.Log.EventLog.PurgeLogBuffer task, make sure it is enable (checkbox) and click update.

Hopefully this fixes the problem.  Good Luck.

Jacob