• Login
  • Register

DNN Forums

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

EventLog getting millions of entries since upgrade

You are not authorized to post a reply.
Sort:


New Member


Posts:7
New Member

    We upgraded our system recently from 9.3.1 to 9.10.1 and I am now seeing millions of entries in the event log.

    We only have a few non DNN extensions installed:

    • DNNSmart.SuperFAQ 2.4.0
    • DNNStuff - SQLViewPro 4.1.1 (upgrade to 5 is planned)
    • EasyDNNstyleWizard 4.1.0
    • Live Forms 6.1.4
    • Feedback 6.5.1

    The errors are:SCHEDULER_EVENT_FAILURE and SCHEDULER_EXCEPTION

    <LogProperties>
      <LogProperty>
        <PropertyName>THREAD ID</PropertyName>
        <PropertyValue>35</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>TYPE</PropertyName>
        <PropertyValue>DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler, DotNetNuke</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>EXCEPTION</PropertyName>
        <PropertyValue>Object reference not set to an instance of an object.</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>RESCHEDULED FOR</PropertyName>
        <PropertyValue>1/1/0001 12:00:30 AM</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>SOURCE</PropertyName>
        <PropertyValue>STARTED_FROM_TIMER</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>ACTIVE THREADS</PropertyName>
        <PropertyValue>-3916641</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>FREE THREADS</PropertyName>
        <PropertyValue>3916642</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>READER TIMEOUTS</PropertyName>
        <PropertyValue>0</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>WRITER TIMEOUTS</PropertyName>
        <PropertyValue>0</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>IN PROGRESS</PropertyName>
        <PropertyValue>0</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>IN QUEUE</PropertyName>
        <PropertyValue>10</PropertyValue>
      </LogProperty>
    </LogProperties>

    <LogProperties>
      <LogProperty>
        <PropertyName>THREAD ID</PropertyName>
        <PropertyValue>35</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>TYPE</PropertyName>
        <PropertyValue>DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler, DotNetNuke</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>EXCEPTION</PropertyName>
        <PropertyValue>Object reference not set to an instance of an object.</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>RESCHEDULED FOR</PropertyName>
        <PropertyValue>1/1/0001 12:00:30 AM</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>SOURCE</PropertyName>
        <PropertyValue>STARTED_FROM_TIMER</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>ACTIVE THREADS</PropertyName>
        <PropertyValue>-3916641</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>FREE THREADS</PropertyName>
        <PropertyValue>3916642</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>READER TIMEOUTS</PropertyName>
        <PropertyValue>0</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>WRITER TIMEOUTS</PropertyName>
        <PropertyValue>0</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>IN PROGRESS</PropertyName>
        <PropertyValue>0</PropertyValue>
      </LogProperty>
      <LogProperty>
        <PropertyName>IN QUEUE</PropertyName>
        <PropertyValue>10</PropertyValue>
      </LogProperty>
    </LogProperties>

    Ideas on what the issue could be?

    Many thanks!

    Ron

     



    Veteran Member


    Posts:370
    Veteran Member

      Hello Ron: 

      You'll want to also review the event log files at the following location.  You might find more events logged that could help troubleshoot this issue for you.  I haven't personally seen that message logged on our upgraded sites yet.

      /Portals/_default/Logs/

      In the meantime, if you're not using the messaging feature right now, you could just disable that task.  

      Video:  https://www.youtube.com/watch?v=s6Y...cCY2yzhTZk

      Will Strohl

      Upendo Ventures DNN experts since 2003
      Official provider of the DNN-based E-Commerce w/ Hotcakes Commerce Cloud and SLA support


      New Member


      Posts:7
      New Member

        Hello Will, thanks for the assist!

        I am not sure what the Messaging service is used for (I did disable it) and the errors continue.

        I see this in the current schedule:

        Evotiva UserFiles Scheduler


        11/15/2021 11:09:02 - Starting Operations.
        Clearing Temp folders.
        UserFiles Scheduler Failed: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.Evotiva_Folders_Log'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 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 TruuTJc1mC2v_fSsAHIvWC65my8dGMjp9bRJ$MB85fxZS4sGnWmdUjTLQy9Q5wjrQQ.Zmy$l2S_qzwO6uWjKBy7nbE2nOLDSF4n1iux5Ml0HrKW() at Evotiva.DNN.Modules.UserFiles.UserFilesSchedule.DoScheduledWork() at Evotiva.DNN.Modules.UserFiles.UserFilesSchedule.DoWork() ClientConnectionId:4a94a79c-6d98-4ed1-9438-b2f5a8ee23de Error Number:208,State:1,Class:16



        New Member


        Posts:7
        New Member

          I did look at each task and that is the only one that references:

          Messaging Dispatch

          DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler,

           



          New Member


          Posts:7
          New Member

            I went into the Scheduler and stopped the schedule (at the top of the schedule page) and the errors still continue.


            New Member


            Posts:7
            New Member

              Cleared Cache and restarted the website and it has stopped.

              317 million rows..whew


              Basic Member


              Posts:94
              Basic Member

                Just confirming that you are NOT an Evoq customer correct?

                We have seen this issue with Evoq only installations, to the point that they are recommending that with Evoq that you stop the scheduler before you upgrade the site.

                Mitchel Sellers
                Technology Advisory Group Leader
                CEO @ IowaComputerGurus, Inc. a DNN & .NET Solutions Provider
                Technical Blog: MitchelSellers.com


                New Member


                Posts:7
                New Member

                  We are using DNN



                  Veteran Member


                  Posts:370
                  Veteran Member

                    Sorry I'm just now getting back to this.  I get hundreds of e-mails from the community site every week.  

                    It sounds like you have or had Evotiva's User Files extension installed.  Either it didn't fully uninstall or there's an update to be made.  If you can, I'd suggest upgrading the extension as soon as you can.  If the extension is no longer in use, I'd suggest contacting support at Evotiva so they can help you with getting rid of any remnants.  

                    Will Strohl

                    Upendo Ventures DNN experts since 2003
                    Official provider of the DNN-based E-Commerce w/ Hotcakes Commerce Cloud and SLA support
                    You are not authorized to post a reply.

                    These Forums are dedicated to 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 send an email to [email protected]
                    2. No Advertising. This includes 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