DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

Errors before and after upgrade

 4 Replies
 2 Subscribed to this topic
 40 Subscribed to this forum
Sort:
Author
Messages
New Around Here
Posts: 11
New Around Here

DNN software was not working at all. I upgraded from 7.something to 08.00.04 as recommended here:

https://dnndocs.com/conte...rade-path/index.html

The website is running okay, but when editing a page it runs painfully slow - 5 or 10 minutes for any function at all. Tried looking at events, and that page dies with a timeout error.

How can I diagnose this? Would it be better to continue to upgrade to the latest version first? Any further advice?

Veteran Member
Posts: 1246
Veteran Member
MVP
MVP
You're an MVP!
The painfully slow characterization indicates that something is painfully wrong. The trick is to diagnose.

I would start by looking in the Event Log and also the logs in /portals/_default/logs to see if you can locate information about any problems.

Next, I would look at the webserver, database server, and their resources. What do you have? Versions, memory, etc.

Next look at the browser's developer tools to see if you can see any problems in the console window and look at loading and network performance.

Finally, it is possible that there are some issues remaining from the "not working" version. It is hard to guess what they might be from afar.
New Around Here
Posts: 11
New Around Here

Thank you for responding!

I'm not seeing errors in the Event Viewer. I'll see if I can capture some of that today.

Here is a portion of the 2020.07.13.log.resources in /portals/_default/logs from yesterday (635k yesterday). It is full of errors of this sort.

Memory usage on my server is riconsistently running about 98%, CPU beteen 70 and 95%. The only thing running on that machine (it's an Amazon instance) is IIS. We're running IIS version 8, and SQL Server 2014.

2020-07-13 22:37:27,405 [WIN-7SHDS05BLQ4][Thread:12][ERROR] DotNetNuke.Services.Exceptions.Exceptions - System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args)
   at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String procedureName, Object[] commandParameters)
   at DotNetNuke.Data.DataProvider.GetAvailableUsersForIndex(Int32 portalId, DateTime startDate, Int32 startUserId, Int32 numberOfUsers)
   at DotNetNuke.Services.Search.UserIndexer.FindModifiedUsers(Int32 portalId, DateTime startDateLocal, IDictionary`2 searchDocuments, IList`1 profileDefinitions, IList`1& indexedUsers, Int32& startUserId)
   at DotNetNuke.Services.Search.UserIndexer.IndexSearchDocuments(Int32 portalId, ScheduleHistoryItem schedule, DateTime startDateLocal, Action`1 indexer)
ClientConnectionId:e427cdbf-c083-4986-ac64-cb882f518d35
Error Number:-2,State:0,Class:11
 

Senior Member
Posts: 1322
Senior Member
3 Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
Lifesaver
Lifesaver
You're Life Saver!
New Poster
New Poster
Congrats on posting!
3 Engaged Reader
Engaged Reader
You are an engaged reader!

Did you check if the database is running at it's limits?
Try clearing the logs: https://dnncommunity.org/forums/aft/899

New Around Here
Posts: 11
New Around Here

Thank you. I ran the script provided at the link, and it did clear the event log. I'll see if it has any additional good effects.

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved