Hi, after I upgraded my website to DNN 07.00.05 I get a lot of General Exceptions in my Logfile. I can see 2 or 3 General Exceptions every second in the logfile. This has a huge effect on the database performance and it seems that these errors generate a lot of reads per sec on my datgabase file.

I have manage to find out that if I stop the "Search Engine Scheduler" (under host, schedule) that the errors will stop.

Any tips or suggestions how to fix these errors??

Thankx in advanced :)

Ronald

 

See the complete error below:

General Exception AssemblyVersion 7.0.5 PortalID -1 PortalName UserID -1 UserName ActiveTabI

AssemblyVersion: 7.0.5

PortalID: -1

PortalName:

UserID: -1

UserName:

ActiveTabID: -1

ActiveTabName:

RawURL:

AbsoluteURL:

AbsoluteURLReferrer:

UserAgent:

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID: 8e4dab59-782f-4288-b4d6-a618c888ff68

InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.

StackTrace:

Message: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 PetaPoco.Database.Execute(String sql, Object[] args) at DotNetNuke.Data.DataProvider.DeleteSearchItemWords(Int32 SearchItemId) at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems)

Source:

Hi Ronald,
That error message means that there is a problem with the site talking to its database. Usually an error like this indicates that a module is not properly closing its SQL connections and is doing a "connection leak" to the database.

---

Tony Valenti
Tony.Valenti@PowerDNN.com
+001-402-650-6072

PowerDNN.com - World Leader in DotNetNuke Hosting and DNN Hosting
DNN Hosting Australia - DNN Hosting Europe - DNN Hosting US

Hi,

For information...

I still have a feeling that the "Search Engine Scheduler" is part of the errors. When "Search Engine Scheduler" is stopped, the errors seems to stop and also the reads per sec drops extreme.

Anyone have any indication about
PortalID: -1
UserID: -1

Both does not exist in de database.

Thanks in advanced.

Grtx.
Ronald