Yesterday I installed the module, and in looking at the Schedule History, I can't tell if it's an error or not. On the one hand, it shows an exception that the "stored procedure 'dbo.DataSprings_RoleReminderGetAllWhoMatchCriteriaByRRID' doesn't exist" etc. On the other hand, at the end it says "Success."
Here is a sample:
DataSprings.DNN.RoleReminder.RoleReminderSchedulerClient,DataSprings.DNN.RoleReminder Start checking. Executing Renewal Reminder For Def:Membership Renewal - 90 Days Out
PortalID: 1 Role ID 6 Renewal ID 1
Exception !: The stored procedure 'dbo.DataSprings_RoleReminderGetAllWhoMatchCriteriaByRRID' doesn't exist.- at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.RoleReminder.SqlDataProvider.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RRID) at DataSprings.DNN.RoleReminder.RoleReminderController.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RoleID) at DataSprings.DNN.RoleReminder.RoleReminderSchedulerClient.SendNotifications()
Finished with this rolename.
Executing Renewal Reminder For Def:Membership Renewal - 60 Days Out
PortalID: 1 Role ID 6 Renewal ID 2
Exception !: The stored procedure 'dbo.DataSprings_RoleReminderGetAllWhoMatchCriteriaByRRID' doesn't exist.- at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.RoleReminder.SqlDataProvider.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RRID) at DataSprings.DNN.RoleReminder.RoleReminderController.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RoleID) at DataSprings.DNN.RoleReminder.RoleReminderSchedulerClient.SendNotifications()
Finished with this rolename.
Executing Renewal Reminder For Def:Membership Renewal - 30 Days Out
PortalID: 1 Role ID 6 Renewal ID 3
Exception !: The stored procedure 'dbo.DataSprings_RoleReminderGetAllWhoMatchCriteriaByRRID' doesn't exist.- at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.RoleReminder.SqlDataProvider.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RRID) at DataSprings.DNN.RoleReminder.RoleReminderController.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RoleID) at DataSprings.DNN.RoleReminder.RoleReminderSchedulerClient.SendNotifications()
Finished with this rolename.
Executing Renewal Reminder For Def:Membership Renewal - 5 Days Out
PortalID: 1 Role ID 6 Renewal ID 4
Exception !: The stored procedure 'dbo.DataSprings_RoleReminderGetAllWhoMatchCriteriaByRRID' doesn't exist.- at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.RoleReminder.SqlDataProvider.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RRID) at DataSprings.DNN.RoleReminder.RoleReminderController.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RoleID) at DataSprings.DNN.RoleReminder.RoleReminderSchedulerClient.SendNotifications()
Finished with this rolename.
Executing Renewal Reminder For Def:Membership Renewal - 1 Days Out
PortalID: 1 Role ID 6 Renewal ID 5
Exception !: The stored procedure 'dbo.DataSprings_RoleReminderGetAllWhoMatchCriteriaByRRID' doesn't exist.- at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.RoleReminder.SqlDataProvider.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RRID) at DataSprings.DNN.RoleReminder.RoleReminderController.RoleReminderGetAllWhoMatchCriteriaByRRID(Int32 RoleID) at DataSprings.DNN.RoleReminder.RoleReminderSchedulerClient.SendNotifications()
Finished with this rolename.
Succeeded.
Steve