DNN Forums

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

EventLog getting millions of entries since upgrade

 8 Replies
 2 Subscribed to this topic
 33 Subscribed to this forum
Sort:
Author
Messages
Ron
New Around Here
Posts: 7
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


 
    THREAD ID
    35
 

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

 
    EXCEPTION
    Object reference not set to an instance of an object.
 

 
    RESCHEDULED FOR
    1/1/0001 12:00:30 AM
 

 
    SOURCE
    STARTED_FROM_TIMER
 

 
    ACTIVE THREADS
    -3916641
 

 
    FREE THREADS
    3916642
 

 
    READER TIMEOUTS
    0
 

 
    WRITER TIMEOUTS
    0
 

 
    IN PROGRESS
    0
 

 
    IN QUEUE
    10
 


 
    THREAD ID
    35
 

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

 
    EXCEPTION
    Object reference not set to an instance of an object.
 

 
    RESCHEDULED FOR
    1/1/0001 12:00:30 AM
 

 
    SOURCE
    STARTED_FROM_TIMER
 

 
    ACTIVE THREADS
    -3916641
 

 
    FREE THREADS
    3916642
 

 
    READER TIMEOUTS
    0
 

 
    WRITER TIMEOUTS
    0
 

 
    IN PROGRESS
    0
 

 
    IN QUEUE
    10
 

Ideas on what the issue could be?

Many thanks!

Ron

 

Senior Member
Posts: 1607
Senior Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!

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.

<code>/Portals/_default/Logs/</code>

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

Ron
New Around Here
Posts: 7
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

Ron
New Around Here
Posts: 7
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,

 

Ron
New Around Here
Posts: 7
New Around Here
I went into the Scheduler and stopped the schedule (at the top of the schedule page) and the errors still continue.
Ron
New Around Here
Posts: 7
New Around Here
Cleared Cache and restarted the website and it has stopped.

317 million rows..whew
Advanced Member
Posts: 132
Advanced Member
Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
MVP
MVP
You're an MVP!
2 Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!

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.

Ron
New Around Here
Posts: 7
New Around Here

We are using DNN

Senior Member
Posts: 1607
Senior Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!

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.  

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