Email notifications are not being sent from my site. I checked the scheduler and am getting this error from within the scheduler. I checked the database and there is a dbo.vw_MessagesForDispatch view there. Has the name changed?
Thanks
Messaging Dispatch
Messaging Scheduler DoWork Starting 21f4d7a5-aba0-4213-ae8a-a8eb9c1d9f97
Messaging
Scheduler Failed: System.Data.SqlClient.SqlException (0x80131904):
Invalid object name 'dbo.vw_MessagesForDispatch'.
at System.Data.SqlClient.SqlConnection. (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)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader
ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, TaskCompletionSource`1 completion, Int32 timeout, Task&
task, Boolean asyncWrite)
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, String sql, Object[] args)
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()
ClientConnectionId:12615bc0-9abc-49e9-b61e-adc5339eb94f