DNN Forums

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

EventLog getting millions of entries since upgrade

Sort:
You are not authorized to post a reply.





New Around Here





    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





      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/w...-0y8o5EBYVcCY2yzhTZk






      New Around Here





        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 Around Here





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

          Messaging Dispatch

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

           






          New Around Here





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





            New Around Here





              Cleared Cache and restarted the website and it has stopped.

              317 million rows..whew





              Growing 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 Around Here





                  We are using DNN






                  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.  

                    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