DNN Forums

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

Errors before and after upgrade

Sort:
You are not authorized to post a reply.





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





      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.
      Joe Craig
      DNN MVP
      Patapsco Research Group





      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
         






        Veteran Member





          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





            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.

            You are not authorized to post a reply.

            These Forums are dedicated to the discussion of DNN Platform.

            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