running DNN 4.9.5 & RR1.0.1
Looking at the Schedule History every now and then (I think its when something is supposed to be sent, though some items are being sent) the following error occurs:
Exception !: Cannot drop the table '##tempRR', because it does not exist or you do not have permission. There is
already an object named '##tempRR' in the database.- at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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.ExecuteReader(CommandBehavior behavior) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction,
CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership
connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString,
CommandType commandType, String commandText, SqlParameter[] commandParameters) 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.
How can this be fixed permanently and more importantly is there a way to resend the ones that didn't get sent?
TIA
Antony