Forums > Product Discussion - DotNetNuke Modules > Renewal Reminder
Is this an error?
Last Post 10-21-2009 07:28 AM by David To. 6 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Stephen NillUser is Offline
going with the flow
going with the flow
Posts:66
Avatar

--
05-08-2009 11:38 AM

    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
    Stephen NillUser is Offline
    going with the flow
    going with the flow
    Posts:66
    Avatar

    --
    05-23-2009 02:50 PM

    Is there any chance someone could respond to my posting?

    Thanks,

    Steve
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-26-2009 09:12 AM
    HI Stephen, the original RR trial / release version had some tokens that weren't mapped and the un-install of the trial didn't have the removal of the stored procedure. I've sent you the latest release version through email. Can you see if this resolves the issue you've been having? Thanks. -- David
    morganUser is Offline
    skipping stones
    skipping stones
    Posts:9
    Avatar

    --
    10-01-2009 09:28 AM
    I also am getting this error. I had installed the trial version then purchased the module and installed it over the trial. What do I need to do to get this working properly? Thanks!
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    10-01-2009 09:43 AM
    I just sent you the latest patch. -- David
    jeropsUser is Offline
    river guide
    river guide
    Posts:99
    Avatar

    --
    10-20-2009 05:51 PM

    Hi,

    I'm having the very same issue...how do I get the patch?   Can you post the patch on snowcovered at Patches and Hotfixes?  Or Email it? 

    Thanks
    Jerry
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    10-21-2009 07:28 AM
    Hi Jerry, I sent you an email to reply back with your OrderID and I'll send you the latest patch. -- David

    Forums > Product Discussion - DotNetNuke Modules > Renewal Reminder
    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi