Site was working all fine, did not do any changes since a week. Today logged in and tried to go to Admin->Event Viewer and to my surprise following error. I don't know why and how to fix it. Guru's please help.

I thank you much.

Error: Event Viewer is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) 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.LogController.PurgeLogBuffer() at DotNetNuke.Modules.Admin.Log.LogViewer.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Cathal, sincere thanks for quick reply. My logging is indeed set to "DBLoggingProvider". However, you are right my eventlog has grown to 13500+ and is growing more by 100's every 5 or so mints. I guess this is happening because just today I purchased the "Hacker Safer Certification" for my site and they are running some thorough remote vulnerability scans. I will let the scan finish and then move the data to history table and see if it helps. Will get back to you in next 12 hours.

once again I thank you much for the guidance and will get back to you in 10-12 hours.

Sincerely,

Thanks Cathal, appreciate your help. Actually this did happened because yesterday I purchased hacker safe certification for my site. They ran remote hacking simulations and many other scans which pumped around 13000+ entries in my event log. I so feel that the design should be such that it should page no matter how many rows are in event log, an intelligent pagging mechanism should be able to do that, never the less that's not my immidiate concern.

Can you guide how can I use the "host->scheduler" to purge my event log every 12 hours? I have actually created a history log table, and would like to configure in such a way that all entries from eventlog table be moved to the history table before eventlog is purged - if this not possible, I would atleast like to automatically purge the event log every twelve hours as its too much to log in everyday and purge the event log table manually. I need this as hacker safe run simulations every twelve hours.

I thank you much in advance.

Sincerely,