I'm having a problem accessing the Log Viewer on an intranet installation that's been running rock solid for over a year now.  The version of DNN is 3.2.0 with a SQL 2000 database.

I became aware of the issue when users could not pull the page up.  Everyone was getting the following error:

DotNetNuke Upgrade Error

The Assembly Version ([ASSEMBLYVERSION]) does not match the Database Version ([DATABASEVERSION])

ERROR: Could not connect to database.

Timeout expired.  The timeout period elapsed to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

I was not attempting any upgrades.  Checking the Event Log in Windows did not point to anything. I did an IISReset but I was still getting the same error.  I then rebooted the server and the error continued.   But a few minutes later the issue resolved itself and the page came up.  With the page up I tried to access the DNN Log Viewer but I get the following Error: Log Viewer is currently unavailable.

Since I never made any changes to DNN logs events I'm thinking that the logs are growing too big.  Can anyone tell me which logs I should look at in SQL and the best way to delete or limit their size?

Sorry for the double post.  Scott or anyone with the admin option please delete the other post.  Thank you...

Back to my Log problem...

The Error: Log Viewer is currently unavailable shows up with I try to access the Log Viewer while logged in as an Admin. 

When I log in as Host I get this...

Error: Log Viewer is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Attempt to release mutex not owned by caller. ---> System.ApplicationException: Attempt to release mutex not owned by caller. at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.PurgeLogBuffer() at DotNetNuke.Modules.Admin.Log.LogViewer.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

So I tried it again logged in as Host and now I get this:

Error: Log 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. ---> 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.Modules.Admin.Log.LogViewer.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Thanks Scott...

Would this be a text or some other type of file in the DNN install directory or would I have to go through SQL?  If it's SQL...I'm assuming that it's the EventLog table...but how do I go about deleting all those events?  Any advice on a script I can run to delete all that data?

Never mind I solved my problem...I should have opened up my SQL book before I started spamming this forum

I ran the TRUNCATE TABLE EventLog command and it wiped everything out but kept the table structure.