Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler,DotNetNuke Scheduler ExceptionDotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler,DotNetNuke Scheduler Exception
Previous
 
Next
New Post
10/27/2014 1:20 PM
 

Just after upgrade to v.7.3.3 I'm getting repeatedly the following Core Messages - it seems they are coming Scheduler, but for the better demonstration I'm pasting the events from the Event Viewer.

27/10/2014 3:29:34 μμScheduler Event Failure THREAD ID 16 TYPE DotNetNuke....CoreMessa

THREAD ID:16
TYPE:DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler, DotNetNuke
EXCEPTION:Invalid object name 'dbo.vw_MessagesForDispatch'.
RESCHEDULED FOR:27/10/2014 3:30:04 μμ
SOURCE:STARTED_FROM_TIMER
ACTIVE THREADS:0
FREE THREADS:1
READER TIMEOUTS:0
WRITER TIMEOUTS:0
IN PROGRESS:0
IN QUEUE:6
Server Name: rea

next older event:
27/10/2014 3:29:03 μμScheduler Event Failure THREAD ID 12 TYPE DotNetNuke....CoreMessa

THREAD ID:12
TYPE:DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler, DotNetNuke
EXCEPTION:Invalid object name 'dbo.vw_MessagesForDispatch'.
RESCHEDULED FOR:27/10/2014 3:29:33 μμ
SOURCE:STARTED_FROM_TIMER
ACTIVE THREADS:0
FREE THREADS:1
READER TIMEOUTS:0
WRITER TIMEOUTS:0
IN PROGRESS:0
IN QUEUE:6
Server Name: rea

Does anybody knows what this is and how can I solve it?

I'd appreciate it.

    Activity

    Cathal Connolly added a comment - 2 hours ago

    that's a stored procedure which is expected to exist - the only reason it would not is if you had a failed upgrade (or if you used a 3rd party sql script which dropped it). Typically I would close this and direct you to the forums, but as its easy to fix, here is the script you need (from the 7.2.0 sqldataprovider) - go to host->sql and enter the following:

    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'

    {databaseOwner}{objectQualifier}vw_MessagesForDispatch') and OBJECTPROPERTY(id, N'IsView') = 1)
    DROP VIEW {databaseOwner} {objectQualifier}vw_MessagesForDispatch
    GO

    CREATE VIEW {databaseOwner}[{objectQualifier}

    vw_MessagesForDispatch]
    AS
    SELECT CMR.RecipientID
    ,CMR.MessageID
    ,CMR.UserID
    ,CMR.[Read]
    ,CMR.Archived
    ,CMR.EmailSent
    ,CMR.EmailSentDate
    ,CMR.EmailSchedulerInstance
    ,CMR.CreatedByUserID
    ,CMR.CreatedOnDate
    ,CMR.LastModifiedByUserID
    ,CMR.LastModifiedOnDate
    ,CMR.SendToast
    ,CM.NotificationTypeID
    ,CASE 
    WHEN CM.NotificationTypeID IS NULL
    THEN
    ISNULL ((SELECT UP.[MessagesEmailFrequency] AS Expr1
    FROM

    {databaseOwner}{objectQualifier}CoreMessaging_UserPreferences UP
    WHERE (UP.UserId = CMR.UserID) AND (UP.PortalId = CM.PortalID)), 0)
    ELSE
    ISNULL ((SELECT UP.[NotificationsEmailFrequency] AS Expr1
    FROM {databaseOwner} {objectQualifier}CoreMessaging_UserPreferences UP
    WHERE (UP.UserId = CMR.UserID) AND (UP.PortalId = CM.PortalID)), 2)
    END EmailFrequency
    FROM {databaseOwner}{objectQualifier}

    CoreMessaging_MessageRecipients AS CMR 
    INNER JOIN

    {databaseOwner} {objectQualifier}

    CoreMessaging_Messages AS CM 
    ON CMR.MessageID = CM.MessageID
    GO

    InteliBrain added a comment - 38 minutes ago - edited

    cathal,

    Thanks.

    I really appreciate what you did 

    The script executed successfully, but I still get System.Data.SqlClient.SqlConnection. errors

    AssemblyVersion:7.3.3
    PortalID:-1
    PortalName:
    UserID:-1
    UserName:
    ActiveTabID:-1
    ActiveTabName:
    RawURL:
    AbsoluteURL:
    AbsoluteURLReferrer:
    UserAgent:
    DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
    ExceptionGUID:39431e01-5f0b-4e19-b32a-eb1e5adc7b3a
    InnerException:Invalid object name 'dbo.vw_MessagesForDispatch'.
    FileName:
    FileLineNumber:0
    FileColumnNumber:0
    Method:System.Data.SqlClient.SqlConnection.
    StackTrace:
    Message:
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.vw_MessagesForDispatch'.
    at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    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 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
    at DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args)
    at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, Int32 timeout, String sql, Object[] args)
    at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String procedureName, Object[] commandParameters)
    at DotNetNuke.Services.Social.Messaging.Data.DataService.GetNextMessagesForInstantDispatch(Guid schedulerInstance, Int32 batchSize)
    at DotNetNuke.Services.Social.Messaging.Internal.InternalMessagingControllerImpl.GetNextMessagesForInstantDispatch(Guid schedulerInstance, Int32 batchSize)
    at DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler.HandleInstantMessages(Guid schedulerInstance)
    at DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler.DoWork()

    and:

    THREAD ID:5
    TYPE:DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler, DotNetNuke
    EXCEPTION:Invalid object name 'dbo.vw_MessagesForDispatch'.
    RESCHEDULED FOR:27/10/2014 6:33:00 μμ
    SOURCE:STARTED_FROM_TIMER
    ACTIVE THREADS:0
    FREE THREADS:1
    READER TIMEOUTS:0
    WRITER TIMEOUTS:0
    IN PROGRESS:0
    IN QUEUE:6
    Server Name: rea

    Cathal Connolly added a comment - 29 minutes ago

    not sure, I would guess that your site uses an objectQualifier and that you perhaps ran a script (such as turbosql) that altered core tables and didn't use that objectQualifier - either way this is not an issue we can recreate so please raise it in the forums/exchange area on dnnsoftware.com

    InteliBrain added a comment - 23 minutes ago

    Yes, you are right.

    Thanks or the support.

    I will do that.

    Best Regards.


    Panagiotis Mylonas Managing Director InteliBrain http://InteliBrain.gr
     
    New Post
    10/28/2014 7:52 AM
     
    Panagiotis,

    TurboDNN replaces the stored procedure by an optimized version, there must be a different reason for your issue.

    However, please make sure after an upgrade to re-apply TurboDNN script (and TurboSchema for best performance)

    Cheers from Germany,
    Sebastian Leupold (Microsoft MVP)

    dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

    Speed up your DNN Websites with TurboDNN
     
    New Post
    10/31/2014 12:19 PM
     

    Sebastian,

    I reverted back to another older DB instance because Turbo DNN script have caused undoubtedly significant problems and lots of lost time !


    Panagiotis Mylonas Managing Director InteliBrain http://InteliBrain.gr
     
    New Post
    10/31/2014 12:20 PM
     

    I cannot port issues arisen from these scripts and not having the official DNN Community support.


    Panagiotis Mylonas Managing Director InteliBrain http://InteliBrain.gr
     
    New Post
    2/10/2015 6:31 PM
     
    Panagiotis

    Did you ever figure this out?

    I am having the same issue
     
    Previous
     
    Next
    HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler,DotNetNuke Scheduler ExceptionDotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler,DotNetNuke Scheduler Exception


    These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

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

    1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
    2. 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.
    3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
    4. No Flaming or Trolling.
    5. No Profanity, Racism, or Prejudice.
    6. Site Moderators have the final word on approving / removing a thread or post or comment.
    7. English language posting only, please.

    Content Layout

    Subscribe to DNN Digest

    Subscribe to DNN Digest

    DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


    Copyright 2017 by DNN Corp Terms of Use Privacy
    What is Liquid Content?
    Find Out
    What is Liquid Content?
    Find Out
    What is Liquid Content?
    Find Out